Running Standard Report Results in 'RQP-DEF-0177' and 'ORA-01795: maximum number of expressions in a list is 1000 ' Errors (Doc ID 1589570.1)

Last updated on FEBRUARY 02, 2015

Applies to:

Oracle Health Sciences InForm - Version 4.6.0 and later
Information in this document applies to any platform.

Symptoms

 Running a standard report results in following error:

RQP-DEF-0177
 
       An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

  Details  
 
UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-01795: maximum number of expressions in a list is 1000 RSV-SRV-0042 Trace back: RSReportService.cpp(652): QFException: CCL_CAUGHT: RSReportService::process() RSReportService.cpp(631): QFException: RSAsyncThrowable: RSReportService::process RSASyncExecutionThread.cpp(203): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(656): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(599): QFException: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(873): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments Assembly/RSDocAssemblyDispatch.cpp(235): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageSetAssembly.cpp(287): QFException: CCL_RETHROW: RSPageSetAssembly::assemble Assembly/RSAssembly.cpp(477): QFException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(518): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(950): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1010): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1172): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1479): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1466): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(181): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(173): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(1479): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1477): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1444): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(771): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(115): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3660): QFException: CCL_THROW: CoordinationPlanner 

 

 

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