It's all about the answers!

Ask a question

Why are we getting 'sqlPrepareWithOptions' status='-126 errors when running a custom report after migrating to RRDI 2.0.3?

Michael Walker (99214200157) | asked Aug 27 '13, 7:43 p.m.
edited Sep 02 '13, 11:09 p.m. by Jun Wang (6077)
We migrated a customer from CLM 4.0.1 and RRDI 2.0.1 to CLM 4.0.3 and RRDI 2.0.3.  After migration a couple of their custom reports are now failing with the error below.  I imported these failing reports into a separate RRDI 2.0.1 install and didn't get the error there.  As part of the migration I ran the step in the RRDI Setup to download the latest data models and reports and upload to RRDI.

The logs didn't tell me anything additional and I'm not really sure how to start debugging the Varchar and Date2 issue listed in the error.

Any ideas how to fix this? It appears the Data Model changed in 2.0.3 and is no longer compatible with these reports for some reason.

UDA-SQL-0460 A general exception has occurred during local processing.UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "varchar" and "date2"RSV-SRV-0042 Trace back:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(670): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(291): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(308): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(662): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(717): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(1055): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1131): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1295): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1569): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1559): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(168): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(160): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4456): QFException: CCL_THROW: CoordinationPlanner

Michael Walker commented Aug 27 '13, 9:20 p.m.

I tracked it to this custom field with expression:  cast ([Risk Last Updated], date).

The field it's referring to is [Business View].[Request].[Last Updated] that was labeled as Risk Last Updated.

One answer

permanent link
Jun Wang (6077) | answered Sep 02 '13, 11:14 p.m.
It seems that you use add function in your report template, but the function does not support "varchar" and "date2".

Are you using SQL Server as your DW? What is the connection type to define the RIDW connection on RRDI? It should use SQL Server Native Client as the connection type.

It is better that you attach the report xml into it.
Open the report template with Report Studio, click Tools->Copy Report to Clipboard on the tool bar, then paste the content into a xml file.

Michael Walker commented Sep 03 '13, 1:48 a.m.

Thanks for the reply. Once I was able to narrow down the issue to the expression listed above, the customer was able to fix the report.

Are these changes between releases documented anywhere? It would be nice to be proactive and notify the teams we support of any changes rather than waiting for them to approach us with issues after migration.

Our DW db is on DB2 9.7 on AIX.

Jun Wang commented Sep 03 '13, 2:12 a.m.

I do not know what the exact change on FM to make your problem. It should ask RRDI team.

Your answer

Register or to post your answer.