What does the table UnresolvedJobRunCausedBy contain and what its purpose?
Product: Automation Analytics & Intelligence v6.5, v24.x
N/A
The table is used to handle the event out-of-order issue. For instance, JobB's run depends on the success of the JobA, so JobB events indicate that its predecessor job run (or called causeBy) is the JobA run. However, for some reason, JobA run doesn't exist in the AAI system. So, AAI cache that information in the UnresolvedJobRunCauseBy table. When a later Jammer run receives the JobA run's information, AAI use the information and then drop the row from that table.