search

NCEAS / metacat

Data repository software that helps researchers preserve, share, and discover data
https://knb.ecoinformatics.org/software/metacat
GNU General Public License v2.0
26 stars 12 forks source link

Not able to delete DPs from KNB #319

Closed mbjones closed 5 years ago

mbjones commented 6 years ago

Author Name: Saurabh Garg (Saurabh Garg) Original Redmine Issue: 2130, https://projects.ecoinformatics.org/ecoinfo/issues/2130 Original Date: 2005-06-17 Original Assignee: ben leinfelder

Not able to delete rwilliams.4.1 and rwilliams.10.1 from KNB. The message sent back by Metacat is Docid rwillliams.4.1 does not exsist. Please check that you have specified the revision number of the document also

This error is generated in DocumentImpl after running followign query: "SELECT * FROM xml_documents WHERE docid = ?" (The logs indicate that ? was replaced by rwilliams.4)

If no record is found, then the above error is generated. Otherwise the document is deleted. Hence it means no document was found.

However, running the same query via sqlplus returns one record. Weird.

mbjones commented 6 years ago

Original Redmine Comment Author Name: Redmine Admin (Redmine Admin) Original Date: 2013-03-27T21:19:13Z

Original Bugzilla ID was 2130

mbjones commented 6 years ago

Original Redmine Comment Author Name: ben leinfelder (ben leinfelder) Original Date: 2013-04-10T18:20:56Z

Both of these documents still exist - not sure if they should be deleted or not. They are -//ecoinformatics.org//eml-dataset-2.0.0beta6//EN docs.