Issue:
When refreshing a Data Validation, an error message appears: “There was an error refreshing the results. Please try again.”

Environment:

• Data Validation Results page
• SQL Database

Cause:
The Data Validation process may get stuck or time out

Resolution:
Manually refresh the Data Validation in SQL using the following query:

SELECT * FROM DPT WHERE NM LIKE 'DATAVALIDATION_GUID_REFRESH%'  AND CD <> ''
UPDATE DPT SET CD = '' WHERE NM LIKE 'DATAVALIDATION_GUID_REFRESH%'  AND CD <> ''