Ivan Masár created DS-1420:
------------------------------
Summary: Exception handling for deleting a metadata field (XMLUI)
Key: DS-1420
URL: https://jira.duraspace.org/browse/DS-1420
Project: DSpace
Issue Type: Bug
Components: XMLUI
Affects Versions: 3.0
Reporter: Ivan Masár
Fix For: 3.1
I'm not sure if this is a duplicate of DS-12, which is marked as fix.
But in XMLUI after deleting a metadata field that still has values present this
error page shows up:
org.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".
Here's the Java stacktrace:
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.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
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)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
