Other: compare report enhancement
Planned
THis is regarding compare jobs report. We want to have an enhancement in HVR to get a report for 1)OOS rows,2) Failed jobs and 3)Jobs didn't run.
Am attaching an example mail we get for VERIDATA report in goldengate environment,for reference.
-
Official comment
Hi There,
Thank you for your suggestion. I will put this on the backlog.
The first change that we will be making is including compare results in the alert system. We plan to release this later this calendar year (in HVR 6 only). Following that I'd like to get your input to see what you think.
Thanks,
Mark. -
Just providing the sample report we get from VERIDATA,in goldengate environment.
We get 3 different subject lines. 1)OOS rows 2)Failed jobs 3)Jobs didn't run.
OOS ROWS
JNAME GNAME TABLE_NAME COMP_ROWS OOS_ROWS STOP_DATE
---------------------------------------- ---------------------------------------- ------------------------- ---------- -------- -------------------------
SHR_TNP_WEBCONTENT_ORP406A_INCR SHR_TNP_WEBCONTENT_ORP406A_INCR BLURBS 6,890 3 12-APR-24 06.03.04.54 AM
WLN_COBALT_UDS_NEW_NEW_INCR WLN_COBALT_UDS_NEW_NEW_INCR CO_SESSION 4,959,450 17 12-APR-24 07.29.42.10 AM
WLN_HIST24_31_cdp0345a1_INCR WLN_HIST25_cdp0345a1_INCR HISTORY_EVENT 265,906 1 12-APR-24 09.23.58.38 AM
" ALL DML for OOS ROWS are stored on c774vkzverprd:/veridata/LEGAL/scripts/VDC/tmp/oos/*.sql , if no files generated, all OOS are IN-FLIGHT"
FAILED JOBS
JNAME GNAME FAILED_DATE ERRORS
---------------------------------------- ---------------------------------------- ------------------------- ------
WLN_HIST16_23_cdp0345a1_INCR WLN_HIST23_cdp0345a1_INCR 12-APR-24 07.39.11.37 AM 1
NO OOS ROWS
JOB DID NOT RUN TODAY
*********************
"JOB RUN TODAY SUCCESSFULLY "
WLN_HIST8_15_cdp0345a1_INCR 12-APR-24 09.19.25.66 AM
WLN_HIST16_23_cdp0345a1_INCR 12-APR-24 09.19.14.97 AM
WLN_PREFERENCE_ORP724A_INCR 12-APR-24 09.13.41.27 AM
WLN_HIST0_7_cdp0345a1_INCR 12-APR-24 07.44.58.03 AM
WLN_COBALT_UDS_BILLING_NEW_cdp0373a1_INC 12-APR-24 07.28.54.24 AM R
WLN_COBALT_UDS_USERINFO_NEW_NEW_INCR 12-APR-24 07.25.43.43 AM
MONITOR_SUITE_HARBOR_DBA_ORP435A_FULL 12-APR-24 07.04.03.26 AM
SHR_COBALT_UDS_ORP345A_INCR 12-APR-24 06.48.10.77 AM
SHR_COBALT_UDS_BILLING_ORP345A_INCR 12-APR-24 06.47.25.66 AM
SHR_COBALT_UDS_USERINFO_ORP345A_INCR 12-APR-24 06.45.22.77 AM
SHR_HIST9_17_ORP343A_INCR 12-APR-24 06.33.35.18 AM
SHR_HIST18_26_ORP343A_INCR 12-APR-24 06.31.14.77 AM
SHR_HIST27_31_ORP343A_INCR 12-APR-24 06.31.12.81 AM
SHR_HIST0_8_ORP343A_INCR 12-APR-24 06.30.48.71 AM
WLN_DOC_PERSIST_cdp0338a1_INCR 12-APR-24 06.11.32.32 AM
WLN_DOC_PERSIST_SECURE_cdp0338a1_INCR 12-APR-24 06.11.19.98 AM
WLN_HIST24_31_cdp0345a1_INCR 12-APR-24 06.07.10.64 AM
WLN_REAL_TIME_CONTROLLER_cdp0346a1_INCR 12-APR-24 06.02.07.62 AM
WLN_DATA_ORCHESTRATION_cdp0346a1_INCR 12-APR-24 06.01.15.45 AM
SHR_DATA_ORCHESTRATION_ORP406A_INCR 12-APR-24 06.01.02.35 AM
SHR_LIBRARYAPI_ORP406_INCR 12-APR-24 06.00.58.79 AM
SHR_ADC_ORP406A_INCR 12-APR-24 06.00.27.94 AM
SHR_FORMANSWER_ORP406A_INCR 12-APR-24 06.00.24.02 AM
WLN_CASETRACKING_cdp0346a1_INCR 12-APR-24 05.56.39.72 AM
WL_ANALYTICS_cdp0346a1_INCR 12-APR-24 05.52.34.29 AM
WLN_GW_WESTLAW_cdp0346a1_INCR 12-APR-24 05.50.29.41 AM
WLN_GATHER_cdp0350a1_INCR 12-APR-24 05.49.54.16 AM
WLN_GATEWAY_cdp0350a1_INCR 12-APR-24 05.48.09.27 AM
WLN_WESTLAWNEXT_WEBCONTENT_cdp0350a1_INC 12-APR-24 05.46.23.95 AM R
WLN_LINK_RESOLVER_cdp0350a1_INCR 12-APR-24 05.46.02.64 AM
WLN_DEPLOY_cdp0349a1_FULL 12-APR-24 05.44.57.44 AM
WLN_DEVWATCH_cdp0349a1_FULL 12-APR-24 05.42.34.31 AM
WLN_BIAS_cdp0349a1_FULL 12-APR-24 05.42.06.59 AM
WLN_PERFAPI_cdp0349a1_FULL 12-APR-24 05.42.05.83 AM
WLN_UBERGUI_cdp0349a1_FULL 12-APR-24 05.40.32.64 AM
SHR_GATHER_ORP343A_INCR 12-APR-24 05.39.47.84 AM
SHR_CF0_8_ORP343A_INCR 12-APR-24 05.37.07.69 AM
SHR_CF27_31_ORP343A_INCR 12-APR-24 05.35.16.43 AM
SHR_CF9_17_ORP343A_INCR 12-APR-24 05.33.47.75 AM
SHR_CF18_26_ORP343A_INCR 12-APR-24 05.33.31.31 AM
SHR_DOC_PERSIST_SECURE_ORP896A_INCR 12-APR-24 05.11.54.94 AM
SHR_DOC_PERSIST_ORP896A_INCR 12-APR-24 05.10.17.48 AM
WLN_CF8_15_cdp0337a1_INCR 12-APR-24 04.59.24.29 AM
WLN_CF16_23_cdp0337a1_INCR 12-APR-24 04.56.50.82 AM
WLN_CF24_31_cdp0337a1_INCR 12-APR-24 04.56.30.46 AM
WLN_CF0_7_cdp0337a1_INCR 12-APR-24 04.53.39.27 AM
BSI_OCP_ORP157A_INCR_NEW 12-APR-24 04.48.24.46 AM
WLN_PRISMSEC_ORP724A_INCR 12-APR-24 03.01.39.95 AM
SHR_OMR_HR0_1_ORP422A_INCR 12-APR-24 02.38.00.85 AM
SHR_OMR0_1_ORP422A_INCR 12-APR-24 02.33.22.05 AM
WLN_DATA_ORCHESTRATION_cdp0350a1_INCR 12-APR-24 01.10.11.18 AM
SHR_CF_COLLAB_ORP343A_INCR 11-APR-24 11.00.28.72 PM
SHR_FORMANSWER_ORP406A_FULL 11-APR-24 11.00.13.87 PM
SHR_DATA_ORCHESTRATION_ORP406A_FULL 11-APR-24 10.02.38.30 PM
SHR_ADC_ORP406A_FULL 11-APR-24 10.02.34.30 PM
LSV_DATA_ORCHESTRATION_ORP900_INCR 11-APR-24 08.03.26.37 PM
SHR_ALL_SCHEMA_VERSION_FULL 11-APR-24 03.01.14.07 PM
-
As we don't have option for attachment, here is how the Golden Gate veridata report looks like -
OOS ROWS
JNAME GNAME TABLE_NAME COMP_ROWS OOS_ROWS STOP_DATE
---------------------------------------- ---------------------------------------- ------------------------- ---------- -------- -------------------------
SHR_TNP_WEBCONTENT_ORP406A_INCR SHR_TNP_WEBCONTENT_ORP406A_INCR BLURBS 6,890 3 12-APR-24 06.03.04.54 AM
" ALL DML for OOS ROWS are stored on xxxxxxxxxxxxx:/veridata/xxxxx/scripts/VDC/tmp/oos/*.sql , if no files generated, all OOS are IN-FLIGHT"FAILED JOBS
JNAME GNAME FAILED_DATE ERRORS
---------------------------------------- ---------------------------------------- ------------------------- ------
WLN_HIST16_23_cdp0345a1_INCR WLN_HIST23_cdp0345a1_INCR 12-APR-24 07.39.11.37 AM 1NO OOS ROWS
JOB DID NOT RUN TODAY
*********************"JOB RUN TODAY SUCCESSFULLY "
Thanks,Ramniwas
Please sign in to leave a comment.
Comments
3 comments