PI30690: REPORT RUNNING AGAINST A SAP BW DATASOURCE FAILS WITH AN ERROR. REPORT WORKED IN PREVIOUS VERSION

APAR status

• Closed as program error.

Error description

• RQP-DEF-0177 An error occurred while performing operation
  'sqlPrepareWithOptions' status='-267'.  UDA-SQL-0551 The rowset
  "Filters Query for Union" was not found.  RSV-SRV-0042 Trace
  back:
  RSReportService.cpp(717): QFException: CCL_CAUGHT:
  RSReportService::processImpl()  RSReportServiceMethod.cpp(258):
  QFException: CCL_RETHROW: RSReportServiceMethod::process():
  asynchWait_Request  RSASyncExecutionThread.cpp(854):
  QFException:
  RSASyncExecutionThread::checkException
  RSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT:
  RSASyncExecutionThread::runImpl(): asynchRun_Request
  RSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand(): asynchRun_Request
  RSRequest.cpp(1029): QFException: CCL_THROW:
  RSRequest::executeImpl
  RSQueryMgr.cpp(520): QFException: CCL_RETHROW:
  RSQueryMgr::getListIterator  RSQueryMgr.cpp(587): QFException:
  CCL_RETHROW: RSQueryMgr::getResultSetIterator
  RSQueryMgr.cpp(679):
  QFException: CCL_RETHROW: RSQueryMgr::createIterator
  RSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW:
  RSQueryMgrBasic::executeRsapiCommand  RSQueryMgrBasic.cpp(278):
  QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand
  RSQueryMgrExecutionHandlerImpl.cpp(175): QFException:
  CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()
  RSQueryMgrExecutionHandlerImpl.cpp(166): QFException:
  CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()  QFSSession.cpp(1153):
  QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
  QFSSession.cpp(1151): QFException: CCL_CAUGHT:
  QFSSession::ProcessDoRequest()  QFSSession.cpp(1108):
  QFException:
  CCL_RETHROW: QFSSession::ProcessDoRequest()
  QFSSession.cpp(1084):
  QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
  QFSConnection.cpp(788): QFException: CCL_RETHROW:
  QFSConnection::Execute  QFSQuery.cpp(213): QFException:
  CCL_RETHROW:
  QFSQuery::Execute v2  CoordinationQFSQuery.cpp(4484):
  QFException:
  CCL_THROW: CoordinationPlanner
  

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  *
  * 1                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

• A fix for this APAR is targeted for IBM Cognos Business
  Intelligence 10.2.2 Fix Pack 1
  
  The Fix Pack Release Schedule can be found at
  www-01.ibm.com/software/analytics/cognos/support/fixpacks.html
  

APAR Information

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

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

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels