IBM Support

IV97814: T_TRITASKRESOURCEFACT TABLE - TIRTASKRESOURCEFACT BO HAS CHANGED AND THE TRIDIMTASKSTATUSTX FIELD IS NO LONGER A L

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When running ETL JOB in IBM TRIRIIGA 3.5.2 we see the following
    error:
    
    ERROR
    [com.tririga.platform.workflow.runtime.taskhandler.ETL.KETTLE](t
    riTaskResourceFactETL - Insert into triTaskResourceFact) Insert
    into triTaskResourceFact -
    org.pentaho.di.core.exception.KettleException:
    Error inserting row into table [T_TRITASKRESOURCEFACT] with
    values: ...
    Error inserting/updating row
    ORA-00904: "TRIDIMTASKSTATUSTXOBJID
    
    This happens because T_triTaskResourceFact table -
    tirTaskResourceFact BO has changed and the triDimTaskStatusTX
    field is no longer a locator.
    

Local fix

  • N/A
    

Problem summary

  • Status Dimension data not populating for task resource metric
    table, the following changes need to be madeto populate
    correctly.
    Revise triTastResourceFact BO:
    1. created association between fact and triStatus classification
    2. set locator to Name field of the status BO.
    

Problem conclusion

  • Status Dimension data not populating for task resource metric
    table, changes make to populate correctly.
    This is targeted to the 1h2017 Applicaiton/OM release
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV97814

  • Reported component name

    TRI APP PLTFM R

  • Reported component ID

    5725F26RE

  • Reported release

    352

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-06

  • Closed date

    2017-07-10

  • Last modified date

    2017-07-10

  • 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



Document information

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

Software version: 352

Reference #: IV97814

Modified date: 10 July 2017