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

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 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