IV92377: DATA CONNECT JOBS WORKFLOWS HAVE BEEN FAILING AFTER SYSTEM IS CONVERTED FROM 3.5.1.2

APAR status

• Closed as documentation error.

Error description

• Data Connect Job workflows have been failing after system is
  converted from 3.5.1.2
  
  On the logs we see the following error message:
  
  2016-11-10 13:42:25,716 DEBUG
  [com.tririga.platform.workflow.runtime.taskhandler.DCTaskHandler
  ](WFA:0 - 27156646 SYSTEM DC PROCESS JOB:88095958 IE=88095958)
  DataConnectTaskHandler: create a new record
  SmartObjectId[ID=27156647,Business Object ID=10002541]
  2016-11-10 13:42:26,482 ERROR
  [com.tririga.platform.workflow.runtime.taskhandler.DCTaskHandler
  ](WFA:0 - 27156646 SYSTEM DC PROCESS JOB:88095958 IE=88095958)
  com.tririga.platform.smartobject.dataaccess.SmartObjectNotFoundE
  xception: No Smart Object with id '0' exists
  
  
  2016-11-09 13:34:57,677 ERROR
  [com.tririga.platform.workflow.runtime.taskhandler.WFTaskHandler
  Base](WFA:0 - 27228367 SYSTEM DC PROCESS JOB:88305471
  IE=88305471) Workflow task handler error while An error
  occurred while processing the staging records: Table Name =
  S_TRIPEOPLE, Job Number = 9000, CorelationId = 1, Sequence Id =
  110, Action Id = 2.   TaskStep: DataConnect(42)
  WFTID=44595065.4 TSID=267861 Label='cstDataConnect - triPeople'
  FormulaRecalc='Disable Auto Recalculation'
  EventAction='triActive' StepInstance:  WFIID=378551533739017
  SID=267861 UserEvent='FAILED' SO=-1 Results=0 Sum=0
  Status='ACTIVE'.  Cause:
  com.tririga.platform.workflow.runtime.exception.WFRuntimeExcepti
  on: Cannot find the record for the update. Keys did not find
  any record to update.[MID-1153093899]
  2016-11-09 13:34:57,677 ERROR
  [com.tririga.platform.workflow.runtime.taskhandler.DCTaskHandler
  ](WFA:0 - 27228367 SYSTEM DC PROCESS JOB:88305471 IE=88305471)
  com.tririga.platform.smartobject.dataaccess.SmartObjectNotFoundE
  xception: No Smart Object with id '0' exists
  2016-11-09 13:34:57,677 DEBUG
  [com.tririga.platform.workflow.runtime.taskhandler.DCTaskHandler
  ](WFA:0 - 27228367 SYSTEM DC PROCESS JOB:88305471 IE=88305471)
  DataConnectTaskHandler:  TaskStep: DataConnect(42)
  WFTID=44595065.4 TSID=267861 Label='cstDataConnect - triPeople'
  FormulaRecalc='Disable Auto Recalculation'
  EventAction='triActive' StepInstance:  WFIID=378551533739017
  SID=267861 UserEvent='FAILED' SO=-1 Results=0 Sum=0
  Status='ACTIVE' iteration=110
  

Local fix

• N/A
  

Problem summary

• User_ID row in the topic DC_JOB table fields will be made clear
  

Problem conclusion

• A value for the user_id needs to exist in the dc_job table.
  

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:

Fix information

Applicable component levels