Article - CS133891

Error in Integrity Lifecycle Manager server.log file: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Modified: 18-Apr-2016   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 2009 9.7 to 12.4
  • Oracle

Description

  • Error in Integrity server.log file: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  • If SQL logging is enabled, the following error is frequently thrown in the server.log file:
    java.sql.SQLSyntaxErrorException -- java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
    There are no obvious errors on the client side, and the SQL logging is as expected.
  • What are the Oracle database permissions required by the Integrity database user?
This is a printer-friendly version of Article 133891 and may be out of date. For the latest version click CS133891