There is already an object named 'WtUpgInst_Installation' in the database

[RW_10682860]

Running the upgrade manager on 12.1.2 Windchill PDMLink

Import a source database from Windchill PDMlink 11.1 M020

Facing an error

Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database

Stuck here - Any insights please

TY

[TomU]

Do either of these help?

https://www.ptc.com/en/support/article/CS377550

https://www.ptc.com/en/support/article/CS390124

[RW_10682860]

thank you for the reply

just for clarity sake

our old system (pdmlink 11.1.m020 has a sql databse named "abc" with same user name as "abc"

On the new machine which now has 12.1.2 PDMlink we had created a new empty database named "xyz"  and the respective tables did get populated after we installed 12.1.2 using PSI. 

So should the new databse be also named as "abc" alongwith a user "abc" and then we should run a restore database

And as a last step run upgrade manager?

Not so clear on the sql part, so I have asked in the form of baby steps !

Thank you

[TomU]

The new database that was created for the installation of 12.1 will be completely discarded (overwritten) by the existing 11.1 database during the upgrade process.  The upgrade manager will prompt for the database name, username, and password.  These will most likely be the same values the 11.1 system had, but on the new database server.

Upgrade Process - High Level Steps

1.) Install LDAP (OpenDJ, WindchillDS, etc.)

2.) Install and configure the database.

3.) Install the Windchill application.

4.) Update the new system configuration to match the old system (properties, roles, states, customizations, etc.)

-------------------

5.) Stop the new Windchill system.

6.) Copy the file vault(s) from the old system.

7.) Copy the LDAP from the old system.

8.) Copy the database from the old system.

9.) Run the upgrade manager process.

10.) Manually update anything that the upgrade manager didn't change (vault paths, remote file servers, etc.)

11.) Test everything.

Can repeat steps 5 - 11 as many times as necessary.

[HelesicPetr · Accepted solution]

@TomU 

I would just add a clarification to the point 8

Copy the database from the old system.- this is usually done by backup source database and restore it to new database

PetrH