Article - CS80465

Database corruption because of missing foreign key relations in Windchill Quality Solutions

Modified: 28-Sep-2016   


Applies To

  • Windchill Quality Solutions Enterprise Edition 10.1 to 10.2

Description

  • Database corruption because of missing foreign key relations during conversion 
  • Database conversion from older versions of Windchill Quality Solutions or Relex fail to create relevant foreign keys, triggers, and indexes
  • Missing indexes during new database creation
  • Error message may be displayed : Violation of PRIMARY KEY constraint 'PK_PartTableID'. Cannot insert duplicate key in object 'dbo.PartTable'. The statement has been terminated.
  • Records with #DELETED keys are being displayed in tables
This is a printer-friendly version of Article 80465 and may be out of date. For the latest version click CS80465