Health Dashboard - Run Consolidation - GUI - Error - Failed to run ADG COMPUTE DELTA SNAPSHOTS

Description

This page gives solution to below error during HD consolidation which causes the consolidation to fail :

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 FIRST_SNAPSHOT_ID = (select s.SNAPSHOT_ID
from ADG_DELTA_SNAPSHOTS s
where s.APPLICATION_ID = ADG_DELTA_SNAPSHOTS.APPLICATION_ID
and s.TEXT_DATE = ADG_DELTA_SNAPSHOTS.FIRST_TEXT_DATE)”

PL/pgSQL function adg_compute_delta_snapshots(integer) line 99 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 FIRST_SNAPSHOT_ID = (select s.SNAPSHOT_ID
from ADG_DELTA_SNAPSHOTS s
where s.APPLICATION_ID = ADG_DELTA_SNAPSHOTS.APPLICATION_ID
and s.TEXT_DATE = ADG_DELTA_SNAPSHOTS.FIRST_TEXT_DATE)”

PL/pgSQL function adg_compute_delta_snapshots(integer) line 99 at SQL statement)

Done!

Error: 1

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

1. Use the GUI / CLI for consolidation of Central into measurement base
2. Consolidation fails with error Failed to run ADG_COMPUTE_DELTA_SNAPSHOTS

Action Plan

This error occurs during consolidation in measurement database, when some snapshots with the same functional date have disappeared in the central database but still exists in the measurement base.

1. Do a full-reset of the measurement base and do a re-consolidation of all the Central Bases.

Detailed steps to follow the work around is given in this page -Health Dashboard - Run Consolidation - GUI - Error - more than one row returned by a subquery used as an expression.

Impact on Analysis Results and Dashboard

Analysis - N/A Dashboard - N/A

Notes/comments

This is a known bug which has been fixed in 7.2.5

Related Pages