1. Home
  2. Support
Article - CS290640

Multiple WinDU tasks failed with the error "java.sql.SQLException: Missing descriptor" in Windchill PDMLink

Modified: 04-Sep-2023   


Applies To

  • Windchill PDMLink 10.0 to 12.1

Description

  • Multiple WinDU tasks failed with the error "java.sql.SQLException: Missing descriptor".
  • Error in WinDU logs:

 

Mon 7/30/18 04:28:16: Caused by: wt.util.WTException: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Mon 7/30/18 04:28:16: Nested exception is: A persistence error occurred.

Mon 7/30/18 04:28:16: Caused by: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Mon 7/30/18 04:28:16: Nested exception is: A persistence error occurred.
Mon 7/30/18 04:28:16:     at wt.pom.PagingHelper.query(PagingHelper.java:443)

Mon 7/30/18 04:28:16: Caused by: A persistence error occurred.
Mon 7/30/18 04:28:16:     at wt.pds.SQLDatabasePds.processSQLException(SQLDatabasePds.java:4144)
Mon 7/30/18 04:28:16:     at wt.pds.OraclePds.insertPageResults(OraclePds.java:249)

Mon 7/30/18 04:28:16: Caused by: A persistence error occurred.
Mon 7/30/18 04:28:16:     ... 42 more
Mon 7/30/18 04:28:16: Caused by: java.sql.SQLException: Missing descriptor
Mon 7/30/18 04:28:16:     at oracle.sql.DatumWithConnection.assertNotNull(DatumWithConnection.java:103)
Mon 7/30/18 04:28:16:     at oracle.sql.ARRAY.(ARRAY.java:117)
 
  • Error in Method Server log:
 
2018-07-30 04:27:44,919 ERROR [RMI TCP Connection(4351)-10.0.40.5] wt.pds.statementParameter wcadmin - getArrayType() descriptor not found: name=TABLE_OF_PAGE_RESULT connection=wt.pom.WTConnection{id=1339345635,sessionId=15,activeCount=3}
2018-07-30 04:27:44,966 ERROR [RMI TCP Connection(4351)-10.0.40.5] 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 "SELECT 'wt.org.WTOrganization',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.blob$entrySetadHocAcl,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.description,A0.disabled,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.inheritedDomain,A0.internal,A0.name,A0.repairNeeded,A0.replicate,A0.securityLabels,A0.status,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'),A1.rowOrder rowOrder FROM WTOrganization A0,(SELECT  /*+ CARDINALITY(wtot 1) */  sessionId,  rowOrder,  oid1,  className1 FROM TABLE(cast(? as PDMLINK11.TABLE_OF_PAGE_RESULT)) wtot) A1 WHERE ((A1.sessionId = ?) AND (A1.rowOrder > ?) AND (A1.rowOrder <= ?)) AND ((A0.idA2A2(+) = A1.oid1) AND (A1.className1 = ?)) ORDER BY rowOrder". Database system message follows:
Nested exception is: java.sql.SQLException: Missing descriptor
    at oracle.sql.DatumWithConnection.assertNotNull(DatumWithConnection.java:103)
    at oracle.sql.ARRAY.(ARRAY.java:117)
 
This is a printer-friendly version of Article 290640 and may be out of date. For the latest version click CS290640