QE-DEF-0459 CCLException

Product: Cognos BI 8.4.1

C8BISRVRRS_version=C8-AW32-ML-RTM-8.4.102.18-0
C8BISRVRRS_name=Cognos 8 Business Intelligence Server Application Tier

Symptom:

A error when you run a report on a transformer cube, that have worked before you upgrade Cognos BI to 8.4.1

Some reports work well and other give a error message.
If you validate the report in report Studio you get the error QE-DEF-0459 CCLException.

Error:

OP-ERR-0025

The following OLAPPlanner internal error occurred: OPASSERT(position < m_children.size()) in OPExpressionOperator::GetChild at OLAPPlannerExpression.cpp:4454

Cause:

Upgrade issue from 8.2 to 8.4 :
Negative sign in a expression such as “- ([data item1] – [data
item2])” in a crosstab report will cause an error message in 8.4
but it works in 8.2:
OP-ERR-0025 The following OLAPPlanner internal error occurred:
‘OPASSERT(position < m_children.size()) in
OPExpressionOperator::
GetChild at OLAPPlannerExpression.cpp:4445’.
The workaround is to use “0 – ([data item1] – [data item2])”

Solution:

Change the report to use “0 – ([data item1] – [data item2])” and save it again.