1. Home
  2. Support
Article - CS171070

Oracle to SQL Server Database Migration: Pre-Migration Diagnostic Utility for Windchill 10.2

Modified: 18-Sep-2017   


Applies To

  • Windchill PDMLink 10.2
Microsoft SQL Server

Description

  • Oracle to SQL Server Pre Migration Diagnostic Utility for Windchill 10.2
  • Oracle to SQL Server database migration fails with error The total size of an index or primary key cannot exceed 900 bytes
  • Oracle to SQL Server database migration fails with Conversion failed because the data value overflowed the type used by the provider
  • Oracle to SQL Server database migration fails with Error during post migration: Found disabled trigger, indexes or constraints in the database
  • Following stack trace is received in Oracle to SQL Server database migration log file (name of index may vary)
INFO  Oracle_SQLServer_Dynamic_Mig.PostMigration.checkDisabledObject():899 - Check disabled objects in the database ...
ERROR Oracle_SQLServer_Dynamic_Mig.PostMigration.checkDisabledObject():949 - Disabled index found: [AccessPolicyRule$UNIQUE50] ON o2s_install.[AccessPolicyRule]
ERROR Oracle_SQLServer_Dynamic_Mig.PostMigration.checkDisabledObject():949 - Disabled index found: [DiscussionTopic$UNIQUE50] ON o2s_install.[DiscussionTopic]
ERROR Oracle_SQLServer_Dynamic_Mig.PostMigration.process():67 - Post migration failed.
  • Following screen is received:
User-added image
This is a printer-friendly version of Article 171070 and may be out of date. For the latest version click CS171070