Article - CS194412

ServerManager failed to start up with error: "com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'xxxx'" in Windchill PDMLink

Modified: 31-Aug-2025   


Applies To

  • Windchill PDMLink 10.1 to 13.1
  • Microsoft SQL Server 2008, 2012

Description

  • ServerManager failed to start up with error
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'xxxx'
  • Errors in ServerManager.log:
wt.manager.CacheMasterNegotiator - Exception initializing DB; retrying...
com.microsoft.sqlserver.jdbc.SQLServerException:  Invalid object name  'xxxx'。
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at wt.manager.CacheMasterNegotiator$PreparedStatementInvocationHandler.invoke(CacheMasterNegotiator.java:2432)
    at wt.manager.$Proxy2.executeQuery(Unknown Source)
    at wt.manager.CacheMasterNegotiator.ensureRow(CacheMasterNegotiator.java:1360)
    at wt.manager.CacheMasterNegotiator.ensureStubRow(CacheMasterNegotiator.java:1349)
    at wt.manager.CacheMasterNegotiator.initDB(CacheMasterNegotiator.java:1334)
    at wt.manager.CacheMasterNegotiator.start(CacheMasterNegotiator.java:2215)
    at wt.manager.ServerManagerMain.startServerManager_internal(ServerManagerMain.java:380)
    at wt.manager.ServerManagerMain.run(ServerManagerMain.java:288)
    at wt.manager.ServerManagerMain.main(ServerManagerMain.java:222)
2014-12-23 10:47:08,699 FATAL [main] wt.server.manager - ServerManagerMain abort
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'xxxx'
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at wt.manager.CacheMasterNegotiator$PreparedStatementInvocationHandler.invoke(CacheMasterNegotiator.java:2432)
    at wt.manager.$Proxy2.executeQuery(Unknown Source)
    at wt.manager.CacheMasterNegotiator.ensureRow(CacheMasterNegotiator.java:1360)
    at wt.manager.CacheMasterNegotiator.ensureStubRow(CacheMasterNegotiator.java:1349)
    at wt.manager.CacheMasterNegotiator.initDB(CacheMasterNegotiator.java:1334)
    at wt.manager.CacheMasterNegotiator.start(CacheMasterNegotiator.java:2215)
    at wt.manager.ServerManagerMain.startServerManager_internal(ServerManagerMain.java:380)
    at wt.manager.ServerManagerMain.run(ServerManagerMain.java:288)
    at wt.manager.ServerManagerMain.main(ServerManagerMain.java:222)
  • Unable to start Windchill MethodServer, Server manager failed with following possible errors
[ptc][SQLServer JDBC Driver][SQLServer]Invalid object name 'Repository' when starting Windchill MethodServer
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Repository'.
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
Thu 8/20/15 14:28:10: main:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
Thu 8/20/15 14:28:10: main:     at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:525)
This is a printer-friendly version of Article 194412 and may be out of date. For the latest version click CS194412