PH52149: XQE-DAT-0001 EXPRESSION #6 OF SELECT LIST IS NOT IN GROUP BY CLAUSE AND CONTAINS NONAGGREGATED COLUMN

APAR status

• Closed as fixed if next.

Error description

• XQE-DAT-0001 Data source adapter error:
  java.sql.SQLSyntaxErrorException: Expression #6 of SELECT list
  is not in GROUP BY clause and contains nonaggregated column
  'sakila.film_category.TimezoneInt' which is not functionally
  dependent on columns in GROUP BY clause; this is incompatible
  with sql_mode=only_full_group_by
  

Local fix

Problem summary

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

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