Fatal Errors As of: 2019.12.14 03:39 Num Herd ER Test date TTYPE V2K test Err Code Error Description Err Val Module ---- ------ -- --------- ------ --------- --------- ------------------------------ --------------------------------- --------- 1 60707 06 19.12.12 19.11.08 CMI-00371 Wrong number of Lab records Lo CMI33400 1 60942 06 19.12.13 19.10.31 CMI-00365 Wrong number of records Loaded CMI33400 Fatal Errors for New Herds WH Errors 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.12.14 03:34:44 SOURCE BILL_TO_ BILL_TO_HRD_ID HR TEST_DATE EMPL_ ITEM_CD R QUANTITY PRICE ID LINE_NO ---------- -------- -------------- -- --------- ----- --------- - --------- --------- --------- --------- ONFARM 10438-05 32824 05 12-DEC-19 24243 24-240102 0 1 1348199 4 ONFARM 10447-05 32827 05 12-DEC-19 24193 24-240102 0 1 1348416 2 ONFARM 10447-05 32827 05 12-DEC-19 24193 24-240102 0 1 1348416 5 ONFARM 05231-05 32868 05 11-DEC-19 24193 24-240102 0 1 1348281 8 ONFARM 05231-05 32868 05 11-DEC-19 24193 24-240102 0 1 1348281 1 ONFARM 05231-05 32868 05 11-DEC-19 24193 24-240102 0 1 1348281 2 ONFARM 10509-05 32870 05 12-DEC-19 23964 24-240102 0 1 1348310 2 ONFARM 10509-05 32870 05 12-DEC-19 23964 24-240102 0 1 1348310 5 8 rows selected. Find Zero Qty - Hrs - Min as of: 2019.12.14 03:34:48 no rows selected  SMS monitoring Id Sender Receiver Msg SentTime RecdTime Reference Operator MsgType ------------- ------------------------------ ------------------------------ ------------------------- -------------------- -------------------- ---------- ---------- ---------- 5604 6135723163 +15198358112 Please test them all for 2019-12-10 05:00:11 2019-12-10 10:02:37 CANWEST SMS:TEXT 1 row selected. Id Sender Receiver Msg Status SentTime Error Msg Operator MsgType Reference ------------- ------------------------------ ------------------------------ ---------------- -------------------- -------------------- ------------------------------ ---------- ---------- ---------- 201885 1-800-549-4373 +16136129897 CCS Alerte 06 Dé sent 2019-12-09 10:01:06 set to resend - second try 1 row selected. Find advisor with wrong addr type As of: 2019.12.14 03:39 no rows selected JOHNES missing - looks for HCO but null on HTP As of: 2019.12.14 03:37 no rows selected LEUKOSIS missing - looks for HCO but null on HTP no rows selected MASTITIS 4 missing - looks for HCO but null on HTP no rows 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 no rows 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.12.14 03:37 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 12467 01-NOV-19 2x 05 12896 01-DEC-18 3x 05 13225 02-OCT-19 3x 05 13737 01-APR-13 3x 05 14735 03-APR-14 3x 05 15638 23-JUL-19 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 25964 20-NOV-19 2x3x 05 30555 20-AUG-19 3x 05 30968 27-AUG-19 3x 05 31240 09-APR-18 3x 05 31527 25-JUL-19 3x 05 31678 17-APR-13 3x 05 31741 20-OCT-19 NOT USED 05 31830 01-DEC-17 2x 05 32336 18-JUL-13 2x3x 05 32411 15-SEP-16 3x 05 32662 21-NOV-19 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 17-OCT-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 09 33097 10-SEP-19 2x3x 2 rows selected.  Find_missing_callfee - missing in last 90 days As of: 2019.12.14 03:39 no rows selected Unusual callfee billing records As of: 2019.12.14 03:34 no rows selected BARNCARD - find multiple whole herd card sets As of: 2019.12.14 03:40 no rows selected Ont citric find START: 14-Dec-2019 03:39:54 Ont citric find ENDED: 14-Dec-2019 03:40:03 FIND_HCT_BILL_TO - bill_to to ended owners As of: 2019.12.14 03:40 no rows selected ETYPE_NULL - looks for elec_file_type of null As of: 2019.12.14 03:40 no rows selected ETYPE_NULL - looks for elec_file_type of robot As of: 2019.12.14 03:40 no rows selected  HOLDINV - herd_contacts where Hold inv not set As of: 2019.12.14 03:40 ORPHOPQ - orphaned option queue records As of: 2019.10.10 03:43 no rows selected DNLERR - errors creating dnl files As of: 2019.12.14 03:40 no rows selected FIND_OFL_ERROR_HERDS started: As of: 2019.12.14 03:37 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 31619 12-DEC-19 2580807 WC CMI-00274 1 FIND_OFL_ERROR_HERDS ended: As of: 2019.12.14 03:37 OFLLOAD started: 2019.Dec.14 03:40:50 no rows selected Ofl Date Herd Pr Contact PIN Compnt CntNum HtpNum PosProto PosMycoP PosStaph PosStrep PregFull PregDisc ----------------- --------- -- ----- ------- -------- ------------ ------- ------- --------- --------- --------- --------- --------- --------- 13-Dec-2019 15:26 32597 05 09893 3559 Johnes 1 13-Dec-2019 15:27 32597 05 09893 3559 Johnes 2 13-Dec-2019 15:27 67326 09 00459 3483 Johnes 84 84 2 13-Dec-2019 13:20 16454 05 09927 1501 Leucosis 6 6 13-Dec-2019 13:20 23325 05 06737 4434 Leucosis 9 9 13-Dec-2019 13:20 1001 08 00241 0138 Leucosis 6 6 13-Dec-2019 13:20 1707 08 00635 4717 Leucosis 19 19 13-Dec-2019 13:20 2020 08 00938 8095 Leucosis 11 11 13-Dec-2019 13:20 2603 08 01500 3683 Leucosis 23 23 13-Dec-2019 13:20 2621 08 01517 6211 Leucosis 9 9 13-Dec-2019 13:20 2845 08 09556 0084 Leucosis 2 2 13-Dec-2019 14:35 12373 05 00996 5600 Preg Conf 19 19 19 13-Dec-2019 14:35 12869 05 01217 0130 Preg Conf 1 1 1 13-Dec-2019 14:35 14425 05 01794 6899 Preg Conf 4 4 4 13-Dec-2019 16:25 16584 05 03007 6687 Preg Conf 1 1 1 13-Dec-2019 16:25 17061 05 03347 5061 Preg Conf 14 14 5 8 13-Dec-2019 14:35 18028 05 04053 9990 Preg Conf 4 4 4 13-Dec-2019 14:35 19897 05 05608 3294 Preg Conf 7 7 7 13-Dec-2019 16:25 20052 05 05688 5555 Preg Conf 19 19 19 13-Dec-2019 14:35 21737 05 06198 0271 Preg Conf 2 13-Dec-2019 14:35 22660 05 06531 7828 Preg Conf 19 19 0 19 13-Dec-2019 14:35 23421 05 06770 1594 Preg Conf 10 10 9 13-Dec-2019 16:25 24859 05 07280 6722 Preg Conf 2 13-Dec-2019 15:30 31154 05 08622 6310 Preg Conf 30 30 17 0 13-Dec-2019 14:35 32029 05 09436 6846 Preg Conf 6 6 5 13-Dec-2019 14:35 32079 05 03666 8153 Preg Conf 7 7 7 13-Dec-2019 16:25 32392 05 09712 7247 Preg Conf 6 6 6 13-Dec-2019 14:35 32584 05 09878 8205 Preg Conf 3 3 2 13-Dec-2019 14:35 32598 05 09895 8307 Preg Conf 4 4 4 13-Dec-2019 14:35 32765 05 01742 9184 Preg Conf 11 11 11 13-Dec-2019 14:35 60065 06 00064 5282 Preg Conf 2 2 1 13-Dec-2019 16:25 60169 06 09384 5086 Preg Conf 15 15 3 12 13-Dec-2019 16:25 60501 06 00470 6710 Preg Conf 230 230 114 106 13-Dec-2019 16:25 60511 06 00476 6800 Preg Conf 1 1 1 13-Dec-2019 16:25 60631 06 00584 3735 Preg Conf 5 5 4 13-Dec-2019 16:25 60820 06 00844 8243 Preg Conf 8 8 8 13-Dec-2019 16:25 60907 06 09371 7926 Preg Conf 1 1 1 13-Dec-2019 16:25 90020 07 00008 1587 Preg Conf 29 29 25 13-Dec-2019 14:35 90726 07 09307 2266 Preg Conf 125 125 72 52 13-Dec-2019 16:25 1521 08 00500 6605 Preg Conf 5 5 4 13-Dec-2019 16:25 1603 08 00561 2515 Preg Conf 7 7 0 7 13-Dec-2019 14:35 2627 08 01522 8937 Preg Conf 27 27 20 4 13-Dec-2019 15:30 2862 08 09575 8800 Preg Conf 61 61 54 13-Dec-2019 14:35 43321 09 09097 4794 Preg Conf 43 43 5 38 13-Dec-2019 14:26 13224 05 09894 5766 Staph Aureus 1 13-Dec-2019 14:26 13795 05 01569 6553 Staph Aureus 6 3 13-Dec-2019 14:26 15768 05 02477 1688 Staph Aureus 3 13-Dec-2019 14:26 15795 05 02495 1553 Staph Aureus 5 5 1 13-Dec-2019 14:26 15881 05 02555 3368 Staph Aureus 34 34 8 13-Dec-2019 14:26 17061 05 03347 5061 Staph Aureus 2 2 13-Dec-2019 14:26 17505 05 03662 6154 Staph Aureus 3 3 13-Dec-2019 14:26 17899 05 03969 1510 Staph Aureus 3 3 1 13-Dec-2019 14:26 19367 05 05121 4404 Staph Aureus 6 6 13-Dec-2019 14:26 21737 05 06198 0271 Staph Aureus 3 1 13-Dec-2019 14:26 23368 05 06747 2281 Staph Aureus 2 2 13-Dec-2019 14:26 30327 05 07913 6429 Staph Aureus 6 6 13-Dec-2019 14:26 30941 05 08462 8444 Staph Aureus 1 13-Dec-2019 14:26 31619 05 09504 4495 Staph Aureus 1 13-Dec-2019 14:26 31835 05 07308 9505 Staph Aureus 6 13-Dec-2019 14:26 32434 05 09746 2902 Staph Aureus 12 12 1 13-Dec-2019 14:26 32584 05 09878 8205 Staph Aureus 3 3 13-Dec-2019 14:26 1603 08 00561 2515 Staph Aureus 8 8 1 13-Dec-2019 14:26 2465 08 01370 4613 Staph Aureus 4 4 1 13-Dec-2019 14:26 43321 09 09097 4794 Staph Aureus 10 10 13-Dec-2019 14:26 67326 09 00459 3483 Staph Aureus 5 5 2 65 rows selected. FINDDOT - look for single "." in addr 1 and 2 As of: 2019.12.14 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.12.14 03:39 no rows selected