rg.postgresql.util.PSQLException: ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" Detail: Key (metadata_field_id)=(90) is still referenced from table "metadatavalue".

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" Detail: Key (metadata_field_id)=(90) is still referenced from table "metadatavalue".
via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" Detail: Key (metadata_field_id)=(90) is still referenced from table "metadatavalue".
via adempiere by chst0
, 1 year ago
ERROR: could not load library "/home/postgres/ADempiere/postgresql/8.2.3/lib/pljava.so": libjvm.so: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis nicht gefunden
rg.postgresql.util.PSQLException: ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" Detail: Key (metadata_field_id)=(90) is still referenced from table "metadatavalue".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:421)
at org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:760)
at org.dspace.content.MetadataField.delete(MetadataField.java:485)
at org.dspace.app.xmlui.aspect.administrative.FlowRegistryUtils.processDeleteMetadataField(FlowRegistryUtils.java:398)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.