Report errors out with "The running query contains a reference to at least one object" and "that does not exist" (Doc ID 1474699.1)

Last updated on MAY 15, 2014

Applies to:

Oracle Health Sciences InForm - Version 4.5.0 and later
Information in this document applies to any platform.
Report Studio report

Symptoms

 Report errors out with detailed error below.

----
Error :
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00904: "<COLUMN NAME>": invalid identifier
UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00942: table or view does not exist
UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The running query contains a reference to at least one object '[Inform].[<OBJECT>].[<OBJECT>]' that does not exist.
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00904: "<COLUMN>": invalid identifier
UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
Trace back:
WPBIBusMethod.cpp(198): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::runRequest
WPReportExecutionMethod.cpp(175): WPDataRetrievalException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException
WPEngine.cpp(1034): WPDataRetrievalException:
WPController.cpp(263): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(320): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare
LWDataRetrievalEngine.cpp(1925): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery
Source/QE_QsApi.cpp(3385): QSException: CCL_THROW: QE

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