If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

ERROR - RQP-DEF-0177 when execute a report (Cognos BI 8.4.1)

Started by MaryPoppins, 10 Nov 2010 04:45:38 AM

Previous topic - Next topic

MaryPoppins

Hi,

When I try to run my report in Report Studio I have the following message :

Quote
RQP-DEF-0177

An error occurred while executing the operation "sqlPrepareWithOptions state = '-201'.

Details
UDA-SQL-0107 An error occurred during the operation 'open cursor'.[IBM][CLI Driver][DB2] SQL0443N Routine "SQLCOLUMNS" (specific name "SQLCOLUMNS") has returned an error SQLSTATE with diagnostic text "-551 W#IMPF04ŸSELECTŸSYSIBM.SQTCOLUMNS". SQLSTATE=38222 UDA-SQL-0196 La table ou la vue 'LOCALITE' est introuvable dans le dictionnaire.RSV-SRV-0042 Parcours arrière :RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(252): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSAssembly.cpp(626): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(667): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(989): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1062): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1227): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1527): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1514): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(251): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(702): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(700): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(645): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(620): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4178): QFException: CCL_THROW: CoordinationPlanner

But during tests in Framwork Manager no errors occurred (with the package or objects). The data is viewable.

Thank you for your help

MFGF

Hi,

It's complaining that it can't find the LOCALITE table in your data source.  Is it possible that the database and framework model may have been changed since the report was written?  If you look in FM, is there a LOCALITE table in the model, and if so, does it test OK?

If so, try re-publishing the package and then opening and saving the report in Report Studio.

Regards,

MF.
Meep!