https://redmine.dataone.org/https://redmine.dataone.org/favicon.ico2014-09-08T16:40:41ZDataONE TasksMember Nodes - Task #6363: Add the ORNL Mercury schema to the object format listhttps://redmine.dataone.org/issues/6363?journal_id=211802014-09-08T16:40:41ZChris Jonescjones@nceas.ucsb.edu
<ul></ul><p>I've added the object format to subversion, but am getting SQL errors in the stage environment when updating the object format list:<br>
<br>
metacat 20140908-16:20:21: [ERROR]: DocumentImpl.writeDocumentToDB - SQL error: ERROR: update or delete on table "xml_nodes" violates foreign key constraint "xml_index_nodeid_fk" on table "xml_index" [edu.ucsb.nceas.metacat.DocumentImpl]<br>
metacat 20140908-16:20:21: [ERROR]: DocumentImpl.write - Problem with parsing: Error in DBSaxHandler.startElement for action UPDATE : ERROR: update or delete on table "xml_nodes" violates foreign key constraint "xml_index_nodeid_fk" on table "xml_index" [edu.ucsb.nceas.metacat.DocumentImpl]<br>
metacat 20140908-16:20:21: [WARN]: MetacatHandler.handleInsertOrUpdateAction - General error when writing eml document to the database: Error in DBSaxHandler.startElement for action UPDATE : ERROR: update or delete on table "xml_nodes" violates foreign key constraint "xml_index_nodeid_fk" on table "xml_index" [edu.ucsb.nceas.metacat.MetacatHandler]</p>
<p>I'm troubleshooting this now.</p>
Member Nodes - Task #6363: Add the ORNL Mercury schema to the object format listhttps://redmine.dataone.org/issues/6363?journal_id=212012014-09-09T18:24:23ZChris Jonescjones@nceas.ucsb.edu
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Testing</i></li></ul><p>Fixed. On the CNs, we have fairly recently set the database.usexmlindex property in Metacat to false, but when we first inserted the object format list, it was set to true. This caused a SQL foreign key constraint exception when updating the list. To fix this, I've truncated the xml_index table on all 3 CNs in the stage environment.</p>
Member Nodes - Task #6363: Add the ORNL Mercury schema to the object format listhttps://redmine.dataone.org/issues/6363?journal_id=217402014-09-29T21:25:41ZLaura Moyerslmoyers1@utk.edu
<ul><li><strong>Target version</strong> changed from <i>Deploy by end of Y1Q1</i> to <i>Deploy by end of NCTE</i></li></ul> Member Nodes - Task #6363: Add the ORNL Mercury schema to the object format listhttps://redmine.dataone.org/issues/6363?journal_id=230872014-11-24T14:57:19ZLaura Moyerslmoyers1@utk.edu
<ul><li><strong>Target version</strong> changed from <i>Deploy by end of NCTE</i> to <i>Operational</i></li></ul> Member Nodes - Task #6363: Add the ORNL Mercury schema to the object format listhttps://redmine.dataone.org/issues/6363?journal_id=230902014-11-24T19:07:49ZChris Jonescjones@nceas.ucsb.edu
<ul><li><strong>Status</strong> changed from <i>Testing</i> to <i>Closed</i></li><li><strong>translation missing: en.field_remaining_hours</strong> set to <i>0.0</i></li></ul><p>This format has been added to production as well.</p>