OP-ERR-0025 error after report migration to 8.4.1

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'.



Solution:

Change the report to use "0 - ([data item1] - [data item2])" and save it again.

 

www.cogknowhow.com