Article - CS154204

java.sql.BatchUpdateException: ORA-00001: unique constraint violated when loading with Windchill Bulk Migrator

Modified: 21-Nov-2023   


Applies To

  • Windchill Bulk Migrator 2.2 to 12.0

Description

  • Objects were previously loaded using Windchill Bulk Migrator
  • Objects were then deleted via Windchill PDMLink GUI
  • Subsequent Windchill Bulk Migrator load attempts return:
    • java.sql.BatchUpdateException: ORA-00001: unique constraint violated
  • Expectation is that there would be no conflict since the objects were deleted
  • When doing Non-Windchill to Windchill migration, same set of WBMSourceIdentifier, Sequence Number was populated in Staging DB for more than one distinct document objects
This is a printer-friendly version of Article 154204 and may be out of date. For the latest version click CS154204