PI08524: EXECUTING A REPORT THAT CONTAINS AN ANALYTICAL FUNCTION "PARTITION BY" ON NETEZZA THROWS ERROR XQE-DAT-0001

APAR status

• Closed as program error.

Error description

• When using a Cognos relational package using Dynamic Query Mode
  (DQM), and executing a XTAB report, the SQL generated by Cognos
  causes an error. The same error occurs if executed directly on
  Netezza. ??Cognos error: XQE-DAT-0001 Data Source Adapter error
  NzSQLException: ERROR: 121814: Partition rowcount limit
  exceeded??Netezza error: 121814 Partition rowcount limit
  exceeded
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Fix Pack 2  *
  * or upgrade to IBM Cognos Business Intelligence 10.2.1 Fix    *
  * Pack 3                                                       *
  ****************************************************************
  

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

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA20 PSN

     UP