PI77664: REPORT EXECUTION ERROR OCCURS WITH A PACKAGE INCLUDING STORED PROCEDURE AFTER EXTERNAL DATA DEFINITION.

APAR status

• Closed as program error.

Error description

• Report execution error occurs with a package including stored
  procedure after external data definition.
  
  XQE-PLN-0011 The relation 'GET_ITEMDATA2" could not be found in
  the model.
  
  RSV-SRV-0042 :RSReportService.cpp(756): XQEException:
  CCL_CAUGHT:
  RSReportService::processImpl()RSReportServiceMethod.cpp(259):
  XQEException: CCL_RETHROW: RSReportServiceMethod::process():
  promptPagingForward_RequestRSASyncExecutionThread.cpp(854):
  XQEException:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (311): XQEException: CCL_CAUGHT:
  RSASyncExecutionThread::runImpl():
  promptPagingForward_RequestRSASyncExecutionThread.cpp(910):
  XQEException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  promptPagingForward_RequestExecution/RSRenderExecution.cpp(589):
  XQEException: CCL_RETHROW:
  RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(324
  ): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
  .cpp(79): XQEException: CCL_RETHROW:
  RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(418
  ): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SReportPagesAssembly.cpp(178): XQEException: CCL_RETHROW:
  RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
  p(368): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
  pp(314): XQEException: CCL_RETHROW:
  RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(368):
  XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
  ly.cpp(177): XQEException: CCL_RETHROW:
  RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(3
  68): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
  bly.cpp(151): XQEException: CCL_RETHROW:
  RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
  418): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SDocAssemblyDispatch.cpp(368): XQEException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSChartAssembly.
  cpp(304): XQEException: CCL_RETHROW:
  RSChartAssembly::assembleRSQueryMgr.cpp(621): XQEException:
  CCL_RETHROW:
  RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(713):
  XQEException: CCL_RETHROW:
  RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289):
  XQEException: CCL_RETHROW:
  RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerIm
  pl.cpp(175): XQEException: CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1152):
  XQEException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSSession.cpp(1150):
  XQEException: CCL_CAUGHT:
  QFSSession::ProcessDoRequest()QFSSession.cpp(1107):
  XQEException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSConnection.cpp(800):
  XQEException: CCL_RETHROW:
  QFSConnection::ExecuteQFSQuery.cpp(213): XQEException:
  CCL_RETHROW: QFSQuery::Execute v2XQEConnector.cpp(289):
  XQEException: CCL_THROW: XQEConnector::send
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
  * 9                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

• A fix for this APAR is targeted for IBM COGNOS 10.2.2 BI Fix
  Pack 9.
  The Fix Pack Release Schedule can be found at
  http://www.ibm.com/software/analytics/support/fixes/pbi_schedule
  .html.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI75779

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG CONNECTION

• Fixed component ID

  5724W12CC

Applicable component levels

• RA22 PSN

     UP