Siebel SQLs/Error Messages >  Error in the log: "Source Column Id is null in LoadLink"

WF Monitor Agent - Error SBL-ESC-00053: Error Loading Rule Definitions > Error in the log: "Source Column Id is null in LoadLink"

APPLIES TO:
Siebel Automotive - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
SYMPTOMS
On : 8.1.1.11 [IP2013] version, Siebel Workflow

When attempting to run workflow monitor agent to capture wf policy records in violation that were triggered and inserted into S_ESCL_REQ,
the following error occurs.

ERROR
-----------------------
SBL-ESC-00053: Error loading rule definitions

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a wf policy and associate a custom wf policy group
2. Create a custom workmon component and associate to the same wf policy group
3. Run Generate Database Trigger to make records in violation to be inserted into S_ESCL_REQ.
4. Violate the wf policy condition
5. Monitor the custom workmon component to check the error.

CAUSE
Found that some join references are empty in wf policy component object:

From A1.zip screen shots:

Workflow Policy Column:
GMC Case Id > S_CASE_POSTN.CASE_ID
GMC Position Id > S_CASE_POSTN.POSTN_ID

Workflow Policy Component:

Name: GMC Case Position
Source Table Name: S_CASE_POSTN
Source Column Name:
Target Component Name:
Target Column Name:

Source Column Name:POSTN_ID
Target Component Name: Position
Target Column Name: ROW_ID

The error from the logs seems to refer to the empty reference for the Source Column Name in Workflow Policy Component:

Name: GMC Case Position
Source Table Name: S_CASE_POSTN
Source Column Name:
Target Component Name:
Target Column Name:

SOLUTION
The problem is on the configuration of the Workflow Policy Component created:

Workflow Policy Component:

Name: GMC Case Position
Source Table Name: S_CASE_POSTN
Source Column Name:
Target Component Name:
Target Column Name:

The error that we were trying to troubleshoot is referring to these settings:

Source Column Id is null in LoadLink

Asked customer to review and compare how these 3 fields were being populated on other(s) workflow policy components.

Suggested customer to set these fields as follows:

Source Column Name: POSTN_ID
Target Component Name: Position
Target Column Name: ROW_ID

After these changes the error "Source Column Id is null in LoadLink" does not appear in the log.