Problem Summary:
2019-11-08T10:03:03-05:00: hvrstats: F_JT0723: Select from 'hvr_stats' returned a value for metric 'Captured Changes Backdated', channel 'ora2sql', location '*' and table 'acct' with timestamp
'2019-11-03T00:01:00-04:00' which is bigger than expected. F_JT0716: The previous error occurred while processing rows from 'hvr_stats' to aggregate the data. Last processed row was: hist_time_gran= 1, hist_time= 1572753660, chn_name= 'ora2sql', loc_name= '*', tbl_name= 'acct', metric_name= 'Captured Changes Backdated', metric_value= '22'
Workaround
We have a defect HVR-8724 that development is working on for this issue in HVR 5.6
You can workaround this error by turning it into a warning. Here is how:
1. In the HVR GUI, click on the 'View' menu at the top, select 'Attributes' and check 'Show Environment Attributes';
2. From the same 'View' menu, select 'Stats Job' and check 'Show';
3. Right click on the '{hvrstats}' job beneath the scheduler and select 'New Attribute...';
4. Select 'set' from the 'Attrubute Name' list (it's at the very bottom);
5. For 'Variable', enter HVR_THROW_WARN;
6. For 'Value', enter *F_JT0723*;
7. Re-Initialize, Scripts & Jobs