1. Home
  2. Support
Article - CS115367

SQL Server Collation error after upgrading from a previous version of Windchill to Windchill 10.1 and from SQLServer 2005/2008 to SQLServer 2012

Modified: 02-Nov-2016   


Applies To

  • Windchill PDMLink 10.1 to 10.2

Description

  • Windchill on SQL Server 2005 / 2008 requires collation SQL_Latin1_General_CP1_CS_AS
  • Windchill Installation and Configuration Guide 10.1 (page 41) request to have  SQL Server 2012 with Latin1_General_100_CS_AS_SC collation
  • Windchill is upgraded from 8.0 or 9.x to 10.1 and SQL Server is upgrade from 2005/2008 to 2012
  • When modifying the collation in SQLServer 2012 the following error is returned:
The column 'xxxx' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
  • Some operation in Windchill may fail with:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Latin1_General_100_CS_AS_SC" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.
 
  • Upgrade to Windchill 10.2 fails at Verify Supported Upgrade Path > Verifying Valid Collation with following error:
wt.util.WTException: Server instance collation and Windchill database collation must match.
    at com.ptc.windchill.upgrade.phases.VerifySupportedUpgradePath.verifySupportedCollation(VerifySupportedUpgradePath.java:405)
    at com.ptc.windchill.upgrade.phases.VerifySupportedUpgradePath.execute(VerifySupportedUpgradePath.java:290)
    at com.ptc.windchill.upgrade.statemachine.state.DefaultRunningUpgradeState.execute(DefaultRunningUpgradeState.java:34)
    at com.ptc.windchill.upgrade.statemachine.state.PhaseEventUpgradeState.execute(PhaseEventUpgradeState.java:55)
    at com.ptc.windchill.upgrade.statemachine.state.ReportWriterUpgradeState.execute(ReportWriterUpgradeState.java:74)
    at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.run(UpgradeFrameworkStateMachine.java:452)
    at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.main_(UpgradeFrameworkStateMachine.java:852)
    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 com.ptc.windchill.upgrade.statemachine.DynamicLauncher.runUpgradeFrameworkStateMachine(DynamicLauncher.java:112)
    at com.ptc.windchill.upgrade.statemachine.DynamicLauncher.main(DynamicLauncher.java:30)
This is a printer-friendly version of Article 115367 and may be out of date. For the latest version click CS115367