Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Error when multiplying columns with a decimal

    Posted Fri May 06, 2022 03:12 PM
    Hello, 

    I keep getting the same error code when trying to create a data item that multiplies two columns. For an example the figures it should be multiplying would look like this: (128*.00223). I can't seem to figure out why I keep getting an error code. Any help is appreciated!

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    XQE-GEN-0005 Found an internal error:
    com.cognos.xqe.runtree.relational.vectorization.expressions.generated.XVectorDecimalColumnMultiplyDoubleColumn
    RSV-SRV-0042 Trace back:
    RSReportService.cpp(764): XQEException: CCL_CAUGHT: RSReportService::processImpl()
    RSReportServiceMethod.cpp(262): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request
    RSASyncExecutionThread.cpp(902): XQEException: RSASyncExecutionThread::checkException
    RSASyncExecutionThread.cpp(368): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request
    RSASyncExecutionThread.cpp(947): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request
    Execution/RSRenderExecution.cpp(585): XQEException: CCL_RETHROW: RSRenderExecution::execute
    Assembly/RSDocAssemblyDispatch.cpp(340): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(449): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(449): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSAssembly.cpp(699): XQEException: CCL_RETHROW: RSAssembly::createListIterator
    Assembly/RSAssembly.cpp(767): XQEException: CCL_RETHROW: RSAssembly::createListIterator
    RSQueryMgr.cpp(840): XQEException: CCL_RETHROW: RSQueryMgr::getListIterator
    RSQueryMgr.cpp(912): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIterator
    RSQueryMgr.cpp(1020): XQEException: CCL_RETHROW: RSQueryMgr::createIterator
    RSQueryMgrBasic.cpp(298): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand
    RSQueryMgrExecutionHandlerImpl.cpp(167): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
    QFSSession.cpp(1238): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
    QFSSession.cpp(1236): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
    QFSSession.cpp(1197): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
    QFSConnection.cpp(854): XQEException: CCL_RETHROW: QFSConnection::Execute
    QFSQuery.cpp(213): XQEException: CCL_RETHROW: QFSQuery::Execute v2
    XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send

    ------------------------------
    Dual Herzog
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Error when multiplying columns with a decimal

    Posted Mon May 09, 2022 09:55 AM

    Hi Dual,
    Sorry for the trouble, you've come across a bug in the code.
    Please contact customer support and let them know.
    They will want to know the version of Cognos that you're using.
    You can also contact me directly and set up a webex to see if we can find a to work around this issue.
    Email me at: henk.cazemier@ca.ibm.com



    ------------------------------
    Kind regards,
    HENK CAZEMIER
    ------------------------------