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.