技术文章 - CS194412

Windchill PDMLink 中 ServerManager 启动失败,错误信息为:“com.microsoft.sqlserver.jdbc.SQLServerException: 对象名称‘xxxx’无效”

已修改: 31-Aug-2025   


注意:本文已使用机器翻译软件翻译,以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意, PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情,请单击 此处
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • 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