Article - CS208897
Windchill is showing gaps in Identity numbers on MS SQL Server in Windchill PDMLink
Modified: 12-Feb-2026
Applies To
- Windchill PDMLink 10.2 to 13.0
- Microsoft SQL Server 2012, 2017, 2019
Description
- Auto numbering is skipping numbers with MS SQL Server 2012
- Identity table values are showing gaps of 1000 or 10000
- Windchill PDMLink is showing gaps in Identity numbers on MS SQL Server 2016
- The autonumbering skipped almost 10K numbers for wtparts creation on SQL server 2019
- Numbers skipped in WTPart sequence after MS SQL Database server restart
- Generated numeric sequence values show unexpected jumps exceeding 40K on SQL server 2019
This is a printer-friendly version of Article 208897 and may be out of date. For the latest version click CS208897