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
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
- Use the GUI / CLI for consolidation of Central into measurement base
- Consolidation fails with error Failed to run ADG_COMPUTE_DELTA_SNAPSHOTS
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.
- 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.
Analysis - N/A Dashboard - N/A
This is a known bug which has been fixed in 7.2.5