PH41766: XQE-PLN-0020 THE V5 QUERY COULD NOT BE PLANNED BY THE QUERY SERVICE

APAR status

• Closed as fixed if next.

Error description

• When attempting to validate a report it gives error:
  
  RSV-VAL-0010 Failed to load the report specification.
  XQE-PLN-0020 The V5 Query could not be planned by the Query
  Service. The 'V5ValueExpression' node is invalid for the OLAP
  Transformation Library and the Query Service Planner is
  currently not able to resolve it.
  
  The issue is only replicatable with the following combination:
  a) DQM
  b) Gauge visualization
  c) calculated data item (using addition) against a count
  distinct varchar column
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.3                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels