1. Home
  2. Support
Article - CS286702

Running the Windchill Performance Advisor fails to generate Windchill Database Statistics on Microsoft SQL Server

Modified: 17-May-2019   


Applies To

  • Windchill PDMLink 11.0 to 11.1

Description

  • Running the Windchill Performance Advisor fails to generate Windchill Database Statistics on Microsoft SQL Server
  • Error in MethodServer log
ERROR [ajp-nio-127.0.0.1-8010-exec-5] com.ptc.wa.database.WindchillDBStatisticsPlugin wcadmin - Failure in collect:
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '$SSMA_seq_ACTIONITEMNUMBER_SEQ'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
This is a printer-friendly version of Article 286702 and may be out of date. For the latest version click CS286702