Fixes are available
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 number
PI12226
Reported component name
WORKLIGHT ENTER
Reported component ID
5725I4300
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-02-24
Closed date
2014-04-02
Last modified date
2014-04-02
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZH4A","label":"IBM Worklight"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"600","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 October 2021