Is there orphan data on VC

If any of these return null then you have orphan data and need to implement KB 2058670

select sample_time as mim_sample1 from vpx_sample_time1 where time_id = (select min(time_id) from vpx_sample_time1);
select sample_time as max_sample1 from vpx_sample_time1 where time_id = (select max(time_id) from vpx_sample_time1);
select sample_time as min_hist1 from vpx_sample_time1 where time_id = (select min(time_id) from vpx_hist_stat1);
select sample_time as max_hist1 from vpx_sample_time1 where time_id = (select max(time_id) from vpx_hist_stat1);

select sample_time as min_sample2 from vpx_sample_time2 where time_id = (select min(time_id) from vpx_sample_time2);
select sample_time as max_sample2 from vpx_sample_time2 where time_id = (select max(time_id) from vpx_sample_time2);
select sample_time as min_hist2 from vpx_sample_time2 where time_id = (select min(time_id) from vpx_hist_stat2);
select sample_time as max_hist2 from vpx_sample_time2 where time_id = (select max(time_id) from vpx_hist_stat2);

select sample_time as min_sample3 from vpx_sample_time3 where time_id = (select min(time_id) from vpx_sample_time3);
select sample_time as max_sample3 from vpx_sample_time3 where time_id = (select max(time_id) from vpx_sample_time3);
select sample_time as min_hist3 from vpx_sample_time3 where time_id = (select min(time_id) from vpx_hist_stat3);
select sample_time as max_hist3 from vpx_sample_time3 where time_id = (select max(time_id) from vpx_hist_stat3);

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s