Article - CS23957
False ORA-00942 table or view does not exist errors applies to Windchill PDMLink 10.0
Modified: 07-Jun-2017
Applies To
- Windchill PDMLink 10.0 F000 to 10.1 M050
Description
- Check out, check in, or Create New actions fail with ORA-00942: table or view does not exist
- Error returned for queries where the referenced tables or views do exist
-
Example MethodServer.log output:
-
A persistence error occurred.
ERROR [ajp-bio-8010-exec-1] wt.index.StandardIndexPolicyManager wcadmin - Error processing collection
(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 QueueEntry(classnameA2A2,updateCountA2,administrativeLockIsNull,typeadministrativeLock,args,blob$args,classnamekeydomainRef,idA3domainRef,endExec,entryNumber,entryOwnerIsNull,classnamekeyB5,idA3B5,failureCount,inheritedDomain,datelock,classnamekeyA2lock,idA3A2lock,notelock,classnamekeyA5,idA3A5,securityLabels,startExec,statusInfoIsNull,codeC5,messageC5,rescheduleTimeC5,targetClass,targetMethod,markForDeleteA2,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.queue.QueueEntry',1,?,?,?,?,?,?,?,entryNumber_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
-
A persistence error occurred.
This is a printer-friendly version of Article 23957 and may be out of date. For the latest version click CS23957