PI12226: EXCEPTION ORA-00979 MAY OCCUR WHEN RUNNING THE "REPORT_LICENSE_TOTAL_DEVICE_COUNT" BIRT REPORT

Download for IBM Worklight V6.1.0 Fix Pack 2
IBM Worklight Interim Fix README for 6.0.0.2

APAR status

• Closed as program error.

Error description

• The following error may occur when running the
  "report_license_total_device_count" BIRT report using Derby or
  DB2 as database:
  java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY
  expression
  

Local fix

• In the report_license_total_device_count.rptdesign file please
  replace these 3 lines:
  
  FACT_ACTIVITIES.APP_NAME,
  FACT_ACTIVITIES.ACTIVITY_DATE,
  FACT_ACTIVITIES.TOTAL_ACTIVITY
  
  with these 3 lines:
  
  MAX(FACT_ACTIVITIES.APP_NAME) AS APP_NAME,
  MAX(FACT_ACTIVITIES.ACTIVITY_DATE) AS ACTIVITY_DATE,
  MAX(FACT_ACTIVITIES.TOTAL_ACTIVITY) AS TOTAL_ACTIVITY
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Administrators of a Worklight server who use DB2 or Derby as *
  * a repository                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An incorrect statement was included in the                   *
  * report_license_total_device_count.rptdesign report template  *
  * that causes DB2 and Derby repositories to fail executing the *
  * report.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * -                                                            *
  ****************************************************************
  

Problem conclusion

• In the report_license_total_device_count.rptdesign file the
  following lines:
  
  FACT_ACTIVITIES.APP_NAME,
  FACT_ACTIVITIES.ACTIVITY_DATE,
  FACT_ACTIVITIES.TOTAL_ACTIVITY
  
  were replaced with:
  
  MAX(FACT_ACTIVITIES.APP_NAME) AS APP_NAME,
  MAX(FACT_ACTIVITIES.ACTIVITY_DATE) AS ACTIVITY_DATE,
  MAX(FACT_ACTIVITIES.TOTAL_ACTIVITY) AS TOTAL_ACTIVITY
  
  Doing this allows DB2 and Derby databases to execute the
  intended output of the report.
  

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

  WORKLIGHT ENTER

• Fixed component ID

  5725I4300

Applicable component levels

• R600 PSY

     UP

• R610 PSY

     UP