Fatal Errors As of: 2024.07.26 03:42 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: 2024.07.26 03:34:19 no rows selected Find Males with Lactations as of: 2024.07.26 03:34:24 no rows selected Find mis-match species-breed on Cow Dam Sire as of: 2024.07.26 03:35:10 no rows selected Find Zero Qty - Hrs - Min as of: 2024.07.26 03:38:46 no rows selected  SMS monitoring no rows selected Id Sender Receiver Msg Status SentTime Error Msg Operator MsgType Reference ------------- ------------------------------ ------------------------------ ---------------- -------------------- -------------------- ------------------------------ ---------- ---------- ---------- 252151 1-800-549-4373 +15199425640 SCC Alert 16 Jul sent 2024-07-23 08:58:42 set to resend - second try 1 row selected. no rows selected Find advisor with wrong addr type As of: 2024.07.26 03:42 no rows selected JOHNES missing - looks for HCO but null on HTP As of: 2024.07.26 03:41 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 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 MILK/HR - Monitor herds on milk/hour adj As of: 2024.07.26 03:41 Pr Herd EffDate Status -- --------- --------- -------- 05 11519 20-DEC-21 3x 05 11542 31-MAY-16 2x3x 05 11768 01-NOV-21 2x3x 05 12188 03-FEB-17 3x 05 12467 19-NOV-20 2x 05 12896 26-JUN-20 3x 05 13225 22-APR-21 3x 05 14735 03-JUL-20 3x 05 15638 16-JUN-20 2x3x 05 18065 10-JUL-20 3x 05 18588 17-FEB-24 3x 05 19082 16-JUN-20 3x 05 19303 01-SEP-22 3x 05 20138 30-JUN-23 3x 05 21040 18-JUN-20 3x 05 21431 25-JUN-20 3x 05 24063 03-JUL-20 3x 05 25964 16-SEP-22 2x3x 05 31527 23-JUN-20 3x 05 31678 30-JUN-20 3x 05 31741 01-JUL-23 NOT USED 05 31830 07-JUL-23 2x 05 32411 19-DEC-20 3x 06 60038 22-OCT-21 3x 06 60151 22-JUN-20 3x 06 60180 08-JUN-20 3x 06 60543 19-JAN-24 2x3x 08 1673 01-JUL-22 NOT USED 08 2556 03-JUL-20 NOT USED 09 87355 30-JUN-20 NOT USED 09 91675 21-MAY-20 3x 31 rows selected. Pr Herd EffDate Status -- --------- --------- -------- 05 11219 08-FEB-23 3x 05 11719 01-JUN-23 2x3x 05 13869 15-MAR-24 2x3x 05 13950 29-MAY-24 2x3x 05 16035 10-OCT-23 2x3x 05 19370 01-NOV-22 2x3x 05 19767 01-MAY-24 2x3x 05 22613 28-NOV-23 2x3x 05 23581 01-JUN-23 2x3x 05 26134 23-JAN-24 2x3x 05 30052 20-FEB-24 2x 05 30398 14-JUL-21 2x3x 05 32292 15-JUN-24 2x3x 06 60174 10-MAR-23 2x3x 06 60364 31-DEC-21 2x3x 06 60941 01-DEC-22 2x3x 09 33097 17-JUN-20 2x3x 09 35248 29-APR-24 2x3x 18 rows selected.  Find_missing_callfee - missing in last 90 days As of: 2024.07.26 03:42 no rows selected Unusual callfee billing records As of: 2024.07.26 03:34 no rows selected BARNCARD - find multiple whole herd card sets As of: 2024.07.26 03:42 no rows selected Ont citric find START: 26-Jul-2024 03:42:09 Ont citric find ENDED: 26-Jul-2024 03:42:12 FIND_HCT_BILL_TO - bill_to to ended owners As of: 2024.07.26 03:42 no rows selected ETYPE_NULL - looks for elec_file_type of null As of: 2024.07.26 03:42 no rows selected ETYPE_NULL - looks for elec_file_type of robot As of: 2024.07.26 03:42 no rows selected  HOLDINV - herd_contacts where Hold inv not set As of: 2024.07.26 03:42 ORPHOPQ - orphaned option queue records As of: 2024.07.26 03:42 no rows selected DNLERR - errors creating dnl files As of: 2024.07.26 03:42 AnmId Herd Pr TestDate FileCode File Module Error Msg ----------- ------ -- --------- --------- ------------ --------- ------------------------------------------------------------ 13796379 15967 05 23-JUL-24 3 AnmTstDay ais62070 ORA-12899: value too large for column "AIS"."EXT_HIST_ANML_T 13758435 32862 05 13-JUN-24 3 AnmTstDay ais62070 ORA-12899: value too large for column "AIS"."EXT_HIST_ANML_T 13758435 32862 05 24-JUL-24 3 AnmTstDay ais62070 ORA-12899: value too large for column "AIS"."EXT_HIST_ANML_T 3 rows selected. FIND_OFL_ERROR_HERDS started: As of: 2024.07.26 03:41 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 32778 22-JUL-24 2855090 WC CMI-00274 2 FIND_OFL_ERROR_HERDS ended: As of: 2024.07.26 03:41 OFLLOAD started: 2024.Jul.26 03:42:36 no rows selected Ofl Date Herd Pr Contact PIN Compnt CntNum HtpNum PosProto PosMycoP PosStaph PosStrep PregFull PregDisc ----------------- --------- -- ----- ------- -------- ------------ ------- ------- --------- --------- --------- --------- --------- --------- 25-Jul-2024 13:56 12801 05 01176 9800 Johnes 4 4 25-Jul-2024 13:56 19516 05 05259 3533 Johnes 7 7 25-Jul-2024 14:48 19776 05 05504 3616 Johnes 3 3 25-Jul-2024 13:56 25981 05 07636 4400 Johnes 7 7 25-Jul-2024 13:56 1115 08 01646 6821 Johnes 87 87 25-Jul-2024 13:56 1621 08 00575 6253 Johnes 5 5 25-Jul-2024 15:18 13048 05 01307 4311 Preg Conf 8 25-Jul-2024 15:18 14084 05 10369 9938 Preg Conf 1 25-Jul-2024 15:18 15926 05 06805 2172 Preg Conf 6 6 1 5 25-Jul-2024 15:18 17277 05 03492 0489 Preg Conf 3 3 3 0 25-Jul-2024 15:18 18840 05 04652 6302 Preg Conf 10 10 6 4 25-Jul-2024 15:18 23525 05 06805 2172 Preg Conf 8 25-Jul-2024 15:18 25757 05 07576 3767 Preg Conf 3 25-Jul-2024 15:18 31660 05 09108 2640 Preg Conf 2 2 2 25-Jul-2024 15:18 31984 05 06730 1146 Preg Conf 14 25-Jul-2024 15:18 32052 05 05071 2020 Preg Conf 3 3 3 0 25-Jul-2024 15:18 99010 09 10322 8004 Preg Conf 22 22 21 25-Jul-2024 14:48 13190 05 01361 5297 Staph Aureus 2 2 25-Jul-2024 14:44 13851 05 01585 6448 Staph Aureus 1 1 25-Jul-2024 14:44 15192 05 02116 8272 Staph Aureus 2 2 25-Jul-2024 14:44 16454 05 09927 1501 Staph Aureus 3 25-Jul-2024 14:44 18664 05 04515 1822 Staph Aureus 1 25-Jul-2024 14:44 18840 05 04652 6302 Staph Aureus 5 5 25-Jul-2024 14:44 22850 05 06586 1838 Staph Aureus 2 2 1 25-Jul-2024 14:44 32661 05 10080 4176 Staph Aureus 5 5 2 25-Jul-2024 14:44 32717 05 10217 7335 Staph Aureus 5 5 3 25-Jul-2024 14:44 32811 05 10417 3851 Staph Aureus 4 4 1 25-Jul-2024 14:44 32987 05 10678 0006 Staph Aureus 3 3 25-Jul-2024 14:44 1621 08 00575 6253 Staph Aureus 2 2 25-Jul-2024 14:44 1857 08 00776 8874 Staph Aureus 4 4 1 25-Jul-2024 14:44 2535 08 01439 3223 Staph Aureus 6 6 1 2 31 rows selected. FINDDOT - look for single "." in addr 1 and 2 As of: 2024.07.26 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: 2024.07.26 03:42 Ctc Ctc_Id First Name Surname T FS Cir Dst Pr ----- --------- ------------------------- ----------------------------------- - -- --- --- -- 99060 1.079E+09 PIERRE LAMONTAGNE F 10 1 row selected.