Article - CS164354
Check In with Auto Associate parts to CAD documents fails in Windchill PDMLink
Modified: 20-May-2025
Applies To
- Windchill PDMLink 10.0 to 13.0
- Creo Parametric 2.0 to 11.0
Description
- Failed to create part
- Check In with 'Auto Associate Parts to CAD Documents' fails with NullPointerException
- Performing the workspace 'Auto Associate' operation displays blank UI
- 'Create and Associate Part' in the New CAD Document UI fails with error: A persistent error occurred
- Unable to perform 'Edit Association' the page keeps spinning indefinitely
- EPMDocument cannot be checked in if Auto Associate Parts to CAD Documents is selected
- Method server log reports following different error messages:
wt.pds.exception wcadmin - Suppressing internal message (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO WTPartMaster(classnameA2A2,updateCountA2,collapsible,classnamekeycontainerReferen,idA3containerReference,defaultTraceCode,defaultUnit,effCalculationStatus,effPropagationStop,endItem,genericType,hidePartInStructure,name,WTPartNumber,classnamekeyorganizationRefe,idA3organizationReference,phantom,series,serviceable,servicekit,markForDeleteA2,authoringLanguagetranslation,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.part.WTPartMaster',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'defaultUnit', table 'XXXX.XXXX.WTPartMaster'; column does not allow nulls. INSERT fails.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
Nested exception is: wt.vc.VersionControlException: A persistence error occurred.
Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO WTPartMaster(classnameA2A2,updateCountA2,collapsible,classnamekeycontainerReferen,idA3containerReference,defaultTraceCode,defaultUnit,effCalculationStatus,effPropagationStop,endItem,genericType,hidePartInStructure,name,WTPartNumber,classnamekeyorganizationRefe,idA3organizationReference,phantom,series,serviceable,servicekit,markForDeleteA2,authoringLanguagetranslation,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.part.WTPartMaster',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WCUSER"."WTPARTMASTER"."DEFAULTUNIT")
Nested exception is: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'defaultUnit', table 'pdmlink.pdmlink.WTPartMaster'; column does not allow nulls. INSERT fails.
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ORACLESQL"."WTPARTMASTER"."DEFAULTUNIT")
wt.util.WTException: colCompID is Null Cannot insert the value NULL into column 'defaultUnit'
This is a printer-friendly version of Article 164354 and may be out of date. For the latest version click CS164354