My Oracle Support Banner

Previous Deployed Data Cannot be Found [java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist] (Doc ID 2342120.1)

Last updated on DECEMBER 19, 2018

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 11.0 and later
Information in this document applies to any platform.


When performing an action on the site, that involves a BMQL call, the following error is seen in the BM log:

[ERROR] - Error while trying to execute a sql statement ({SQLID}) <BAD SQL!!!> SELECT field5 FROM (SELECT /*+ FIRST_ROWS(1000) */  DISTINCT field5 FROM bm_#######_depdata WHERE ( (bm_#######_depdata.field5 IN (?,?,?,?,?)   )   )) WHERE  ( rownum < ? )
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.