Fatal Errors As of: 2019.05.25 03:42 Num Herd ER Test date TTYPE V2K test Err Code Error Description Err Val Module ---- ------ -- --------- ------ --------- --------- ------------------------------ --------------------------------- --------- 1 18540 05 19.05.23 19.04.23 CMI-00738 Oracle error cannot insert NULL into ("CMIP"." CMI32060 Fatal Errors for New Herds WH Errors Fatal errors (test already exist) and (Error creating htp) Herd ER Test date ER Err Code Err Val Module ------ -- --------- -- --------- --------------------------------- --------- 11957 05 19.05.22 00 CMI-00738 deadlock detected while waiting f CMI33270 11285 05 19.05.22 00 CMI-00364 CMI33400 17690 05 19.05.23 00 CMI-00364 CMI33400 3 rows selected. Fatal errors from non-current tests no rows selected  Find OnFarm SCC Credits as of: 2019.05.25 03:35:20 SOURCE BILL_TO_ BILL_TO_HRD_ID HR TEST_DATE EMPL_ ITEM_CD R QUANTITY PRICE ID LINE_NO ---------- -------- -------------- -- --------- ----- --------- - --------- --------- --------- --------- ONFARM 10402-05 20892 05 18-MAY-19 20397 24-240102 0 1 1304653 4 ONFARM 10378-05 32795 05 16-MAY-19 24131 24-240102 0 1 1304208 7 ONFARM 10378-05 32795 05 16-MAY-19 24131 24-240102 0 1 1304208 3 ONFARM 10410-05 32807 05 15-MAY-19 24259 24-240102 0 1 1303765 2 ONFARM 10410-05 32807 05 15-MAY-19 24259 24-240102 0 1 1303765 4 ONFARM 10411-05 32808 05 23-MAY-19 24206 24-240102 0 1 1305054 4 ONFARM 10437-05 32823 05 18-MAY-19 23535 24-240102 0 1 1304670 4 ONFARM 10438-05 32824 05 21-MAY-19 24243 24-240102 0 1 1304671 5 ONFARM 10438-05 32824 05 21-MAY-19 24243 24-240102 0 1 1304671 1 ONFARM 10447-05 32827 05 16-MAY-19 24193 24-240102 0 1 1304216 4 ONFARM 10448-05 32828 05 22-MAY-19 24131 24-240102 0 1 1304841 4 ONFARM 10457-05 32836 05 14-MAY-19 23580 24-240102 0 1 1303677 5 ONFARM 10462-05 32840 05 16-MAY-19 22705 24-240102 0 1 1304258 4 ONFARM 10483-05 32847 05 17-MAY-19 21474 24-240102 0 1 1304474 6 ONFARM 10495-05 32856 05 18-MAY-19 21474 24-240102 0 1 1304646 5 ONFARM 10495-05 32856 05 18-MAY-19 21474 24-240102 0 1 1304646 2 ONFARM 09876-05 32862 05 15-MAY-19 23996 24-240102 0 1 1304123 5 ONFARM 09876-05 32862 05 15-MAY-19 23996 24-240102 0 1 1304123 1 ONFARM 05231-05 32868 05 14-MAY-19 24193 24-240102 0 1 1303690 4 19 rows selected. Find Zero Qty - Hrs - Min as of: 2019.05.25 03:35:26 no rows selected  SMS monitoring Id Sender Receiver Msg SentTime RecdTime Reference Operator MsgType ------------- ------------------------------ ------------------------------ ------------------------- -------------------- -------------------- ---------- ---------- ---------- 5064 5198912005 +15198358112 Thankyou 2019-05-23 08:34:08 2019-05-24 12:36:22 CANWEST SMS:TEXT 1 row selected. Id Sender Receiver Msg Status SentTime Error Msg Operator MsgType Reference ------------- ------------------------------ ------------------------------ ---------------- -------------------- -------------------- ------------------------------ ---------- ---------- ---------- 188105 1-800-549-4373 +15198085151 SCC Alert 22 May sent 2019-05-23 10:01:04 set to resend - second try 1 row selected. Find advisor with wrong addr type As of: 2019.05.25 03:42 no rows selected JOHNES missing - looks for HCO but null on HTP As of: 2019.05.25 03:40 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 18531 05 08-MAY-19 2534254 15 14 11 19794 05 03-MAY-19 2533241 14 13 12 19811 05 03-MAY-19 2533257 5 3 4 23421 05 26-APR-19 2531736 9 8 7 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.05.25 03:40 Pr Herd EffDate Status -- --------- --------- -------- 05 10058 29-NOV-16 2x 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 12-NOV-14 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 31386 30-OCT-17 3x 05 31527 23-JAN-18 3x 05 31678 17-APR-13 3x 05 31741 10-APR-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 24-DEC-18 3x 09 87355 22-APR-19 NOT USED 09 91675 02-AUG-13 3x 09 92633 05-JUL-11 2x3x 45 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.05.25 03:42 no rows selected Unusual callfee billing records As of: 2019.05.25 03:34 no rows selected BARNCARD - find multiple whole herd card sets As of: 2019.05.25 03:42 no rows selected Ont citric find START: 25-May-2019 03:42:24 Ont citric find ENDED: 25-May-2019 03:42:25 FIND_HCT_BILL_TO - bill_to to ended owners As of: 2019.05.25 03:42 no rows selected ETYPE_NULL - looks for elec_file_type of null As of: 2019.05.25 03:42 no rows selected ETYPE_NULL - looks for elec_file_type of robot As of: 2019.05.25 03:42 no rows selected  HOLDINV - herd_contacts where Hold inv not set As of: 2019.05.25 03:42 ORPHOPQ - orphaned option queue records As of: 2019.05.25 03:42 no rows selected DNLERR - errors creating dnl files As of: 2019.05.25 03:42 AnmId Herd Pr TestDate FileCode File Module Error Msg ----------- ------ -- --------- --------- ------------ --------- ------------------------------------------------------------ 11838637 60439 06 21-MAY-19 D Dnl or Dn2 ais6202x ORA-12899: value too large for column "AIS"."EXT_ANML_TEST_D 1 row selected. FIND_OFL_ERROR_HERDS started: As of: 2019.05.25 03:40 FIND_OFL_ERROR_HERDS ended: As of: 2019.05.25 03:40 OFLLOAD started: 2019.May.25 03:43:18 no rows selected Ofl Date Herd Pr Contact PIN Compnt CntNum HtpNum PosProto PosMycoP PosStaph PosStrep PregFull PregDisc ----------------- --------- -- ----- ------- -------- ------------ ------- ------- --------- --------- --------- --------- --------- --------- 24-May-2019 13:35 18545 05 04430 5658 Johnes 1 1 24-May-2019 13:35 20911 05 05947 6774 Johnes 4 4 24-May-2019 13:35 21052 05 05989 8732 Johnes 11 24-May-2019 13:35 32708 05 10200 8824 Johnes 23 23 24-May-2019 13:35 90287 07 00105 9048 Johnes 1 1 24-May-2019 15:45 23303 05 06729 1424 Leucosis 1 1 24-May-2019 15:45 90287 07 00105 9048 Leucosis 1 1 24-May-2019 15:25 1621 08 00575 6253 Leucosis 13 13 24-May-2019 15:25 2827 08 09541 3732 Leucosis 8 8 24-May-2019 14:45 10950 05 00405 6605 Preg Conf 5 5 0 5 24-May-2019 14:45 11658 05 09721 5505 Preg Conf 8 8 8 24-May-2019 10:19 13950 05 01621 9377 Preg Conf 5 5 5 24-May-2019 14:45 14333 05 01763 6763 Preg Conf 4 4 0 4 24-May-2019 14:45 15799 05 02498 2990 Preg Conf 12 12 9 24-May-2019 14:45 17061 05 03347 5061 Preg Conf 16 16 9 6 24-May-2019 14:45 19567 05 05309 9282 Preg Conf 7 7 0 7 24-May-2019 14:45 20498 05 05831 1447 Preg Conf 13 13 12 24-May-2019 14:45 20911 05 05947 6774 Preg Conf 2 2 2 24-May-2019 14:45 25043 05 07343 1950 Preg Conf 9 9 9 24-May-2019 14:45 25136 05 07375 4018 Preg Conf 6 6 5 24-May-2019 14:45 30017 05 07698 4718 Preg Conf 2 2 2 24-May-2019 14:45 31031 05 08522 4129 Preg Conf 9 9 9 24-May-2019 14:45 31382 05 08868 2381 Preg Conf 3 3 2 24-May-2019 14:45 32233 05 09573 3630 Preg Conf 6 6 6 24-May-2019 14:45 32808 05 10411 0314 Preg Conf 3 3 3 24-May-2019 14:45 60364 06 00363 5444 Preg Conf 4 4 0 4 24-May-2019 14:45 60547 06 00509 6253 Preg Conf 2 2 2 24-May-2019 14:45 60631 06 00584 3735 Preg Conf 10 10 9 24-May-2019 14:45 60907 06 09371 7926 Preg Conf 8 8 7 24-May-2019 16:25 90256 07 00096 5549 Preg Conf 14 14 0 14 24-May-2019 14:45 90287 07 00105 9048 Preg Conf 19 19 18 24-May-2019 14:45 90546 07 09296 6245 Preg Conf 15 15 0 15 24-May-2019 14:45 90725 07 09305 6230 Preg Conf 28 28 19 4 24-May-2019 14:45 1290 08 00359 2270 Preg Conf 11 11 8 3 24-May-2019 14:45 2358 08 01267 3940 Preg Conf 13 13 12 24-May-2019 13:28 10950 05 00405 6605 Staph Aureus 1 1 24-May-2019 13:28 12356 05 00988 1485 Staph Aureus 5 5 1 24-May-2019 13:45 13809 05 10500 4531 Staph Aureus 10 10 3 24-May-2019 13:28 13851 05 01585 6448 Staph Aureus 4 4 24-May-2019 13:28 15867 05 02543 2938 Staph Aureus 3 3 24-May-2019 13:28 17061 05 03347 5061 Staph Aureus 1 1 24-May-2019 13:28 18545 05 04430 5658 Staph Aureus 3 3 24-May-2019 13:28 19483 05 05228 7551 Staph Aureus 2 2 24-May-2019 14:31 19791 05 05519 6128 Staph Aureus 1 1 1 24-May-2019 13:28 23707 05 06875 6148 Staph Aureus 1 1 24-May-2019 13:28 30111 05 07760 9590 Staph Aureus 7 7 1 24-May-2019 13:28 31205 05 08669 7464 Staph Aureus 2 24-May-2019 13:28 31340 05 10107 8600 Staph Aureus 1 1 24-May-2019 13:28 31444 05 08923 9818 Staph Aureus 1 24-May-2019 13:28 32522 05 09810 1991 Staph Aureus 3 3 1 24-May-2019 13:28 90546 07 09296 6245 Staph Aureus 30 30 24-May-2019 13:28 2407 08 01313 8080 Staph Aureus 1 1 24-May-2019 13:28 2890 08 09547 6624 Staph Aureus 6 6 53 rows selected. FINDDOT - look for single "." in addr 1 and 2 As of: 2019.05.25 03:42 no rows selected no rows selected no rows selected no rows selected CSRCIRNO - look for CSR with null cir/ dst/ prv As of: 2019.05.25 03:42 no rows selected