IBM Support

IV87030: TRIRIGA EXTENDED FORMULAS - EF_QUEUE TABLE GROWING AND NOT PROCESSESING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Extended Formula Agent stopped processing queue.
    

Local fix

  • NA
    

Problem summary

  • Limit the rows in EF_QUEUE to reset AGENT_ID to -1 to only rows
    that have existing valid agent_id value during server startup.
    The agent_id only gets populated with the id of the ef agent
    that picked it for processing, for whatever reason the row may
    not have completed its process but the server has already
    shutdown, thus, having rows flagged with non-existing ef agent
    .  In order for the EF agent to continue processing these rows,
    their agent_id need to be reset to -1 so the next time the
    agent awakes it will be picked up for processing.  Refactor
    existing code so it can be more junit tested, and is using Sql
    code instead of direct database connection.
    

Problem conclusion

  • Application server will now start up even if there are large
    amount of rows in the Extended Formula Queue. This is targeted
    to the 2h2016 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV87030

  • Reported component name

    TRI APP PLTFM R

  • Reported component ID

    5725F26RE

  • Reported release

    341

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-18

  • Closed date

    2016-07-28

  • Last modified date

    2016-07-28

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

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

Modules/Macros

  •    None
    999
    

Fix information

Applicable component levels



Document information

More support for: IBM TRIRIGA Application Platform
IBM TRIRIGA Application Platform Runtime Engine

Software version: 341

Reference #: IV87030

Modified date: 28 July 2016