IBM Support

PI88665: WHEN YOU EXECUTE A REPORT AGAINST POSTGRESQL (JDBC),

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When you execute a report against PostGresql (JDBC), cancel the
    report while it is running and run it again, you will hit the
    following error message :
    XQE-DAT-0001 Data source adapter error:
    org.postgresql.util.PSQLException: ERROR: current transaction is
    aborted, commands ignored until end of transaction:
    ERROR: cancelling statement due to user request
    RSV-SRV-0042 Trace back:
    RSReportService.cpp(762): XQEException: CCL_CAUGHT:
    RSReportService::processImpl()
    RSReportServiceMethod.cpp(259): XQEException: CCL_RETHROW:
    RSReportServiceMethod::process(): asynchRunSpecification_Request
    RSASyncExecutionThread.cpp(871): XQEException:
    RSASyncExecutionThread::checkException
    RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT:
    RSASyncExecutionThread::runImpl():
    asynchRunSpecification_Request
    RSASyncExecutionThread.cpp(916): XQEException: CCL_RETHROW:
    RSASyncExecutionThread::processCommand():
    asynchRunSpecification_Request
    Execution/RSRenderExecution.cpp(595): XQEException: CCL_RETHROW:
    RSRenderExecution::execute
    Assembly/RSDocAssemblyDispatch.cpp(340): XQEException:
    CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW:
    RSLayoutAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(446): XQEException:
    CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSReportPagesAssembly.cpp(185): XQEException:
    CCL_RETHROW: RSReportPagesAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException:
    CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW:
    RSPageAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException:
    CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW:
    RSTableRowAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException:
    CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableCellAssembly.cpp(151): XQEException:
    CCL_RETHROW: RSTableCellAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(446): XQEException:
    CCL_RETHROW:
    RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSSingletonAssembly.cpp(126): XQEException:
    CCL_RETHROW: RSSingletonAssembly::assemble
    Assembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW:
    RSAssembly::createListIterator
    RSQueryMgr.cpp(785): XQEException: CCL_RETHROW:
    RSQueryMgr::getListIterator
    RSQueryMgr.cpp(857): XQEException: CCL_RETHROW:
    RSQueryMgr::getResultSetIterator
    RSQueryMgr.cpp(965): XQEException: CCL_RETHROW:
    RSQueryMgr::createIterator
    RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW:
    RSQueryMgrBasic::executeRsapiCommand
    RSQueryMgrExecutionHandlerImpl.cpp(168): XQEException:
    CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
    QFSSession.cpp(1182): XQEException: CCL_RETHROW:
    QFSSession::ProcessDoRequest()
    QFSSession.cpp(1180): XQEException: CCL_CAUGHT:
    QFSSession::ProcessDoRequest()
    QFSSession.cpp(1137): 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

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI88665

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B06

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-11

  • Closed date

    2018-11-02

  • Last modified date

    2018-11-02

  • 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 Business Intelligence
Report Studio

Software version: B06

Reference #: PI88665

Modified date: 02 November 2018


Translate this page: