CMS Snapshot Analysis - Upload Snapshot to measurement base - Fatal Error - The program AAD consolidation tool has not ended correctly Error code 1

This page troubleshoots problem when there is a Fatal Error - The program AAD consolidation tool has not ended correctly

Step by Step scenario

1. Compute Snapshot

Perform the below actions

1. Find the actual error.
   This is a general error on the GUI , open the AddCli-yyyymmddhhmmss.TXT log file to get the actual error -
   
   
   

   1. If the error message is as shown below

      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
                         set PREV_TEXT_DATE = (select s.TEXT_DATE from ADG_DELTA_SNAPSHOTS s
                                        where s.APPLICATION_ID = ADG_DELTA_SNAPSHOTS.APPLICATION_ID
                                          and s.SNAPSHOT_ID = ADG_DELTA_SNAPSHOTS.PREV_SNAPSHOT_ID
                                       )"
      PL/pgSQL function adg_compute_delta_snapshots(integer) line 56 at SQL statement)
      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
                         set PREV_TEXT_DATE = (select s.TEXT_DATE from ADG_DELTA_SNAPSHOTS s
                                        where s.APPLICATION_ID = ADG_DELTA_SNAPSHOTS.APPLICATION_ID
                                          and s.SNAPSHOT_ID = ADG_DELTA_SNAPSHOTS.PREV_SNAPSHOT_ID
                                       )"
      PL/pgSQL function adg_compute_delta_snapshots(integer) line 56 at SQL statement)

      then apply the below workaround -

      1. Perform a full reset of the measurement database by referring to the following page - CAST-AAD - Using the GUI and CLI tools
      2. Upload the snapshots again to Measurement database by referring to the following page    CMS - Dashboard Service editor Upload snapshot to Measurement Service
   2. If the error message is not the same then contact CAST Technical Support. with the following Relevant input
2. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input 

Ticket # 11666