CMS Application - Execute - Fatal Error - Failed to run ADG_COMPUTE_DELTA_SNAPSHOTS

This page describes the solution for the following Error which occurs while uploading results to the measurement base:

Failed to run ADG_COMPUTE_DELTA_SNAPSHOTS (ERROR: more than one row returned by a subquery used as an expression
Where: SQL statement "Update ADG_DELTA_SNAPSHOTS dd set PREV_SNAPSHOT_ID = (......)
PL/pgSQL function adg_compute_delta_snapshots(integer) line 43 at SQL statement)

This error often comes when two or more snapshots coming from different centrals have the same functional date.
When the update query is executed the sub-query fetches more the one row with the same functional date of snapshot as a result the upload fails.
To avoid such situation, we need to check for the central bases with the snapshots on the central and update them to have a unique functional date.

Apply the below the steps to unblock this situation and overcome the error:
1 - In CMS, at the central database service (snapshots tab), check that all functional dates are in the correct order, change the snapshot dates if needed (if they are duplicated)
2 - In CMS, 'Consolidate' each snapshots of the Central Service.
3 - In CMS, 'Upload Snapshot to Measurement Service' for each snapshots of the Central Service.