PM86385: EXCEPTION OCCURS WHEN RUNNING REPORT_LICENSE_TOTAL_DEVICE_CO

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Worklight

Software version:

5.0.6

Reference #:

PM86385

Modified date:

2013-07-18

Translate my page

Machine Translation

Content navigation