Skip to main content
R
RW_1068286012-Amethyst
12-Amethyst
August 22, 2023
Solved

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

  • August 22, 2023
  • 1 reply
  • 2050 views

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

 

 

 

 

 

 

Best answer by HelesicPetr

@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

1 reply

T
23-Emerald IV
TomU23-Emerald IV
23-Emerald IV
August 22, 2023

Do either of these help?

 

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

 

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

 

R
RW_1068286012-AmethystAuthor
12-Amethyst
August 23, 2023

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

 

 

 

 

T
23-Emerald IV
TomU23-Emerald IV
23-Emerald IV
August 23, 2023

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.

 

    Terms & ConditionsAccessibility statement