Help can anyone help with this error

[coledog]

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 

[sir_jeroen]

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

[sir_jeroen]

addition:http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=1026973&version_id=1

[coledog]

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.

[sir_jeroen]

How many cols are there in each statement?