Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Michael Walker
(992●15●201●157) edited
Sep 02 '13, 11:09 p.m.
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


0 votes

Comments
Michael Walker
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.

1 answer
13,461 views
0 votes

One answer

Permanent link
Jun Wang
(607●7) 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.

0 votes

Comments
Michael Walker
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
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 log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,517
× 403

Question asked: Aug 27 '13, 7:43 p.m.

Question was seen: 13,461 times

Last updated: Sep 03 '13, 2:12 a.m.

Confirmation Cancel Confirm