Troubleshooting errors when changing Sign Off state
When changing SignOff state in a way that should normally be allowed, you might see an error message like:
|
An error occurred during the Set As [signoff state] workflow e.g. An error occurred during the Set As Completed workflow |
Or:
|
Error: You cannot edit this [record type] because it is [signoff state] e.g. Error: You cannot edit this Test because it is Completed |
Or:
|
You cannot add this Approval Sign Off because the parent [record type] has no [signoff state] e.g. You cannot add this Approval Sign Off because the parent Step has no Completion |
Or:
|
Sign Off: A value must be set for one of the parent links |
These errors occur because the current Sign Off state does not match the rest of the sign off data in the row. For example, if the row contains a Completion, but the SignOffState is set to Open.
Identifying the problem data
Run the diagnostic script 'Ideagen Internal Audit (Aura) - SignOff_integrity_check v2.sql'. It runs across each table that might be affected and compares the SignOffStateID with the signoff-related columns in the row.
If faulty rows are shown, then Ideagen Support will need to prepare a custom fix script to run against the database.
Root cause and further investigation
This issue can appear as a result of a temporary problem with the main service.
The issue is cleared after a restart of the service’s application pool, but there may be additional issues that need investigating – more information here: Sign Off state cannot be changed.