XQE-GEN-0005 error

[NewGuy1983]

Hello,

I'm working in Cognos analytics and working on a report that was developed in 10.2. I have an if statment like below.


maximum(if ('column1' = 'column2') then ('column3') else (0))    --column names are made up


I get the below error because of the maximum. Can someone please tell my why?


XQE-GEN-0005 Found an internal error:
com.cognos.xqe.ast.sql.SQLValueExpression incompatible with com.cognos.xqe.ast.sql.SQLFid
RSV-SRV-0042 Trace back:
RSReportService.cpp(766): XQEException: CCL_CAUGHT: RSReportService::processImpl()
RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request
RSASyncExecutionThread.cpp(873): XQEException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_Request
RSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request
Execution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW: RSRenderExecution::execute
Assembly/RSDocAssemblyDispatch.cpp(346): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(455): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(455): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW: RSAssembly::createListIterator
Assembly/RSAssembly.cpp(766): XQEException: CCL_RETHROW: RSAssembly::createListIterator
RSQueryMgr.cpp(809): XQEException: CCL_RETHROW: RSQueryMgr::getListIterator
RSQueryMgr.cpp(881): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIterator
RSQueryMgr.cpp(989): XQEException: CCL_RETHROW: RSQueryMgr::createIterator
RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand
RSQueryMgrExecutionHandlerImpl.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::Execute
QFSQuery.cpp(311): XQEException: CCL_RETHROW: QFSQuery::Execute v2
XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send

[cognostechie]

Try using a case statement

[NewGuy1983]

Sorry I'm new to cognos. I missed the full expression.

maximum(if ('column1' = 'column2') then ('column3') else (null) for 'col4', 'col5')