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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels

• RB06 PSN

     UP