Error-RQP-DEF-0177--When we select all values in Value prompt

[Kalyan cognoise]

When I tried to select all values(around 520) in the value prompt and run the report ,I am getting this error.....If I select around 400 values , I am getting report output without any issues.Anyone pls help me on this issue.

UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "AOpen". UDA-SQL-0445 The Sybase server: FMQA returned the following message: "The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces. spid: %d, suid: %d, hostname: %.*s, application name: %.*s". RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(740): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(614): QFException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(251): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(63): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(284): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(154): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(108): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(610): QFException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(651): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(952): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1019): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1165): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1475): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1462): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(172): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(241): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(610): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(608): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(557): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(117): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3787): QFException: CCL_THROW: CoordinationPlanner

[jayani]

Hi,

Actually I got the same error when I used Oracle Database.
Oracle has the limitation of passing only 1000 values from a value prompt.
I had nearly 1100 values in my value prompt. When I select all, it was showing me error.
Then I found that it is an oracle limitation.

Just chk whether itz a similar issue.

~Jayani.

[cognosjon]

Can you not make the prompt optional, that way it will return all by default without the need to click select all.