XQE-GEN-0005 Found an internal error:DIVIDE BY ZERO

[darshana.online]

Hi All,

I am having a weird error with Cognos 11. I have a SQL data source connected to Cognos, and it has been working fine for the whole time. But for a couple of days, I am receiving below error when I run the reports "sometimes". Once I re-run it, the report works fine. The problem comes when the schedule reports are getting the same error and failed to run.

Any advice would be highly appreciated.

Cognos Error: XQE-GEN-0005 Found an internal error: DIVIDE BY ZERO

Error details from the cognos logs :

10.220.11.24:9300   4843   2020-08-26 07:30:02.235   -4   30CD2FC308458420AB2E7FFDE7F1EB6EB398841B33DBC1EAA5F5B431909AE5D6   h422dwlwssqsqwvwqCsj82q9vsqwCdwMyswls82C   2      Default Executor-thread-1511293   DISP   12   2   Audit.Other.dispatcher.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   Request         Failure   <messages><message><messageString>Client Error</messageString></message><message><messageString>XQE-GEN-0005 Found an internal error: divide by zero</messageString></message></messages>
   http://www.ibm.com/xmlns/prod/cognos/batchReportService/201703/.serverRSV-SRV-0042 Trace back:RSReportService.cpp(766): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(873): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW: RSRenderExecution::executeExecution/RSRenderExecution.cpp(831): XQEException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(766): XQEException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(809): XQEException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(881): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(989): XQEException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(168): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1190): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1188): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): 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



Thank you
Darshana

[MFGF]

Hi All,

I am having a weird error with Cognos 11. I have a SQL data source connected to Cognos, and it has been working fine for the whole time. But for a couple of days, I am receiving below error when I run the reports "sometimes". Once I re-run it, the report works fine. The problem comes when the schedule reports are getting the same error and failed to run.

Any advice would be highly appreciated.

Cognos Error: XQE-GEN-0005 Found an internal error: DIVIDE BY ZERO

Error details from the cognos logs :

10.220.11.24:9300   4843   2020-08-26 07:30:02.235   -4   30CD2FC308458420AB2E7FFDE7F1EB6EB398841B33DBC1EAA5F5B431909AE5D6   h422dwlwssqsqwvwqCsj82q9vsqwCdwMyswls82C   2      Default Executor-thread-1511293   DISP   12   2   Audit.Other.dispatcher.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   Request         Failure   <messages><message><messageString>Client Error</messageString></message><message><messageString>XQE-GEN-0005 Found an internal error: divide by zero</messageString></message></messages>
   http://www.ibm.com/xmlns/prod/cognos/batchReportService/201703/.serverRSV-SRV-0042 Trace back:RSReportService.cpp(766): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(873): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW: RSRenderExecution::executeExecution/RSRenderExecution.cpp(831): XQEException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(766): XQEException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(809): XQEException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(881): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(989): XQEException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(168): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1190): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1188): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): 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



Thank you
Darshana

Hi,

From the looks of the error message you have a situation where divide by zero is occuring. I'm assuming this will come or go based on the data being included in the report, and whether there happens to be a row (or multiple rows) for which this is true. Take a look at the expressions in your report and focus on anywhere a division is being done. Change the expression to allow for zero in the denominator - most frequently done with an if-then-else.

Cheers!

MF.