Article - CS161454

"Upgrade Database Schema" phase fails with "SQLServerException:Cannot find data type datetime2" during upgrade to Windchill PDMLink 10.2

Modified: 26-Sep-2016   


Applies To

  • Windchill PDMLink 8.0 to 11.0

Description

  • Upgrade Database Schema phase fails during upgrade of a SQL Server database:
    • Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #2: Cannot find data type datetime2.
      Nested exception is: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command ScriptCommand[wnc\Foundation\nonmodeled\tables\Make_nonmodeled_Foundation_tables.sql]
This is a printer-friendly version of Article 161454 and may be out of date. For the latest version click CS161454