Article - CS334210
After restore of MSSQL Server database Windchill does not start with "Unable to instantiate JdbcIUHPersistenceDelegate."
Modified: 19-Nov-2020
Applies To
- Windchill PDMLink 11.0 to 12.0
- Microsoft SQL Server
Description
- After restore of MSSQL Server database Windchill does not start with "Unable to instantiate JdbcIUHPersistenceDelegate."
- Error in MethodServer log
ERROR [main] com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate - Unable to instantiate JdbcIUHPersistenceDelegate.
com.ptc.windchill.upgrade.instupghistory.IUHException: com.ptc.windchill.upgrade.instupghistory.IUHException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: com.ptc.windchill.upgrade.instupghistory.IUHException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:744)
at wt.tools.sql.SQLCommand.doExecute(SQLCommand.java:187)
at wt.tools.sql.AbstractCommand.doExecute(AbstractCommand.java:74)
at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:519)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSql(AbstractUpgradeDBHelper.java:444)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSqlAsSchemaOwner(AbstractUpgradeDBHelper.java:419)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.createTable(JdbcIUHPersistenceDelegate.java:1190)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.createOrAlterTableIfNecessary(JdbcIUHPersistenceDelegate.java:1160)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.ensureTablesExist(JdbcIUHPersistenceDelegate.java:1207)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.<init>(JdbcIUHPersistenceDelegate.java:349)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.getInstance(JdbcIUHPersistenceDelegate.java:242)
at com.ptc.windchill.upgrade.instupghistory.AbstractPersistenceDelegate.getPersistenceDelegate(AbstractPersistenceDelegate.java:77)
at com.ptc.windchill.upgrade.instupghistory.InstallAndUpgradeHistory.<init>(InstallAndUpgradeHistory.java:70)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.initTransaction(StandardDatabaseVersioningService.java:135)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.performStartupProcess(StandardDatabaseVersioningService.java:110)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
at wt.method.MethodServerMain.run(MethodServerMain.java:603)
at wt.method.MethodServerMain.main(MethodServerMain.java:373)
FATAL [main] wt.method.server - MethodServerMain abort
java.lang.NullPointerException
at com.ptc.windchill.upgrade.instupghistory.InstallAndUpgradeHistory.<init>(InstallAndUpgradeHistory.java:71)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.initTransaction(StandardDatabaseVersioningService.java:135)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.performStartupProcess(StandardDatabaseVersioningService.java:110)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
at wt.method.MethodServerMain.run(MethodServerMain.java:603)
at wt.method.MethodServerMain.main(MethodServerMain.java:373)
com.ptc.windchill.upgrade.instupghistory.IUHException: com.ptc.windchill.upgrade.instupghistory.IUHException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: com.ptc.windchill.upgrade.instupghistory.IUHException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
Nested exception is: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[CREATE TABLE WtUpgInst_Installation (ID BIGINT PRIMARY KEY,COMPLETE TINYINT NOT NULL,TIMESTAMP DATETIME2 NOT NULL,DIRECTORY NVARCHAR(4000),HOSTNAME NVARCHAR(4000),ISUPGRADEMANAGERENTRY TINYINT)].
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'WtUpgInst_Installation' in the database.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:744)
at wt.tools.sql.SQLCommand.doExecute(SQLCommand.java:187)
at wt.tools.sql.AbstractCommand.doExecute(AbstractCommand.java:74)
at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:519)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSql(AbstractUpgradeDBHelper.java:444)
at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSqlAsSchemaOwner(AbstractUpgradeDBHelper.java:419)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.createTable(JdbcIUHPersistenceDelegate.java:1190)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.createOrAlterTableIfNecessary(JdbcIUHPersistenceDelegate.java:1160)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.ensureTablesExist(JdbcIUHPersistenceDelegate.java:1207)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.<init>(JdbcIUHPersistenceDelegate.java:349)
at com.ptc.windchill.upgrade.instupghistory.JdbcIUHPersistenceDelegate.getInstance(JdbcIUHPersistenceDelegate.java:242)
at com.ptc.windchill.upgrade.instupghistory.AbstractPersistenceDelegate.getPersistenceDelegate(AbstractPersistenceDelegate.java:77)
at com.ptc.windchill.upgrade.instupghistory.InstallAndUpgradeHistory.<init>(InstallAndUpgradeHistory.java:70)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.initTransaction(StandardDatabaseVersioningService.java:135)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.performStartupProcess(StandardDatabaseVersioningService.java:110)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
at wt.method.MethodServerMain.run(MethodServerMain.java:603)
at wt.method.MethodServerMain.main(MethodServerMain.java:373)
FATAL [main] wt.method.server - MethodServerMain abort
java.lang.NullPointerException
at com.ptc.windchill.upgrade.instupghistory.InstallAndUpgradeHistory.<init>(InstallAndUpgradeHistory.java:71)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.initTransaction(StandardDatabaseVersioningService.java:135)
at com.ptc.windchill.upgrade.instupghistory.service.StandardDatabaseVersioningService.performStartupProcess(StandardDatabaseVersioningService.java:110)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
at wt.method.MethodServerMain.run(MethodServerMain.java:603)
at wt.method.MethodServerMain.main(MethodServerMain.java:373)
This is a printer-friendly version of Article 334210 and may be out of date. For the latest version click CS334210