-
Titolo
Following an upgrade, ITShop approvals fails due to missing approvers -
Descrizione
In Identity Manager, the ITShop approvals processes were working before applying an upgrade. This has been observed upgrading from 9.0 to 9.2.x
A minor version upgrade was installed, and subsequently the ITShop approvals stopped working. The error message is displayed as "no approver available", even though the configuration was working prior to the upgrade and has not been changed.
-
Causa
During an upgrade, the functions to re-create the approvers should be re-generated.
It is possible that these could fail to run correctly in certain circumstances.
The following SQL Query will demonstrate if there are any missing "DecusionRule" entries:
SELECT
DecisionRule,
dbo.QER_FCVRuleGUIDToFunctionName(uid_PWODecisionRule) as 'Expected function',
ISNULL(f.name, '************* function missing *************') as 'Existing function'
FROM PWODecisionRule
LEFT OUTER JOIN sys.objects f ON dbo.QER_FCVRuleGUIDToFunctionName(uid_PWODecisionRule) = f.name
ORDER BY DecisionRule
-
Risoluzione
The following SQL Command will call a built-in function to re-create the missing DecisionRule entries if any are found in the script provided in the cause section.
DECLARE @GenProcID varchar(38) = newid()
EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-PWODecisionRuleMakeProc', '', @GenProcID