Article - CS284880

Recieving "Invalid column name" error during upgrade from Windchill 11.0 to 11.1 using SQL Server

Modified: 25-Jul-2018   


Applies To

  • Windchill PDMLink 11.0 F000 to 11.1 M010
  • Windchill PDMLink 11.0
  • Microsoft SQL Server

Description

  • There is an invalid column name in my database that is causing the upgrade manager to fail
  • From Upgrade Manager log:
    • INFO  [UpgradeEventFirer] com.ptc.windchill.upgrade.logging.UpgradeFrameworkLogger - Task EXECUTING: <upgradeTask> : FAILEDcom.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name '<columnName>'.
    • ERROR [UpgradeEventFirer] com.ptc.windchill.upgrade.logging.UpgradeFrameworkLogger - Message: Error in method server code:
      java.lang.Exception: Exception of type 'java.lang.reflect.InvocationTargetException' was generated on the server with message 'null'
  • From the Method Server Log:
    • ERROR [RMI TCP Connection(2)-<ipAddress>] org.apache.tomcat.util.modeler.BaseModelMBean  - Exception invoking method stop
      org.apache.catalina.LifecycleException: An invalid Lifecycle transition was attempted ([before_stop]) for component [Connector[AJP/1.3-8011]] in state [INITIALIZED]
          at org.apache.catalina.util.LifecycleBase.invalidTransition(LifecycleBase.java:402)
This is a printer-friendly version of Article 284880 and may be out of date. For the latest version click CS284880