can anyone help with this error
RQP-DEF-0177
An error occurred while performing operation 'sqlPrepareWithOptions' status='-208'.
Details
UDA-SQL-0198 The maximum number of tables "192" in a request has been exceeded. RSV-SRV-0042 Trace back: RSReportService.cpp(624): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(168): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(520): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(175): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(570): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(507): QFException: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(713): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments Assembly/RSDocAssemblyDispatch.cpp(229): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(236): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(115): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(248): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(487): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(722): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(787): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(955): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1516): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1499): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand QFSSession.cpp(1423): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1421): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1392): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(731): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(112): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3254): QFException: CCL_THROW: CoordinationPlanner
What DB are you using?
When you cut & paste the sql from the report and run it in an editor, does it run then?
It looks like a limitation of the database that has been set in one of the cogxxx.ini files. Usually these files contain the settings as they are from the db manufacturer.
If you can run the report sql directly on the db them it could be something in the cognos environment, otherwise it's a DBMS limit.
Have contacted Cognos Support about this?
Btw: Next time take a look at Cognos Support first because if you copy paste your error you will get several results regarding this:
e.g. http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=1024815&version_id=1
addition:http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=1026973&version_id=1
We are using ms sql 2000. both parts run fine by themself in a union the part that comes out of the union gives us this error. The sql is correct and it ont a join problem. Any help you can give I thank you.
How many cols are there in each statement?