Hello Stanislav, are you using Postgres or Oracle and is this an original 4.0 installation or did you upgrade from an older version? If you are using Postgres and did upgrade there may have been an issue with the upgrade process. The constraint is here: https://github.com/DSpace/DSpace/blob/dspace-4.0/dspace/etc/postgres/database_schema.sql#L410 and was added during 1.5 to 1.6 https://github.com/DSpace/DSpace/blob/dspace-4.0/dspace/etc/postgres/database_schema_15-16.sql#L106
You may inspect your db for the foreign keys: psql [YourDBName] \d [TableName] will show you the foreign keys. \d community2collection There has been an issue with the upgrade process, maybe your problem in an aftereffect of this: http://dspace.2283337.n4.nabble.com/Dspace-tech-running-the-15-to-16-script-td3280357.html Hope this helps Claudia Am 04.05.2018 um 04:07 schrieb Stanislav Orlov:
Greetings! When I try to delete collections in DSpace 4.0 on Windows Server 2008, I have the following error: org.postgresql.util.PSQLException: ERROR: constraint "comm2coll_collection_fk" does not exist Our PostgreSQL has a "community2collection" table with one foreign key - "community_id" - so I don't know what needs to be done to fix it. You help will be most welcome. Stan
Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Vielen Dank. Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen Schriftstücks per Telefax erfolgen. Important note: The information included in this e-mail is confidential. It is solely intended for the recipient. If you are not the intended recipient of this e-mail please contact the sender and delete this message. Thank you. Without prejudice of e-mail correspondence, our statements are only legally binding when they are made in the conventional written form (with personal signature) or when such documents are sent by fax. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
