We are experiencing a recurring issue in SOLIDWORKS PDM Standard 2026 SP2.1.
The error occurs during Check In when the option "Keep Checked Out" is enabled.
Error message:
"Violation of PRIMARY KEY constraint 'PK_HistoryLock'. Cannot insert duplicate key in object 'dbo.HistoryLock'."
Observations:
- The problem occurs on multiple projects and multiple files.
- The issue does not occur during a normal Check In.
- The issue only occurs when using "Check In" together with "Keep Checked Out".
- The problem can be reproduced repeatedly.
- Clearing the local cache does not resolve the issue.
- The issue appears on small assemblies as well as larger projects.
- Other users do not appear to experience the same issue.
Database investigation:
The primary key of the HistoryLock table consists of:
- UserId
- DocId
- Time
The duplicate key reported by SQL Server is typically:
(UserId, DocId, Time)
We investigated the affected Document IDs and found that the error is related to weldment cut-list items.
Example:
- Document ID 2562 = 1000101093.SLDPRT
- Document ID 2564 = "Rör 40x2<1>" (weldment cut-list item)
When checking out the weldment part, PDM automatically includes the cut-list item:
1000101093.SLDPRT
Rör 40x2<1>
HistoryLock entries show that the weldment cut-list item receives multiple lock-history records within only a few milliseconds. For example:
2564 2026-06-24 13:41:03.583
2564 2026-06-24 13:41:03.587
This suggests that PDM may be attempting to create duplicate HistoryLock records during the "Keep Checked Out" operation.
Could you please verify whether this is a known issue in PDM Standard 2026 SP2.1, particularly related to weldment cut-list items and the "Keep Checked Out" functionality?
We can provide additional SQL logs and reproduction steps if required.
