...
TROUBLESHOOTING: post-crawl emails and data_validation_audit entries: what to worry about, how to bypass or fix for a few…
...
| Info | ||
|---|---|---|
| ||
Once a problem is corrected, the next night’s successful crawler jobs will fix up the data. |
- The DATA_VALIDATION FINISH step MSG field in the CONTROLS_GLOBAL.DATA_VALIDATION_AUDIT table will show the list of errors found by the data validation proc:
- Log into Oracle on MCCQA as IRMISDB
- use TOAD or
- from the Linux command line:
- source /usr/local/lcls/epics/setup/oracleSetup.bash
- export TWO_TASK=MCCQA
- sqlplus irmisdb/`getPwd irmisdb`
- Log into Oracle on MCCQA as IRMISDB
...