PH49662: RUNNING TWO REPORTS CONSECUTIVELY, SECOND REPORT USING _ROUND() WILL ERROR XQE-CON-0007

APAR status

• Closed as fixed if next.

Error description

• Running two reports consecutively, second report will display
  error message XQE-CON-0007 XQE error encountered: XTR-ERR-0006
  MDX execution failed with response code: "400". Reason:
  "{"code":"501","message":"Syntax error at or near:
  '([m_retail].[m_retail].[m_W^Achievement  ... ', character
  position 71"}". The issue only happens when the _round()
  function is used in the expression for one of the data items.
  Additionally, it is not seen if the second report is run by
  itself, after restarting QueryService.
  

Local fix

Problem summary

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

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