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

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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?

Environment

TDM Web Portal
Test data Manager

Resolution

First, find the object ID 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}\