Genesys upload error
When trying to upload accessions from one of our collections we got the following error:
Upload operation was stopped due to many errors while uploading accessions to Genesys.
For each item in the operationErrorsarray we got the following error:
could not execute batch; SQL [delete from accession_collect where id=? and version=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch\ncould not execute batch\n(conn=965177) Cannot delete or update a parent row: a foreign key constraint fails (
sandbox.
accession_collect_name, CONSTRAINT
FK_g6h5uuvq16105ljx8r1jjxojr FOREIGN KEY (
collectId) REFERENCES
accession_collect (
id) ON DELETE NO ACTION ON UPDATE NO ACTION)\n(conn=965177) Cannot delete or update a parent row: a foreign key constraint fails (
sandbox.
accession_collect_name, CONSTRAINT
FK_g6h5uuvq16105ljx8r1jjxojr FOREIGN KEY (
collectId) REFERENCES
accession_collect (
id) ON DELETE NO ACTION ON UPDATE NO ACTION)
Request sample: request.json
Last Server Response: output.json