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

(Doc ID 2342120.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

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

[ERROR] com.bm.xchange.services.GeneralDBService.processSqlError(GeneralDBService.java:247) - 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms