技术文章 - CS413233
在 Windchill PDMLink 中,CPS 更新后出现错误:“嵌套异常为:java.sql.SQLSyntaxErrorException:ORA-00904:“A0”。“PTC_STR_3TYPEINFOWTDOCUMENT”:无效标识符”。
已修改: 15-Jan-2026
适用于
- Windchill PDMLink 12.0 to 13.0
说明
- 数据库刷新/CPS更新后,无法获取文件夹内容中的数据

- 方法服务器日志中出现错误
INFO [main] 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: xxxx-xx-xx xx:xx:xx,xxx INFO [main] wt.system.err - Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."PTC_STR_3TYPEINFOWTDOCUMENT": invalid identifier xxxx-xx-xx xx:xx:xx,xxx INFO [main] wt.system.err - xxxx-xx-xx xx:xx:xx,xxx INFO [main] wt.system.err - at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
- 高级搜索页面出错:
ERROR: ORA-00904: "A0"."PTC_STR_8TYPEINFOWTPART": invalid identifier
这是文章 413233 的 PDF 版本,可能已过期。最新版本 CS413233