Article - CS292483
Unable to create new "Manufacturing Resource", throws" ORA-00904: "PTC_STR_9TYPEINFOWTPART": invalid identifier" message in Windchill MPMLink 11.0
Modified: 06-May-2023
Applies To
- Windchill MPMLink 11.0
Description
- Unable to create new Manufacturing Resource
- Error in MethodServer log:
com.ptc.core.components.forms.DefaultFormProcessorController rajendra.bharat - A persistence error occurred.
(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 MPMProcessMaterial(classnameA2A2,updateCountA2,administrativeLockIsNull,typeadministrativeLock,blob$entrySetadHocAcl,blob$expressionData,checkoutInfoIsNull,statecheckoutInfo,classnamekeycontainerReferen,idA3containerReference,contractNumber,description,classnamekeydomainRef,idA3domainRef,entrySetadHocAcl,eventSet,expressionData,classnamekeyA2folderingInfo,idA3A2folderingInfo,classnamekeyB2folderingInfo,idA3B2folderingInfo,hasHangingChange,hasPendingChange,hasResultingChange,hasVariance,indexersindexerSet,inheritedDomain,iopStateinteropInfo,stateinteropInfo,branchIditerationInfo,classnamekeyD2iterationInfo,idA3D2iterationInfo,classnamekeyE2iterationInfo,idA3E2iterationInfo,iterationIdA2iterationInfo,latestiterationInfo,classnamekeyB2iterationInfo,idA3B2iterationInfo,noteiterationInfo,classnamekeyC2iterationInfo,idA3C2iterationInfo,stateiterationInfo,jobAuthorizationNumber,datelock,classnamekeyA2lock,idA3A2lock,notelock,classnamekeymasterReference,idA3masterReference,maximumAllowed,minimumRequired,oneOffVersionIdA2oneOffVersi,classnamekeyA2ownership,idA3A2ownership,partType,phase,securityLabels,source,atGatestate,classnamekeyA2state,idA3A2state,statestate,teamIdIsNull,classnamekeyteamId,idA3teamId,teamTemplateIdIsNull,classnamekeyteamTemplateId,idA3teamTemplateId,markForDeleteA2,branchIdA2typeDefinitionRefe,idA2typeDefinitionReference,blob$ptc_rht_1typeInfoWTPart,ptc_bln_1typeInfoWTPart,ptc_bln_10typeInfoWTPart,ptc_bln_2typeInfoWTPart,ptc_bln_3typeInfoWTPart,ptc_bln_4typeInfoWTPart,ptc_bln_5typeInfoWTPart,ptc_bln_6typeInfoWTPart,ptc_bln_7typeInfoWTPart,ptc_bln_8typeInfoWTPart,ptc_bln_9typeInfoWTPart,ptc_rht_1typeInfoWTPart,ptc_str_1typeInfoWTPart,ptc_str_10typeInfoWTPart,ptc_str_11typeInfoWTPart,ptc_str_12typeInfoWTPart,ptc_str_13typeInfoWTPart,ptc_str_14typeInfoWTPart,ptc_str_15typeInfoWTPart,ptc_str_16typeInfoWTPart,ptc_str_17typeInfoWTPart,ptc_str_18typeInfoWTPart,ptc_str_19typeInfoWTPart,ptc_str_2typeInfoWTPart,ptc_str_20typeInfoWTPart,ptc_str_21typeInfoWTPart,ptc_str_22typeInfoWTPart,ptc_str_23typeInfoWTPart,ptc_str_24typeInfoWTPart,ptc_str_25typeInfoWTPart,ptc_str_26typeInfoWTPart,ptc_str_27typeInfoWTPart,ptc_str_28typeInfoWTPart,ptc_str_29typeInfoWTPart,ptc_str_3typeInfoWTPart,ptc_str_30typeInfoWTPart,ptc_str_31typeInfoWTPart,ptc_str_32typeInfoWTPart,ptc_str_33typeInfoWTPart,ptc_str_34typeInfoWTPart,ptc_str_35typeInfoWTPart,ptc_str_4typeInfoWTPart,ptc_str_5typeInfoWTPart,ptc_str_6typeInfoWTPart,ptc_str_7typeInfoWTPart,ptc_str_8typeInfoWTPart,ptc_str_9typeInfoWTPart,usage,variation1,variation2,versionIdA2versionInfo,versionLevelA2versionInfo,versionSortIdA2versionInfo,viewIsNull,classnamekeyview,idA3view,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('com.ptc.windchill.mpml.resource.MPMProcessMaterial',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "PTC_STR_9TYPEINFOWTPART": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3205)
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:306)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2404)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:572)
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1434)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:534)
(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 MPMProcessMaterial(classnameA2A2,updateCountA2,administrativeLockIsNull,typeadministrativeLock,blob$entrySetadHocAcl,blob$expressionData,checkoutInfoIsNull,statecheckoutInfo,classnamekeycontainerReferen,idA3containerReference,contractNumber,description,classnamekeydomainRef,idA3domainRef,entrySetadHocAcl,eventSet,expressionData,classnamekeyA2folderingInfo,idA3A2folderingInfo,classnamekeyB2folderingInfo,idA3B2folderingInfo,hasHangingChange,hasPendingChange,hasResultingChange,hasVariance,indexersindexerSet,inheritedDomain,iopStateinteropInfo,stateinteropInfo,branchIditerationInfo,classnamekeyD2iterationInfo,idA3D2iterationInfo,classnamekeyE2iterationInfo,idA3E2iterationInfo,iterationIdA2iterationInfo,latestiterationInfo,classnamekeyB2iterationInfo,idA3B2iterationInfo,noteiterationInfo,classnamekeyC2iterationInfo,idA3C2iterationInfo,stateiterationInfo,jobAuthorizationNumber,datelock,classnamekeyA2lock,idA3A2lock,notelock,classnamekeymasterReference,idA3masterReference,maximumAllowed,minimumRequired,oneOffVersionIdA2oneOffVersi,classnamekeyA2ownership,idA3A2ownership,partType,phase,securityLabels,source,atGatestate,classnamekeyA2state,idA3A2state,statestate,teamIdIsNull,classnamekeyteamId,idA3teamId,teamTemplateIdIsNull,classnamekeyteamTemplateId,idA3teamTemplateId,markForDeleteA2,branchIdA2typeDefinitionRefe,idA2typeDefinitionReference,blob$ptc_rht_1typeInfoWTPart,ptc_bln_1typeInfoWTPart,ptc_bln_10typeInfoWTPart,ptc_bln_2typeInfoWTPart,ptc_bln_3typeInfoWTPart,ptc_bln_4typeInfoWTPart,ptc_bln_5typeInfoWTPart,ptc_bln_6typeInfoWTPart,ptc_bln_7typeInfoWTPart,ptc_bln_8typeInfoWTPart,ptc_bln_9typeInfoWTPart,ptc_rht_1typeInfoWTPart,ptc_str_1typeInfoWTPart,ptc_str_10typeInfoWTPart,ptc_str_11typeInfoWTPart,ptc_str_12typeInfoWTPart,ptc_str_13typeInfoWTPart,ptc_str_14typeInfoWTPart,ptc_str_15typeInfoWTPart,ptc_str_16typeInfoWTPart,ptc_str_17typeInfoWTPart,ptc_str_18typeInfoWTPart,ptc_str_19typeInfoWTPart,ptc_str_2typeInfoWTPart,ptc_str_20typeInfoWTPart,ptc_str_21typeInfoWTPart,ptc_str_22typeInfoWTPart,ptc_str_23typeInfoWTPart,ptc_str_24typeInfoWTPart,ptc_str_25typeInfoWTPart,ptc_str_26typeInfoWTPart,ptc_str_27typeInfoWTPart,ptc_str_28typeInfoWTPart,ptc_str_29typeInfoWTPart,ptc_str_3typeInfoWTPart,ptc_str_30typeInfoWTPart,ptc_str_31typeInfoWTPart,ptc_str_32typeInfoWTPart,ptc_str_33typeInfoWTPart,ptc_str_34typeInfoWTPart,ptc_str_35typeInfoWTPart,ptc_str_4typeInfoWTPart,ptc_str_5typeInfoWTPart,ptc_str_6typeInfoWTPart,ptc_str_7typeInfoWTPart,ptc_str_8typeInfoWTPart,ptc_str_9typeInfoWTPart,usage,variation1,variation2,versionIdA2versionInfo,versionLevelA2versionInfo,versionSortIdA2versionInfo,viewIsNull,classnamekeyview,idA3view,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('com.ptc.windchill.mpml.resource.MPMProcessMaterial',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "PTC_STR_9TYPEINFOWTPART": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3205)
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:306)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2404)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:572)
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1434)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:534)
This is a printer-friendly version of Article 292483 and may be out of date. For the latest version click CS292483