Operation "Procedures for creating approval methods" stuck in DBQueue, shown as IsReset=1

Hello,

We are using version 9.0 LTS and getting below error in system journal.

(execute slot single)50000 0 re-throw in Procedure QER_ZPWODecisionRuleMakeProc, Line 10850000 0 re-throw in Procedure QBM_PSQLCreate, Line 2750000 0 re-throw in Procedure QBM_PExecuteSQLWithRetry_LLP, Line 2150000 0 re-throw in Procedure QBM_PExecuteSQLWithRetry_LLP, Line 13207 0 detected in (SRV=NPWIESEFRDB01, DB=SHVEUATDB) Procedure GEN_FT43F7ADB15A096F39CAFB9574, Line 14207 0 Invalid column name 'UID_PWORulerOrigin'.

0 Troy Grandy 5 months ago

Sounds like you have a custom PWO approval created and that it is a calculated decision that requires some tweaking.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 ruchita.mantri 5 months ago in reply to Troy Grandy

We have 22 custom approval procedures created and around 50 custom approval workflows. Please suggest what I should look for when I check this?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers 5 months ago in reply to ruchita.mantri

To resolve the error: "Invalid column name 'UID_PWORulerOrigin'", ensure that "UID_PWORulerOrigin" is returned as a column. For example, using the above SQL, and adding "null as UID_PWORulerOrigin" will resolve the error.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel