Can't delete registered-unshredded XSD created while connection to OrientDB was down

Document ID : KB000116661
Last Modified Date : 01/10/2018
Show Technical Document Details
Issue:
While attempting to register/shred an XSD schema, the connection to the OrientDB was down and shredding failed. The object was still registered however and cannot be deleted from the Portal UI. How can this object be deleted.
Resolution:
First, find the object ID from from within the Portal UI:


Next, connect to the GTREP and run the following query:
select fd_file_location from gtrep_file_def where fd_file_id = {OBJECTID}

Make note of the location returned - for example:
C:\ProgramData\CA\CA Test Data Manager Portal\objects\projects_{PROJECTID}\versions_{VERSIONID}\{REGISTERED OBJECT NAME}\uploadedschema

Then, run the following queries:
delete from gtrep_file_attr where fa_file_id = {OBJECTID}
delete from gtrep_file_def where fd_file_id = {OBJECTID}

Once the queries have been run, delete the parent folder (along with all sub-folders and files) from the location returned in the first query:
C:\ProgramData\CA\CA Test Data Manager Portal\objects\projects_{PROJECTID}\versions_{VERSIONID}\{REGISTERED OBJECT NAME}\