Fatal Errors As of: 2019.07.23 03:39 Num Herd ER Test date TTYPE V2K test Err Code Error Description Err Val Module ---- ------ -- --------- ------ --------- --------- ------------------------------ --------------------------------- --------- 1 32515 05 19.07.19 19.05.29 CMI-00738 Oracle error cannot insert NULL into ("CMIP"." CMI32060 Fatal Errors for New Herds WH Errors Num Herd ER Test date TTYPE V2K test Err Code Error Description Err Val Module ---- ------ -- --------- ------ --------- --------- ------------------------------ --------------------------------- --------- 1 32515 05 19.07.22 19.05.29 CMI-01077 Offline lab test date > 12 day CMI31230 Fatal errors (test already exist) and (Error creating htp) no rows selected Fatal errors from non-current tests no rows selected  Find OnFarm SCC Credits as of: 2019.07.23 03:34:37 SOURCE BILL_TO_ BILL_TO_HRD_ID HR TEST_DATE EMPL_ ITEM_CD R QUANTITY PRICE ID LINE_NO ---------- -------- -------------- -- --------- ----- --------- - --------- --------- --------- --------- ONFARM 10439-05 32825 05 19-JUL-19 24163 24-240102 0 1 1316768 4 ONFARM 10463-05 32841 05 18-JUL-19 21970 24-240102 0 1 1316460 3 ONFARM 10484-05 32848 05 20-JUL-19 20109 24-240102 0 1 1316719 4 3 rows selected. Find Zero Qty - Hrs - Min as of: 2019.07.23 03:34:39 no rows selected  SMS monitoring Id Sender Receiver Msg SentTime RecdTime Reference Operator MsgType ------------- ------------------------------ ------------------------------ ------------------------- -------------------- -------------------- ---------- ---------- ---------- 5264 5196576409 +15198358112 SCC Alert 16 Apr 2019-07-16 05:41:40 2019-07-17 09:43:53 CANWEST SMS:TEXT ON 32864 5264 5196576409 +15198358112 SCC Alert 29 May 2019-07-16 05:41:52 2019-07-17 09:44:02 CANWEST SMS:TEXT ON 32864 5266 5196576409 +15198358112 Just the 2000000 ones are 2019-07-16 05:42:57 2019-07-17 09:45:08 CANWEST SMS:TEXT 5266 5196576409 +15198358112 These are april and may # 2019-07-16 05:42:25 2019-07-17 09:44:36 CANWEST SMS:TEXT 5268 5196576409 +15198358112 Just crossing talk to you 2019-07-16 05:44:54 2019-07-17 09:47:06 CANWEST SMS:TEXT 5284 6132277201 +15198358112 Ok 2019-07-21 08:52:08 2019-07-22 12:54:23 CANWEST SMS:TEXT 6 rows selected. no rows selected Find advisor with wrong addr type As of: 2019.07.23 03:39 no rows selected JOHNES missing - looks for HCO but null on HTP As of: 2019.07.23 03:38 no rows selected LEUKOSIS missing - looks for HCO but null on HTP PR Htp id Testdate PROCSD_DA NUM_JOHNES NUM_LEUKOSIS NUM_STAPH NUM_NEOSPORA START_DAT END_DATE -- ---------- ---------- --------- ---------- ------------ --------- ------------ --------- --------- 08 2310 15-JUL-19 17-JUL-19 6 124 12-JUL-19 17-JUL-19 1 row selected. MASTITIS 4 missing - looks for HCO but null on HTP PR Htp id Testdate PROCSD_DA NUM_JOHNES NUM_LEUKOSIS NUM_STAPH NUM_NEOSPORA START_DAT END_DATE -- ---------- ---------- --------- ---------- ------------ --------- ------------ --------- --------- 05 30890 16-JUL-19 17-JUL-19 13-JUL-19 17-JUL-19 1 row selected. BVD missing - looks for HCO but null on HTP no rows selected NEOSPORA missing - looks for HCO but null on HTP no rows selected PREG CHK missing - looks for HCO but null on HTP PR Htp id Testdate PROCSD_DA NUM_JOHNES NUM_LEUKOSIS NUM_STAPH NUM_NEOSPORA NUM_PREG_CONF START_DAT END_DATE -- ---------- ---------- --------- ---------- ------------ --------- ------------ ------------- --------- --------- 05 32375 12-JUL-19 15-JUL-19 09-JUL-19 14-JUL-19 1 row selected. Mast 4 - on HTP but billing quantity is different or missing no rows selected Preg Conf - on HTP but billing quantity is different or missing PL/SQL procedure successfully completed. Johnes - on HTP but billing quantity is different or missing no rows selected Leukosis - on HTP but billing quantity is different or missing no rows selected BVD - on HTP but billing quantity is different or missing no rows selected BVD - ELISA msrmnt in the database in SUSPECT range no rows selected MILK/HR - Monitor herds on milk/hour adj As of: 2019.07.23 03:38 Pr Herd EffDate Status -- --------- --------- -------- 05 11519 14-SEP-12 3x 05 11542 31-MAY-16 2x3x 05 11768 01-JUL-11 3x 05 12188 03-FEB-17 3x 05 12442 25-JUN-11 3x 05 12896 01-DEC-18 3x 05 13225 19-JUL-19 3x 05 13737 01-APR-13 3x 05 14735 03-APR-14 3x 05 15638 13-FEB-12 2x3x 05 18065 15-FEB-14 3x 05 18588 22-FEB-18 3x 05 18722 08-APR-13 3x 05 19082 24-APR-13 3x 05 19303 01-NOV-16 3x 05 20138 23-FEB-15 3x 05 21040 07-JAN-17 3x 05 21431 09-SEP-16 3x 05 22311 01-JAN-13 2x3x 05 24063 30-JUN-18 3x 05 24384 08-JAN-19 2x3x 05 30555 30-JUN-11 3x 05 30968 06-JUL-15 3x 05 31196 01-APR-13 3x 05 31240 09-APR-18 3x 05 31527 23-JAN-18 3x 05 31678 17-APR-13 3x 05 31741 13-JUL-19 NOT USED 05 31830 01-DEC-17 2x 05 32123 12-DEC-16 2x3x 05 32336 18-JUL-13 2x3x 05 32411 15-SEP-16 3x 05 32662 24-JAN-18 3x 06 60038 29-SEP-11 3x 06 60151 05-JUN-17 3x 06 60180 10-JAN-16 3x 06 60543 25-JUN-11 2x3x 08 1673 28-NOV-18 2x3x 08 2556 29-APR-19 NOT USED 09 64131 23-MAY-19 3x 09 87355 22-APR-19 NOT USED 09 91675 02-AUG-13 3x 09 92633 05-JUL-11 2x3x 43 rows selected. Pr Herd EffDate Status -- --------- --------- -------- 05 16125 20-MAR-19 3x 1 row selected.  Find_missing_callfee - missing in last 90 days As of: 2019.07.23 03:39 no rows selected Unusual callfee billing records As of: 2019.07.23 03:34 no rows selected BARNCARD - find multiple whole herd card sets As of: 2019.07.23 03:39 no rows selected Ont citric find START: 23-Jul-2019 03:39:13 Ont citric find ENDED: 23-Jul-2019 03:39:19 FIND_HCT_BILL_TO - bill_to to ended owners As of: 2019.07.23 03:39 no rows selected ETYPE_NULL - looks for elec_file_type of null As of: 2019.07.23 03:39 no rows selected ETYPE_NULL - looks for elec_file_type of robot As of: 2019.07.23 03:39 no rows selected  HOLDINV - herd_contacts where Hold inv not set As of: 2019.07.23 03:39 ORPHOPQ - orphaned option queue records As of: 2019.07.23 03:39 no rows selected DNLERR - errors creating dnl files As of: 2019.07.23 03:39 no rows selected FIND_OFL_ERROR_HERDS started: As of: 2019.07.23 03:38 Prv Herd Test Date Htp id Sev Err Code #J Htp #J Lab #L Htp #L Lab #S Htp #S Lab #B Htp #B Lab #N Htp #N Lab #P Htp #P Lab 05 32515 22-JUL-19 WH CMI-01077 08 2310 15-JUL-19 2548107 WC CMI-00274 6 6 124 124 124 FIND_OFL_ERROR_HERDS ended: As of: 2019.07.23 03:38 OFLLOAD started: 2019.Jul.23 03:39:47 no rows selected Ofl Date Herd Pr Contact PIN Compnt CntNum HtpNum PosProto PosMycoP PosStaph PosStrep PregFull PregDisc ----------------- --------- -- ----- ------- -------- ------------ ------- ------- --------- --------- --------- --------- --------- --------- 22-Jul-2019 11:45 1115 08 01646 6821 Leucosis 70 70 1 22-Jul-2019 11:45 20184 09 00158 4401 Leucosis 4 4 22-Jul-2019 14:45 14912 05 01991 7840 Preg Conf 1 1 0 22-Jul-2019 14:45 16048 05 02653 1401 Preg Conf 8 8 8 22-Jul-2019 14:45 30196 05 07813 5165 Preg Conf 11 11 10 22-Jul-2019 14:45 32715 05 05009 6487 Preg Conf 13 13 7 6 22-Jul-2019 12:55 10713 05 00315 3746 Staph Aureus 4 4 1 22-Jul-2019 12:55 13897 05 01601 6106 Staph Aureus 16 16 2 22-Jul-2019 12:55 16048 05 02653 1401 Staph Aureus 4 4 22-Jul-2019 12:55 18911 05 04709 2108 Staph Aureus 4 4 1 22-Jul-2019 12:55 22250 05 06398 1775 Staph Aureus 1 1 22-Jul-2019 12:55 31940 05 09373 2524 Staph Aureus 1 1 12 rows selected. FINDDOT - look for single "." in addr 1 and 2 As of: 2019.07.23 03:39 no rows selected no rows selected no rows selected no rows selected CSRCIRNO - look for CSR with null cir/ dst/ prv As of: 2019.07.23 03:39 no rows selected