IBM Support

PI22669: Unable to redefine Query limits for reports with Block Reports

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Reports created using block reports has a hard coded limit of
    100 CRs when pagination is disabled.
    
    Select Queries from the action dialog and define a query that is
    known to return over 100 CRs.
    
    From the Select a Format section of the screen, select New.
    
    Disable pagination
    
    Then select the 'Block Relationships', Select the tab '+', add
    Associated IR(s), then select the '+' again and select
    Associated SCR(s).
    
    Select Run and query fails with the error:
    
    CRCHG07801 The query limit of 100 was exceeded for this report
    format. The query found xxxxxx results. To fix this problem,
    refine your query, select a new report format, or contact your
    administrator to change the query limit for the report.
    
    It is not possible for the administrator to the change the query
    limit.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Unable to redefine Query limits for reports with Block
    Reports
    

Problem conclusion

  • The fix is available in 5.3.0.6 ifix 003.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI22669

  • Reported component name

    TLOGIC CHANGE

  • Reported component ID

    5724V87CG

  • Reported release

    530

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-24

  • Closed date

    2014-12-17

  • Last modified date

    2014-12-17

  • 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

    TLOGIC CHANGE

  • Fixed component ID

    5724V87CG

Applicable component levels

  • R530 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSYQQ2","label":"Rational Change"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 December 2014