-
In some cases, cleaning objects causes a loss of data. Before working through this procedure, try to find a matching error message in the Database Integrity Help. The What You Should Do section of each error topic may contain steps that fix the error without loss of data.
-
Before running this command, make a backup of all the databases. You can later provide this backup to customer support if further analysis is needed. See Backup Command.
-
Start the software.
-
Click Tools > Custom Commands.
-
Click Add on the dialog.
-
In the Command ProgID box, type SP3DCleanDatabaseCmd.CCheckObj.
-
In the Command name box, type descriptive text, such as Clean Database.
-
Click OK on the Add Custom Command dialog.
-
Select the command, and then click Run to display the Clean Database Dialog.
-
Specify the type of database in the Database type box.
-
In the grid, select the objects to clean and click Clean Now.
-
When the process finishes, click View Log and review the log file. It is possible that the cleaning operation was not successful.
-
To clean objects, you must have access to the objects. You must have Full Control on all permission groups in order to delete the objects.
-
You do not need to have the objects with errors loaded in the workspace to run this command. However, if the objects are not in the workspace, you will not see the graphical results of running the command when you refresh the workspace.