PH44126: QUERY GENERATED FROM COGNOS CONTAINS WINDOW FUNCTIONS WHICH ARE NOT SUPPORTED FOR MYSQL 5.X

APAR status

• Closed as fixed if next.

Error description

• There is a difference in SQL generation from 11.1.7 and 11.2.1
  for MYSQL database version 5.x .
  For 11.1.7 there are no windows function in the query like
  'OVER' however in 11.2.1 we can see this keyword in the query
  which is not supported by MYSQL version 5.x . Therefor
  generating an error .
  

Local fix

• Works fine in MYSQL 8.x since these functions were introduce in
  version 8 and higer
  

Problem summary

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

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