Issues with DQM cognos package

[Abhicog123]

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

[MFGF]

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.

[Abhicog123]

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