Author Topic: Issues with DQM cognos package  (Read 251 times)

Offline Abhicog123

  • Associate
  • **
  • Join Date: Oct 2016
  • Posts: 2
  • Forum Citizenship: +0/-0
Issues with DQM cognos package
« on: 21 Aug 2017 03:40:29 am »
Hi Cognos Experts,

Recently We published cognos package in dynamic query mode. After that reports pointing to the package are facing a common error which is shown below:

XQE-GEN-0005
 
      Found an internal error:
Encountered "-" at line 5, column 3.
Was expecting one of:
":" ...
"?" ...
"absolute" ...
"absent" ...
"action" ...
"after" ...
"aggregate" ...
"anytype" ...
"asc" ...
"bit" ...
"cascade" ...
"case" ...
"cast" ...
"coalesce" ...
"collation" ...
"columns" ...
"content" ...
"current_date" ...
"current_time" ...
"current_timestamp" ...
"current_user" ...
"data" ...
"date" ...
"day" ...
"days" ...
"desc" ...
"document" ...
"empty" ...
"epoch" ...
"false" ...
"first" ...
"flag" ...
"following" ...
"general" ...
"global" ...
"hour" ...
"ignore" ...
"index" ...
"input" ...
"install" ...
"java" ...
"java_object" ...
"json_array" ...
"json_object" ...
"json_query" ...
"json_value" ...
"key" ...
"last" ...
"local" ...
"localtime" ...
"localtimestamp" ...
"long" ...
"minute" ...
"month" ...
"multiset" ...
"name" ...
"names" ...
"next" ...
"nfc" ...
"nfd" ...
"nfkc" ...
"nfkd" ...
"nil" ...
"null" ...
"nulls" ...
"nullif" ...
"number" ...
"option" ...
"ordinal" ...
"ordinality" ...
"passing" ...
"path" ...
"period" ...
"preceding" ...
"precision" ...
"preserve" ...
"public" ...
"remove" ...
"respect" ...
"second" ...
"sequence" ...
"session_user" ...
"sets" ...
"size" ...
"start" ...
"string" ...
"strip" ...
"style" ...
"system_user" ...
"temporary" ...
"time" ...
"timestamp" ...
"timezone_hour" ...
"timezone_minute" ...
"to_json" ...
"true" ...
"unbounded" ...
"unknown" ...
"user" ...
"view" ...
"whitespace" ...
"year" ...
"zone" ...
"xmlcomment" ...
"xmlconcat" ...
"xmldocument" ...
"xmlelement" ...
"xmlforest" ...
"xmlparse" ...
"xmlpi" ...
"xmlquery" ...
"xmlserialize" ...
"xmltext" ...
"xmltransform" ...
"xmlvalidate" ...
<PATH_QUALIFIED_IDENTIFIER> ...
<QUALIFIED_NATIVE_SQL_STMT> ...
<QUALIFIED_PASS_THROUGH_SQL_STMT> ...
<IDENTIFIER> ...
<INTEGER_LITERAL> ...
<FIXED_POINT_LITERAL> ...
<FLOAT_LITERAL> ...
<STRING_LITERAL> ...
<NSTRING_LITERAL> ...
<BINARY_LITERAL> ...
<NATIVE_SQL_STMT> ...
<PASS_THROUGH_SQL_STMT> ...
<DATE_LITERAL> ...
<TIME_LITERAL> ...
<TIMETZ_LITERAL> ...
<TIMESTAMP_LITERAL> ...
<TIMESTAMPTZ_LITERAL> ...
<INTERVAL_LITERAL_PREFIX> ...
"period" ...
<IDENTIFIER> ...
"absent" ...
"absolute" ...
"action" ...
"after" ...
"aggregate" ...
"anytype" ...
"asc" ...
"bit" ...
"cascade" ...
"collation" ...
"columns" ...
"content" ...
"data" ...
"date" ...
"day" ...
"days" ...
"desc" ...
"document" ...
"empty" ...
"epoch" ...
"first" ...
"flag" ...
"following" ...
"general" ...
"global" ...
"hour" ...
"ignore" ...
"index" ...
"input" ...
"install" ...
"java" ...
"java_object" ...
"key" ...
"last" ...
"local" ...
"long" ...
"minute" ...
"month" ...
"name" ...
"names" ...
"next" ...
"nfc" ...
"nfd" ...
"nfkc" ...
"nfkd" ...
"nil" ...
"nulls" ...
"number" ...
"option" ...
"ordinal" ...
"ordinality" ...
"passing" ...
"path" ...
"period" ...
"preceding" ...
"precision" ...
"preserve" ...
"public" ...
"remove" ...
"respect" ...
"second" ...
"sequence" ...
"sets" ...
"size" ...
"start" ...
"string" ...
"strip" ...
"style" ...
"temporary" ...
"time" ...
"timestamp" ...
"timezone_hour" ...
"timezone_minute" ...
"unbounded" ...
"view" ...
"whitespace" ...
"year" ...
"zone" ...
"index" ...
"date" ...
<IDENTIFIER> ...
"absent" ...
"absolute" ...
"action" ...
"after" ...
"aggregate" ...
"anytype" ...
"asc" ...
"bit" ...
"cascade" ...
"collation" ...
"columns" ...
"content" ...
"data" ...
"date" ...
"day" ...
"days" ...
"desc" ...
"document" ...
"empty" ...
"epoch" ...
"first" ...
"flag" ...
"following" ...
"general" ...
"global" ...
"hour" ...
"ignore" ...
"index" ...
"input" ...
"install" ...
"java" ...
"java_object" ...
"key" ...
"last" ...
"local" ...
"long" ...
"minute" ...
"month" ...
"name" ...
"names" ...
"next" ...
"nfc" ...
"nfd" ...
"nfkc" ...
"nfkd" ...
"nil" ...
"nulls" ...
"number" ...
"option" ...
"ordinal" ...
"ordinality" ...
"passing" ...
"path" ...
"period" ...
"preceding" ...
"precision" ...
"preserve" ...
"public" ...
"remove" ...
"respect" ...
"second" ...
"sequence" ...
"sets" ...
"size" ...
"start" ...
"string" ...
"strip" ...
"style" ...
"temporary" ...
"time" ...
"timestamp" ...
"timezone_hour" ...
"timezone_minute" ...
"unbounded" ...
"view" ...
"whitespace" ...
"year" ...
"zone" ...
<PATH_QUALIFIED_IDENTIFIER> ...
 
     DetailsExpand
RSV-SRV-0042 Trace back:RSReportService.cpp(754): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(859): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(314): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(904): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(600): XQEException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(340): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(446): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(706): XQEException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(770): XQEException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(564): XQEException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(636): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(744): XQEException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1163): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1161): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1118): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(888): XQEException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(311): XQEException: CCL_RETHROW: QFSQuery::Execute v2XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send
 
 
Can anyone please suggest a fix for this?

Thanks
Abhi

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,864
  • Forum Citizenship: +597/-9
  • Cognos Software Muppet
Re: Issues with DQM cognos package
« Reply #1 on: 21 Aug 2017 05:12:11 am »
Hi,

This sounds like a possible product defect to me. Have you logged it with IBM support? What version and fix pack of Cognos 10 are you currently using?

MF.
Meep!

Offline Abhicog123

  • Associate
  • **
  • Join Date: Oct 2016
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Issues with DQM cognos package
« Reply #2 on: 23 Aug 2017 04:04:03 am »
Hi MF,

I need to check that with IBM and also if latest fix patch has been applied to the server env.  Can you please let me know any alternative fix or workaround on FM model level or Cognos report level.

Thanks
Abhi

 


       
Twittear