Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rama83 on 20 May 2009 04:34:05 AM

Title: RQP-DEF-0177 error ocured when running the report
Post by: rama83 on 20 May 2009 04:34:05 AM
Hi All,

I am creating the report in Report Studio(Cognos 8.2).When validating the report it shows no error.
But when i am running the report following error occured.

RQP-DEF-0177
  An error occurred while performing operation 'sqlOpenResult' status='-28'.

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0144 An arithmetic exception was detected. UDA-EE-0029 A date/time value is invalid. UDA-SQL-0460 A general exception has occurred during local processing. RSV-SRV-0042 Trace back: RSReportService.cpp(595): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(562): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(179): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(612): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(584): QFException: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(856): 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(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(247): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(136): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableAssembly.cpp(89): QFException: CCL_RETHROW: RSTableAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableRowAssembly.cpp(136): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableAssembly.cpp(89): QFException: CCL_RETHROW: RSTableAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableRowAssembly.cpp(136): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward RSQueryMgr.cpp(1007): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1169): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1455): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1442): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(156): 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(3643): QFException: CCL_THROW: CoordinationPlanner


Please help me

Thanks in advance.........
Title: Re: RQP-DEF-0177 error ocured when running the report
Post by: kolonell on 20 May 2009 04:37:27 AM
the description is pretty vague but look at the error :

> UDA-EE-0029 A date/time value is invalid

Go through the report and check whether you're doing some calculations that involve time/date. Is the Data (in the DB) for that time/date a valid format. ..   
Title: Re: RQP-DEF-0177 error ocured when running the report
Post by: rama83 on 21 May 2009 05:46:29 AM
Thanks for your replay,

Date and time valid in the database level.Using the date column i am doing following calculation
(cast([Common Dimensions].[MIS Time].[Date Name],date)>=
?par_from_day?
AND
cast([Common Dimensions].[MIS Time].[Date Name],date)<=
?par_to_day?)

When i am running the report getting artheme tic error occurred

Please give me any solution
thanks in advance..........
Title: Re: RQP-DEF-0177 error ocured when running the report
Post by: dumbell on 21 May 2009 11:49:30 AM
What is the datatype of the dateyou are using?
We some times take it for granted that it is date, but as you know there is datetime and other datatypes...

Hope this helps!!

Title: Re: RQP-DEF-0177 error ocured when running the report
Post by: Gollapudi on 26 May 2009 04:41:51 AM
Hi,

Can you tell me whatz ur intention in using Cast function here..

Quote(cast([Common Dimensions].[MIS Time].[Date Name],date)>=
?par_from_day?
AND
cast([Common Dimensions].[MIS Time].[Date Name],date)<=
?par_to_day?)
Title: Re: RQP-DEF-0177 error ocured when running the report
Post by: Rajaggopal on 29 May 2009 02:39:26 AM
I have experienced same type of error in 8.4. It just so happened that i tried to cast date into date itself and it threw error. So just check if what you are casting is a string or a date itself. If it is string check its format and if its date then simply remove the unnecessary cast function and try if it works...
Text only | Text with Images