PM70180: QE-DEF-0360 The query contains a reference to at least one object '[SQL1].[Column]' that does not exist

APAR status

• Closed as fixed if next.

Error description

• Upgrade from Cognos 8.3 to Cognos 10.1.1, report no longer works
  and fails with error.??QE-DEF-0030 ? ?      Expression parsing
  error. ? ?     Details ?QE-DEF-0360 The query contains a
  reference to at least one object '[SQL1].[Product_line]' that
  does not exist. Possible cause is the use of 2-part reference to
  a model query item, which is a deprecated feature.QE-DEF-0030
  Expression parsing error.QE-DEF-0360 The query contains a
  reference to at least one object '[SQL1].[Product_line]' that
  does not exist. Possible cause is the use of 2-part reference to
  a model query item, which is a deprecated feature.RQP-DEF-0149
  The query specification is incorrect.RQP-DEF-0457 Referenced
  Query 'Relational Query' is not defined or its query items
  contain unresolved references.RSV-SRV-0042 Trace
  back:RSReportService.cpp(722): QFException: CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(263):
  QFException: CCL_RETHROW: RSReportServiceMethod::process():
  asynchRunSpecification_RequestRSASyncExecutionThread.cpp(808):
  QFException:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (260):
  QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl():
  asynchRunSpecification_RequestRSASyncExecutionThread.cpp(864):
  QFException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(67
  0):
  QFException: CCL_RETHROW:
  RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(291
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
  .cpp(79):
  QFException: CCL_RETHROW:
  RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(358
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SReportPagesAssembly.cpp(179):
  QFException: CCL_RETHROW:
  RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
  p(308):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
  pp(303):
  QFException: CCL_RETHROW:
  RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(308):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
  ly.cpp(177):
  QFException: CCL_RETHROW:
  RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(3
  08):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
  bly.cpp(137):
  QFException: CCL_RETHROW:
  RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
  358):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SAssembly.cpp(662):
  QFException: CCL_RETHROW:
  RSAssembly::createListIteratorAssembly/RSAssembly.cpp(717):
  QFException: CCL_RETHROW:
  RSAssembly::createListIteratorRSQueryMgr.cpp(1055): QFException:
  CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1131):
  QFException: CCL_RETHROW:
  RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1295):
  QFException: CCL_RETHROW:
  RSQueryMgr::createIteratorRSQueryMgr.cpp(1569): QFException:
  CCL_RETHROW:
  RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1559):
  QFException: CCL_RETHROW:
  RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cp
  p(168):
  QFException: CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHand
  lerImpl.cpp(160):
  QFException: CCL_RETHROW:
  RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1147):
  QFException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException:
  CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1102):
  QFException: CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSSession.cpp(1078): QFException:
  CCL_RETHROW:
  QFSSession::ProcessDoRequest()QFSConnection.cpp(788):
  QFException: CCL_RETHROW:
  QFSConnection::ExecuteQFSQuery.cpp(213): QFException:
  CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4456):
  QFException: CCL_THROW: CoordinationPlanner ? ??This report does
  a comparison between an SQL item and an OLAP value:?IF (
  [SQL1].[Product_line] = [OLAP Query].[Caption] ) then ('Yes')
  else ('No')
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

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

• RA21 PSN

     UP