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