Article - CS149596

Error "ORA-01400: cannot insert NULL into (<schema_owner>."EPMDOCUMENTMASTER"."DOCUMENTNUMBER") " while checking in CAD documents in Windchill PDMLink

Modified: 05-Oct-2022   


Applies To

  • Windchill PDMLink 9.0 to 11.0

Description

  • Error "ORA-01400: cannot insert NULL into (<schema_owner>."EPMDOCUMENTMASTER"."DOCUMENTNUMBER") " while checking in CAD documents.
  • Checkin action from Creo Parametric fails with error |
    • 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 EPMDocumentMaster(classnameA2A2,updateCountA2,CADName,authoringApplication,collapsible,classnamekeycontainerReferen,idA3containerReference,defaultUnit,docSubType,docType,genericType,globalID,name,documentNumber,classnamekeyorganizationRefe,idA3organizationReference,ownerApplication,series,markForDeleteA2,branchIdA2typeDefinitionRefe,idA2typeDefinitionReference,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.epm.EPMDocumentMaster',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
      Nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("<SCHEMA_NAME>L"."EPMDOCUMENTMASTER"."NAME")

       
This is a printer-friendly version of Article 149596 and may be out of date. For the latest version click CS149596