IBM Support

IV93295: WORKFLOW THROWS GUI INSTANCE UNIQUE CONSTRAINT ERRORS WHEN MULTIPLE MODIFY META DATA TASKS UPDATE A RECORD.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Customer has seen that sometimes when modifying metadata task
    has a unique constraint error on PK_GUI_INSTANCE recorded in
    the log, this causes the WF instance to be saved and creates a
    performance impact.
    

Local fix

  • No
    

Problem summary

  • When the Platform sends in a whole batch of SQL statements, if
    a primary key exception happens upon insertion, we need to try
    the batch over again, one at a time, and catch the dup key to
    make sure all the data is saved.  We only care that the rest of
    the batch is saved.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV93295

  • Reported component name

    TRI APPLCATION

  • Reported component ID

    5725F26AB

  • Reported release

    351

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-10

  • Closed date

    2017-02-14

  • Last modified date

    2017-02-14

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

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

Modules/Macros

  • 999
    

Fix information

Applicable component levels

  • R352 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"351","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
30 March 2022