Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

There is already an object in the database

Expert

Overview

When Deploying the project, you get an error message that contains " There is already an object name 'table name' in the database ."

mceclip0.png

Applicable text of error message is:

...  There is already an object named 'table name' in the database...

Before taking these steps, it is strongly advised to ensure you have a backup of your databases involved.

Resolution Steps

  1. Find the database that contains the table in the error message. In the case above, we were Deploying the Staging database, so you'd want to open the Staging database node of the project.

  2. Right-click on the database, go to Advanced , and select SQL Database Cleanup Wizard .

    mceclip1.png

  3. The SQL Cleanup Wizard will then run.

    If there are no objects to clean up you will get the following message:

    No unexpected objects was found in the database.

  4. If the Cleanup Wizard does find objects, a window will open and you will have the option of dropping objects. We recommend Right-Clicking the Project Header and selecting the Drop option.

  5. Once you've dropped the objects, Deploy and Execute the database.

After following these steps, if you continue to get this error, you may need to recreate the database from scratch.  If this is something you need assistance with, please contact the insightsoftware Support Team .

Published:

There is already an object in the database

Expert

Overview

When Deploying the project, you get an error message that contains " There is already an object name 'table name' in the database ."

mceclip0.png

Applicable text of error message is:

...  There is already an object named 'table name' in the database...

Before taking these steps, it is strongly advised to ensure you have a backup of your databases involved.

Resolution Steps

  1. Find the database that contains the table in the error message. In the case above, we were Deploying the Staging database, so you'd want to open the Staging database node of the project.

  2. Right-click on the database, go to Advanced , and select SQL Database Cleanup Wizard .

    mceclip1.png

  3. The SQL Cleanup Wizard will then run.

    If there are no objects to clean up you will get the following message:

    No unexpected objects was found in the database.

  4. If the Cleanup Wizard does find objects, a window will open and you will have the option of dropping objects. We recommend Right-Clicking the Project Header and selecting the Drop option.

  5. Once you've dropped the objects, Deploy and Execute the database.

After following these steps, if you continue to get this error, you may need to recreate the database from scratch.  If this is something you need assistance with, please contact the insightsoftware Support Team .

For an optimal Community experience, Please view on Desktop