Describe the issue or problem
I am getting the following error when trying to import publications from XML I generated from the data from our earlier system using native tool:
SQLSTATE: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
submission_files_source_submission_file_id_foreign FOREIGN KEY (
submission_file_id) ON DEL) (SQL: insert into
viewable) values (2023-09-19 09:48:13, 4, 2, 1, 1, 4, 2023-09-19 09:48:13, 1, 1))
Steps I took leading up to the issue
importing XML using native XML import tool. The submission file is embedded in XML. I have also set file id advice=“ignore” but I am now unsure how I should handle submission_file_ids in XML. What IDs should I set?
What application are you using?