IBM Support

PI97741: WRONG PACKAGE WHEN ADDING QUERY IN MULTIPLE PACKAGE REPORT

Subscribe

You can track all active APARs for this component.

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 number

    PI97741

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B09

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-05-08

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

  • 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



Document information

More support for: Cognos Analytics
Report Authoring v11x

Software version: B09

Reference #: PI97741

Modified date: 05 June 2019