PM05128: UPGRADING A QUERY STUDIO REPORT AND MODIFYING THE FILTER GENERATES QE-DEF-0260

APAR status

• Closed as program error.

Error description

• Upgrading a query studio report from 8.4 GA to 8.4 FP2 and
  modifying the filter generates the below error:
  
  QE-DEF-0260 Parsing error before or near position: 50 of:
  "[Model View].[Primary].[Primary ID] in (360STDBAS"
  
  QE-DEF-0261 QFWP - Parsing text: [Model View].[Primary].[Primary
  ID] in (360STDBAS)QE-DEF-0260 Parsing error before or near
  position: 50 of: "[Model View].[Primary].[Primary ID] in
  (360STDBAS"QE-DEF-0261 QFWP - Parsing text: [Model
  View].[Primary].[Primary ID] in (360STDBAS)RSV-SRV-0042 Trace
  back:RSReportService.cpp(758): QFException: CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(252):
  QFException: CCL_RETHROW: RSReportServiceMethod::process():
  reportEditQuerySpecification_RequestRSASyncExecutionThread.cpp(7
  74):
  QFException:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (211):
  QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
  reportEditQuerySpecification_RequestRSASyncExecutionThread.cpp(8
  24):
  QFException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  reportEditQuerySpecification_RequestExecution/RSRenderExecution.
  cpp(593):
  QFException: CCL_RETHROW:
  RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
  .cpp(64):
  QFException: CCL_RETHROW:
  RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SReportPagesAssembly.cpp(163):
  QFException: CCL_RETHROW:
  RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
  p(281):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
  pp(287):
  QFException: CCL_RETHROW:
  RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
  ly.cpp(160):
  QFException: CCL_RETHROW:
  RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(2
  81):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
  bly.cpp(122):
  QFException: CCL_RETHROW:
  RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
  331):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SDocAssemblyDispatch.cpp(281):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(6
  26):
  QFException: CCL_RETHROW:
  RSAssembly::createListIteratorAssembly/RSAssembly.cpp(667):
  QFException: CCL_RETHROW:
  RSAssembly::createListIteratorRSQueryMgr.cpp(989): QFException:
  CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1062):
  QFException: CCL_RETHROW:
  RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1227):
  QFException: CCL_RETHROW:
  RSQueryMgr::createIteratorRSQueryMgr.cpp(1527): QFException:
  CCL_RETHROW:
  RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1514):
  QFException: CCL_RETHROW:
  RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cp
  p(174):
  QFException: CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHand
  lerImpl.cpp(154):
  QFException: CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(251):
  QFException: CCL_RETHROW:
  RSQFSession::DoRequestQFSSession.cpp(702): QFException:
  CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(700):
  QFException: CCL_CAUGHT:
  QFSSession::ProcessDoRequest()QFSSession.cpp(645): QFException:
  CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(620):
  QFException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSConnection.cpp(737):
  QFException: CCL_RETHROW:
  QFSConnection::ExecuteQFSQuery.cpp(199): QFException:
  CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4178):
  QFException: CCL_THROW: CoordinationPlanner
  
  After hitting the OK button the below error message appears:
  
  RSV-BBP-0036 The request 'asynchWait_Request' failed because a
  previous request that returned a fault cancelled the
  conversation.
  
  RSV-SRV-0042 Trace back:RSReportService.cpp(792): RSException:
  CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(252):
  RSException: CCL_RETHROW: RSReportServiceMethod::process():
  asynchWait_RequestRSReportServiceHelper.cpp(831): RSException:
  CCL_THROW: RSReportServiceHelper::absoluteAffinityError()
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos 8 Business Intelligence 8.4.1  Fix     *
  * Pack 2   or                                                  *
  * Upgrade to IBM Cognos Business Intelligence 10.1             *
  ****************************************************************
  

Problem conclusion

• Code fix
  

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

• Fixed component name

  COG8 BI QUERY S

• Fixed component ID

  5724W12QS

Applicable component levels

• R841 PSN

     UP