PM07661: UPGRADING REPORT FROM 8.2 TO 8.4 FAILED WITH THE ERROR OP-ERR-0115

APAR status

• Closed as program error.

Error description

• A report that has been developed in IBM Cognos 8.2 is not
  upgradeable to IBM Cognos 8.4.
  
  They are getting the error message of:
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="40" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="293" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0046 Unable to support query items from the same
  dimension on different report dimensions:
  dimension="[MEASURES]"; edge="axis(0)"; edge="axis(1)".
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="340" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="411" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="40" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="53" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0046 Unable to support query items from the same
  dimension on different report dimensions:
  dimension="[MEASURES]"; edge="axis(0)"; edge="axis(1)".
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="100" is not the leaf on the first path.
  
  QE-DEF-0459 CCLException
  OP-ERR-0115 The dimensions on the edge are inconsistent. A
  dimension of valueSet="171" is not the leaf on the first path.
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0004 Unable to find query information for the item
  CYPYChange.
  
  RSV-VAL-0004 Unable to find query information for the item
  GPMargin.
  
  RSV-VAL-0004 Unable to find query information for the item
  GrossShipQty.
  
  RSV-VAL-0004 Unable to find query information for the item
  AdjustedGrossQty.
  
  RSV-VAL-0004 Unable to find query information for the item
  NetShipQty.
  
  RSV-VAL-0004 Unable to find query information for the item
  WeeklyForecastedUnits.
  
  RSV-VAL-0004 Unable to find query information for the item
  WeeklyForecastedUnits.
  
  RSV-VAL-0004 Unable to find query information for the item
  YTDCurrentMeasure.
  
  RSV-VAL-0004 Unable to find query information for the item
  PYTDCurrentMeasure.
  
  RSV-VAL-0004 Unable to find query information for the item
  YTDPriorYTDChange.
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0032 The following expression is not valid:
  if([Top10CustomerQuery].[NetShipQty] > 0)
  then ('up')
  else ('down'). If the item exists in a query but is not
  referenced in the layout, add it to a property list.
  CRX-API-0005 An error ocurred at or near the position '3'. The
  variable named '[Top10CustomerQuery].[NetShipQty]' is invalid.
  
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0004 Unable to find query information for the item
  CYPYChange.
  
  RSV-VAL-0004 Unable to find query information for the item
  GPMargin.
  
  RSV-VAL-0004 Unable to find query information for the item
  GrossShipDol.
  
  RSV-VAL-0004 Unable to find query information for the item
  AdjustedGrossDol.
  
  RSV-VAL-0004 Unable to find query information for the item
  NetShipDol.
  
  RSV-VAL-0004 Unable to find query information for the item
  WeeklyForecastedDollars.
  
  RSV-VAL-0004 Unable to find query information for the item
  WeeklyForecastedDollars.
  
  RSV-VAL-0004 Unable to find query information for the item
  YTDCurrentMeasure.
  
  RSV-VAL-0004 Unable to find query information for the item
  PYTDCurrentMeasure.
  
  RSV-VAL-0004 Unable to find query information for the item
  YTDPriorYTDChange.
  
  RSV-VAL-0044 The member caption can only be used in the scope of
  crosstab or chart.
  
  RSV-VAL-0032 The following expression is not valid:
  if([Top10CustomerQuery].[NetShipDol] > 0)
  then ('up')
  else ('down'). If the item exists in a query but is not
  referenced in the layout, add it to a property list.
  CRX-API-0005 An error ocurred at or near the position '3'. The
  variable named '[Top10CustomerQuery].[NetShipDol]' is invalid.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA10 PSN

     UP