IV27600: ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000

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

  • ORA-01795: maximum number of expressions in a list is 1000
    appears in logfile on cron servers.  The issue seems to occur
    because this client has more than 1000 scheduled reports.  The
    developers have confirmed that the error is thrown because the
    sql that is used in the code is utilizing a sql function (IN
    clause) that has a built in limit of 1000.  This is causing that
    particular sql to fail hence the messages in the log.  The code
    will need to be rewrittne to avoid this error.
    
    There is no functionality loss therefore this is only being
    submitted as a severity 2 apar. The sql error will only cause
    the
    servertimestamp update to fail, which causes the server to be
    "equal" in terms of who to run the crontask instead of giving
    the weight to the server who has previous run the crontask.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Fixed in code.                                               *
    ****************************************************************
    

Problem conclusion

  • Part of 7.1.1.12 Fix Pack.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV27600

  • Reported component name

    REPORTING

  • Reported component ID

    5724R46RP

  • Reported release

    711

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-06

  • Closed date

    2013-01-14

  • Last modified date

    2013-01-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    REPORTING

  • Fixed component ID

    5724R46RP

Applicable component levels

  • R711 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Report Admin

Software version:

711

Reference #:

IV27600

Modified date:

2013-01-14

Translate my page

Machine Translation

Content navigation