-
Title
Attestation cases are not being generated -
Description
When attempting to generate attestation cases, none of the cases get created. When viewing the dialog journal the following log line is displayed:
"(execute slot bulk)50000 0 re-throw in Procedure ATT_ZAttestationHelperFill_Cfg, Line 1150000 0 re-throw in Procedure ATT_PAttestationHelperFill, Line 125547 0 detected in (SRV=SQLSERVER, DB=1IM) Procedure ATT_PAttestationHelperFill, Line 105547 0 The INSERT statement conflicted with the FOREIGN KEY constraint "ATT_RFRL302". The conflict occurred in database "1IM", table "dbo.PersonWantsOrg", column 'UID_PersonWantsOrg'." -
Cause
The attestation approval procedure has incorrect code. -
Resolution
Follow the steps below to correct the non functioning attestation approval procedure:
1. Open Manager.
2. Click on the "Attestation" menu.
3. Expand "Basic configuration data".
4. Click on "Approval procedures".
5. Click on the Approval procedure in question.
6. Under "Tasks" click on "Change queries for approver selection".
7. Navigate to the Query window.
8. Look for UID_PWORulerOrigin = ‘’
9. Change this to UID_PWORulerOrigin = NULL
10. Save the changes.