Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Deleting a Custom Object Definition

You must take some precautions when you are about to delete a custom object definition.

Deleting a Custom Object Definition

Instances of custom objects become rows in the T_PROJECT database table. If your database has such instances in existence, you must delete those rows before deleting the object definition. Locate the Y_OBJECT_DEFINITION table row that corresponds to the object definition that you wish to delete, and note the value of column APPLICATION_ID in that row. Then run a manual SQL query that deletes T_PROJECT rows where column APPLICATION_ID contains that value.

In addition, if you are running Data Warehouse, ensure that the Data Warehouse synchronization job runs after you have deleted the T_PROJECT rows, and before you actually delete the object definition itself. Data Warehouse tracks any deletions that are done against T_PROJECT and it cannot properly process those deletions if the matching object definition is already gone at the time that the synchronization job runs. After synchronization is complete, you may delete the object definition.

  • Was this article helpful?