PI97741: WRONG PACKAGE WHEN ADDING QUERY IN MULTIPLE PACKAGE REPORT

APAR status

• Closed as fixed if next.

Error description

• XQE-V5-0005 Identifier not found '[Employee expense
  (query)].[Organization].[Organization name (level 1)]'.
  RSV-SRV-0042 Trace back:
  RSReportService.cpp(766): XQEException: CCL_CAUGHT:
  RSReportService::processImpl()
  RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW:
  RSReportServiceMethod::process(): asynchRunSpecification_Request
  RSASyncExecutionThread.cpp(873): XQEException:
  RSASyncExecutionThread::checkException
  RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT:
  RSASyncExecutionThread::runImpl():
  asynchRunSpecification_Request
  RSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  asynchRunSpecification_Request
  Execution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW:
  RSRenderExecution::execute
  Assembly/RSDocAssemblyDispatch.cpp(346): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW:
  RSLayoutAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(455): XQEException:
  CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
  Assembly/RSReportPagesAssembly.cpp(185): XQEException:
  CCL_RETHROW: RSReportPagesAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW:
  RSPageAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW:
  RSTableRowAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSTableCellAssembly.cpp(151): XQEException:
  CCL_RETHROW: RSTableCellAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(455): XQEException:
  CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
  Assembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW:
  RSAssembly::createListIterator
  Assembly/RSAssembly.cpp(766): XQEException: CCL_RETHROW:
  RSAssembly::createListIterator
  RSQueryMgr.cpp(809): XQEException: CCL_RETHROW:
  RSQueryMgr::getListIterator
  RSQueryMgr.cpp(881): XQEException: CCL_RETHROW:
  RSQueryMgr::getResultSetIterator
  RSQueryMgr.cpp(989): XQEException: CCL_RETHROW:
  RSQueryMgr::createIterator
  RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW:
  RSQueryMgrBasic::executeRsapiCommand
  RSQueryMgrExecutionHandlerImpl.cpp(168): XQEException:
  CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
  QFSSession.cpp(1190): XQEException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()
  QFSSession.cpp(1188): XQEException: CCL_CAUGHT:
  QFSSession::ProcessDoRequest()
  QFSSession.cpp(1145): XQEException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()
  QFSConnection.cpp(888): XQEException: CCL_RETHROW:
  QFSConnection::Execute
  QFSQuery.cpp(311): XQEException: CCL_RETHROW: QFSQuery::Execute
  v2
  XQEConnector.cpp(300): XQEException: CCL_THROW:
  XQEConnector::send
  

Local fix

• Bring in queries through report and not through Query tab
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.2                       *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

Fix information

Applicable component levels