Article - CS413233

Getting Error: "Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."PTC_STR_3TYPEINFOWTDOCUMENT": invalid identifier" post CPS Update or Maintenance Activity in Windchill PDMLink

Modified: 10-Apr-2026   


Applies To

  • Windchill PDMLink 12.0 to 13.0

Description

  • Getting Error: "Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."PTC_STR_3TYPEINFOWTDOCUMENT": invalid identifier" post CPS Update or Maintenance Activity 
  • Not able to see Parts in Folders
  • Global Search and Checkin actions are not working
  • After Database refresh / CPS update unable to get data in Folder Contents             User-added image
  • Error in Method Server Log:
    wt.system.err  - Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'wt.doc.WTDocument',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.department,A0.description,A0.docType,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.classnamekeyformat,A0.idA3format,A0.hasHangingChange,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,A0.iopStateinteropInfo,A0.stateinteropInfo,A0.branchIditerationInfo,A0.classnamekeyD2iterationInfo,A0.idA3D2iterationInfo,A0.classnamekeyE2iterationInfo,A0.idA3E2iterationInfo,A0.iterationIdA2iterationInfo,A0.latestiterationInfo,A0.classnamekeyB2iterationInfo,A0.idA3B2iterationInfo,A0.noteiterationInfo,A0.classnamekeyC2iterationInfo,A0.idA3C2iterationInfo,A0.stateiterationInfo,TO_CHAR(A0.datelock,'dd mm yyyy hh24:mi:ss'),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.oneOffVersionIdA2oneOffVersi,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.securityLabels,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,A0.enabledtemplate,A0.templatedtemplate,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.title,A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.ptc_bln_1typeInfoWTDocument,A0.ptc_bln_2typeInfoWTDocument,A0.ptc_lng_1typeInfoWTDocument,A0.ptc_lng_2typeInfoWTDocument,A0.ptc_lng_3typeInfoWTDocument,A0.ptc_lng_4typeInfoWTDocument,A0.ptc_str_1typeInfoWTDocument,A0.ptc_str_2typeInfoWTDocument,A0.ptc_str_3typeInfoWTDocument,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.docType,A0B.name,A0B.WTDocumentNumber,A0B.classnamekeyorganizationRefe,A0B.idA3organizationReference,A0B.series,TO_CHAR(A0B.createStampA2,'dd mm yyyy hh24:mi:ss'),A0B.markForDeleteA2,TO_CHAR(A0B.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,TO_CHAR(A0B.updateStampA2,'dd mm yyyy hh24:mi:ss') FROM WTDocument A0,WTDocumentMaster A0B WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((UPPER(A0B.name) = ?) AND (A0.latestiterationInfo = ?)) AND (A0.markForDeleteA2 = 0); Bind Parameters=[COM.WINCOMPLM.WEX-CONFIG - CONFIG, 1]". Database system message follows:
    wt.system.err  - Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."PTC_STR_3TYPEINFOWTDOCUMENT": invalid identifier
    wt.system.err  - 
    wt.system.err  - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
                 
  • Following Errors are seen in the Method Server logs post Maintenance Activity:
    wt.pom.PersistenceException: A persistence error occurred. System message follows:
    Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'wt.part.WTPart',A0.adhocVersionInfo,A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.blob$expressionData,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.contractNumber,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.expressionData,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,A0.idA3B2folderingInfo,A0.hasHangingChange,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,A0.iopStateinteropInfo,A0.stateinteropInfo,A0.branchIditerationInfo,A0.classnamekeyD2iterationInfo,A0.idA3D2iterationInfo,A0.classnamekeyE2iterationInfo,A0.idA3E2iterationInfo,A0.iterationIdA2iterationInfo,A0.latestiterationInfo,A0.classnamekeyB2iterationInfo,A0.idA3B2iterationInfo,A0.noteiterationInfo,A0.classnamekeyC2iterationInfo,A0.idA3C2iterationInfo,A0.stateiterationInfo,A0.jobAuthorizationNumber,TO_CHAR(A0.datelock,'dd mm yyyy hh24:mi:ss'),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.maximumAllowed,A0.minimumRequired,A0.oneOffVersionIdA2oneOffVersi,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.partType,A0.phase,A0.securityLabels,A0.source,A0.atGatestate,A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,A0.blob$ptc_rht_1typeInfoWTPart,A0.ptc_bln_1typeInfoWTPart,A0.ptc_bln_10typeInfoWTPart,A0.ptc_bln_2typeInfoWTPart,A0.ptc_bln_3typeInfoWTPart,A0.ptc_bln_4typeInfoWTPart,A0.ptc_bln_5typeInfoWTPart,A0.ptc_bln_6typeInfoWTPart,A0.ptc_bln_7typeInfoWTPart,A0.ptc_bln_8typeInfoWTPart,A0.ptc_bln_9typeInfoWTPart,A0.ptc_rht_1typeInfoWTPart,A0.ptc_str_1typeInfoWTPart,A0.ptc_str_10typeInfoWTPart,A0.ptc_str_11typeInfoWTPart,A0.ptc_str_12typeInfoWTPart,A0.ptc_str_13typeInfoWTPart,A0.ptc_str_14typeInfoWTPart,A0.ptc_str_15typeInfoWTPart,A0.ptc_str_16typeInfoWTPart,A0.ptc_str_17typeInfoWTPart,A0.ptc_str_18typeInfoWTPart,A0.ptc_str_19typeInfoWTPart,A0.ptc_str_2typeInfoWTPart,A0.ptc_str_20typeInfoWTPart,A0.ptc_str_21typeInfoWTPart,A0.ptc_str_22typeInfoWTPart,A0.ptc_str_23typeInfoWTPart,A0.ptc_str_24typeInfoWTPart,A0.ptc_str_25typeInfoWTPart,A0.ptc_str_26typeInfoWTPart,A0.ptc_str_27typeInfoWTPart,A0.ptc_str_28typeInfoWTPart,A0.ptc_str_29typeInfoWTPart,A0.ptc_str_3typeInfoWTPart,A0.ptc_str_30typeInfoWTPart,A0.ptc_str_31typeInfoWTPart,A0.ptc_str_32typeInfoWTPart,A0.ptc_str_33typeInfoWTPart,A0.ptc_str_34typeInfoWTPart,A0.ptc_str_35typeInfoWTPart,A0.ptc_str_36typeInfoWTPart,A0.ptc_str_37typeInfoWTPart,A0.ptc_str_38typeInfoWTPart,A0.ptc_str_4typeInfoWTPart,A0.ptc_str_5typeInfoWTPart,A0.ptc_str_6typeInfoWTPart,A0.ptc_str_7typeInfoWTPart,A0.ptc_str_8typeInfoWTPart,A0.ptc_str_9typeInfoWTPart,A0.validateUsage,A0.variation1,A0.variation2,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0.viewIsNull,A0.classnamekeyview,A0.idA3view,A0B.collapsible,A0B.classnamekeycontainerReferen,A0B.idA3containerReference,A0B.defaultTraceCode,A0B.defaultUnit,A0B.effCalculationStatus,A0B.effPropagationStop,A0B.endItem,A0B.genericType,A0B.hidePartInStructure,A0B.name,A0B.WTPartNumber,A0B.classnamekeyorganizationRefe,A0B.idA3organizationReference,A0B.phantom,A0B.series,A0B.serviceable,A0B.servicekit,TO_CHAR(A0B.createStampA2,'dd mm yyyy hh24:mi:ss'),A0B.markForDeleteA2,TO_CHAR(A0B.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,TO_CHAR(A0B.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0B.authoringLanguagetranslation FROM WTPart A0,WTPartMaster A0B WHERE (A0.idA3masterReference=A0B.idA2A2) AND (((A0.branchIditerationInfo IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (A0.latestiterationInfo = ?))) AND (A0.markForDeleteA2 = 0);
    Database system message follows:
    Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."PTC_STR_9TYPEINFOWTPART": invalid identifier
    	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
    	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
    	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
    	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
    	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
    	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
    	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
  • Error in the Advanced Search Page: 
    ERROR: ORA-00904: "A0"."PTC_STR_8TYPEINFOWTPART": invalid identifier
This is a printer-friendly version of Article 413233 and may be out of date. For the latest version click CS413233