Siebel 8.1 weird WF validation error
We got the below error message while validating a workflow in Siebel 8.1
Validation failed for the workflow process 'XYZ' for the branch 'Connector 33' The 'WF Branch Criteria Value' - field such as LO_.. or HI_.. for the respective data type is null or empty.
Solution:
Run the sql below with the source as workflow row id, you will see all the branch conditions in your workflow. Pick the one which has the same name as the error message, isolate the wf step (you can modify this sql to get that) and then delete and re-add the condition step.
SELECT WFBRANCRIT.ROW_ID, WFBRANCRIT.NAME, WFBRANCRIT.BRANCH_ID
FROM SIEBEL.S_WFR_PROC WF, SIEBEL.S_WFR_STP WFSTEP, SIEBEL.S_WFR_STP_BRNCH WFSTPBRANCH, SIEBEL.S_WFR_PROC_FLOW WFSTEPCON, SIEBEL.S_WFR_COND_CRIT WFBRANCRIT
WHERE WF.ROW_ID = WFSTEP.PROCESS_ID (+)
AND WFSTEP.ROW_ID = WFSTPBRANCH.STEP_ID (+)
AND WFSTPBRANCH.ROW_ID = WFSTEPCON.FOR_BRNCH_ID (+)
AND WFSTPBRANCH.ROW_ID = WFBRANCRIT.BRANCH_ID (+)
Comments
Upgrade Siebel version, Re-Import the workflow, Publish/Validate the workflow.
In our environment 8.1.1.7, we upgrade from 8.1.1.1 to 8.1.1.7 so we had to apply ACR's in order to patch it. But during WF activation it send that weird error..
I used your query to find out which branches were wrong and I note that WFBRANCRIT.NAME column had duplicated values. So I updated column with different name and then Activation ran succefull.
Regards!
Packers and Movers in Chennai@ http://packersservice.com/packers-and-movers-chennai/
Packers and Moversin Bangalore@ http://packersservice.com/packers-and-movers-bangalore/
http://packersservice.com/packers-and-movers-hyderabad/