IBM Support

IV87104: EXTENDED FORMULA QUEUE ISSUE WITH TRISTATUSCL ON TRIPAYMENTLINEITEM

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • The triStatusCL field on a triPaymentLineItem is taking an
    extremely long time to process when formulas are recalculated.
    This causes the Extended Formula Queue to become backed up, and
    take an very long time to process other records.
    

Local fix

  • NA
    

Problem summary

  • The extended formula for 2 fields on the payment line items
    are removed. This was causing issues in performance when a long
    term lease is activated. This formula were being used in older
    approach of Straight line calculations which utilized values
    from payment line item. Today the straight line calculations are
     done through use of Fiscal line items.
    Additionally workflow that created payment line item the
    Formulas property in workflow task is set to Disable Auto
    Recalculation. This issue will be resolved in our next major
    release version, which is tentatively planned for 2H 2016.
    

Problem conclusion

  • Revise the triPaymentLine BO, and remove the extended formula
    on the fields:  triStatusCL field on a triPaymentLineItem.
    These extended formulas are being used for version 9.x approach
    of Straight line calculations. The Straight line calculations
    no longer use Payments in 10.x apps and instead depends on
    Fiscal line items.
    Note: if your queue is full, stop the EF  Agent, and run the
    following sql:
    delete from ef_queue where spec_template_id in (10003142,
    10004638,
    10008254,
    10008256,
    10016266,
    10030594)
    Then restart the EF Agent.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV87104

  • Reported component name

    TRIRIGA RE MANA

  • Reported component ID

    5725F25RM

  • Reported release

    A41

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-20

  • Closed date

    2016-08-08

  • Last modified date

    2017-10-25

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

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

Fix information

Applicable component levels



Document information

More support for: IBM TRIRIGA Real Estate Manager
IBM TRIRIGA Real Estate Manager

Software version: A41

Reference #: IV87104

Modified date: 25 October 2017