IBM Support What's New?

PM86385: EXCEPTION OCCURS WHEN RUNNING REPORT_LICENSE_TOTAL_DEVICE_CO

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A SqlSyntaxErrorException occurs when running the
    report_license_total_device_count.rptdesign BIRT report
    template.
    

Local fix

  • Changes were made to the template by the customer to avoid the
    error, but different changes were made by development to
    resolve the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Developers using BIRT reports with Derby or DB2 as their     *
    * database.                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When trying to run the BIRT reports for                      *
    * report_license_total_device_count with Derby as the          *
    * database, an error message is received on the "group by"     *
    * clause. Attempts to display the output may result in a       *
    * syntax error.                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The code was fixed so that the correct 'group by' SQL syntax is
    used.
    
    The fix for this APAR is currently targeted for inclusion in
    fixpack 5.0.6.1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM86385

  • Reported component name

    WORKLIGHT ENTER

  • Reported component ID

    5725I4300

  • Reported release

    506

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-04

  • Closed date

    2013-07-18

  • Last modified date

    2013-07-18

  • 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

  • R506 PSY

       UP



Document information

More support for: IBM Worklight

Software version: 506

Reference #: PM86385

Modified date: 2013-07-18