Issue when creating custom approval procedure, DBScheduler job QER-K-PWODecisionRuleMakeProc throws error (186997)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Issue when creating custom approval procedure, DBScheduler job QER-K-PWODecisionRuleMakeProc throws error
Description

Issue when creating custom approval procedure, DBScheduler job QER-K-PWODecisionRuleMakeProc throws error resembling the message
50000 0 re-throw in Procedure QER_ZPWODecisionRuleMakeProc, Line 51 50000 0 re-throw in Procedure QBM_PSQLCreate, Line 26 207 0 detected in (SRV=172.20.1.23, DB=IM700) Procedure GEN_FTDB536350DC55CFEF0EE2BFCF, Line 3 207 0 Invalid column name 'UID_PWORulerOrigin'.
Cause

In 7.0, the DBScheduler task QER-K-PWODecisionRuleMakeProc compiles PWO approval workflows into stored procedures. The error indicates an invalid SQL statement within a custom approval procedure.
One possible error source is a migration. In version 6.1, the statement for approver calculation only had to return UID_Persons, whereas in version 7, approval procedure select statements need to return UID_Person, UID_PWORulerOrigin when they're used for ITShop approval workflows. If no UID_PWORulerOrigin is available, you can use NULL as second value.
Resolution

Check custom ITShop related PWODecisionRule (UsageArea=I) and their PWODecisionRuleRulerDetect.SQLQuery for SELECT statements not returning a second value.