1. 主页
  2. 支持
技术文章 - CS115367

从Windchill早期版本升级到Windchill 10.1, 并从SQLServer 2005/2008 升级到 SQLServer 2012后，出现SQL Server Collation错误。

已修改: 02-Nov-2016   


适用于

  • Windchill PDMLink 10.1 to 10.2

说明

  • Windchill要求 SQL Server2005 / 2008 使用SQL_Latin1_General_CP1_CS_AS作为排序规则(Collation)。
  • Windchill Installation and Configuration Guide 10.1 (41页) 要求使用Latin1_General_100_CS_AS_SC排序规则的  SQL Server 2012
  • Windchill从 8.0 或 9.x 升级到 10.1， SQL Server 从 2005/2008 升级到 2012
  • 修改SQLServer 2012排序规则时，发生下列错误:
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.
  • Windchill中某些操作失败:
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.
 
  • 升级到Windchill 10.2，执行Verify Supported Upgrade Path > Verifying Valid Collation 失败:
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)
这是文章 115367 的 PDF 版本，可能已过期。最新版本 CS115367