技术文章 - CS194412
Windchill PDMLink 中 ServerManager 启动失败,错误信息为:“com.microsoft.sqlserver.jdbc.SQLServerException: 对象名称‘xxxx’无效”
已修改: 31-Aug-2025
适用于
- Windchill PDMLink 10.1 to 13.1
- Microsoft SQL Server 2008, 2012
说明
- ServerManager 启动失败并出现错误
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'xxxx'
- 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)
- 无法启动Windchill MethodServer ,服务器管理器失败,可能出现以下错误
[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)
这是文章 194412 的 PDF 版本,可能已过期。最新版本 CS194412