2026-06-08 16:47:30,301 - [25822] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderAppliedDiscount: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:31,051 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into ServiceAuto.WorkOrderAppliedDiscount - __SPLIT__
2026-06-08 16:47:31,833 - [25822] - src.utils.log - INFO - ✅ All 8 rows inserted successfully into ServiceAuto.WorkOrderAppliedDiscount in 1 batches - __SPLIT__
2026-06-08 16:47:32,503 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:47:33,168 - [25822] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderSalesPersonCommission: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:33,888 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderSalesPersonCommission - __SPLIT__
2026-06-08 16:47:34,665 - [25822] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderSalesPersonCommission in 1 batches - __SPLIT__
2026-06-08 16:47:35,336 - [25822] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-06-08 16:47:36,006 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:47:36,676 - [25822] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 57 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:37,399 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 57) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-06-08 16:47:38,259 - [25822] - src.utils.log - INFO - ✅ All 57 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-06-08 16:47:38,929 - [25822] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkorderSourceMapping: - __SPLIT__
2026-06-08 16:47:39,599 - [25822] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-06-08 16:47:40,270 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:47:40,943 - [25822] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 79 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:41,673 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 79) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-06-08 16:47:42,656 - [25822] - src.utils.log - INFO - ✅ All 79 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-06-08 16:47:43,330 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT ss.ServiceSetupId as SetupId, ss.FrequencyScheduleId as setup_frequency_schedule_id, ss.AccountNumber, ss.CompanyId, 
        ss.BillingLocationId, ss.ServiceLocationId, ss.TaxSysName, ss.TermId,  ss.TaxPercent, ss.PoNumber, ss.IsTaxExempt,
        ss.DisplayServiceAsSeparateLineItem, ss.GenerateInvoice, ss.IsGenerateInvoiceforInitalSetup, 
        ss.IsGenerateInvoiceforInitalSetupBilling, ss.IsBilling, t.NetDueIn, ptm.PaymentType, ssb.* 
        FROM ServiceCore.ServiceSetup ss LEFT JOIN ServiceCore.ServiceSetupBilling ssb 
        ON ss.ServiceSetupId = ssb.ServiceSetupId LEFT JOIN Billing.PaymentTypeMaster ptm ON 
        ptm.PaymentTypeMasterId = ssb.PaymentTypeMasterId left join Billing.Term t on ss.TermId = t.TermId 
        WHERE ss.ServiceSetupId in (67126, 64670, 67189, 67424, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67121, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 52672, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149)... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:44,025 - [25822] - src.utils.log - INFO - ✅ Fetched 48 rows - __SPLIT__
2026-06-08 16:47:44,988 - [25822] - src.utils.log - INFO - Size of Transaction: 47 - __SPLIT__
2026-06-08 16:47:45,664 - [25822] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 47 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:46,396 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 47) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-06-08 16:47:47,479 - [25822] - src.utils.log - INFO - ✅ All 47 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-06-08 16:47:48,166 - [25822] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-06-08 16:47:48,837 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911, 12345678912, 12345678913, 12345678914, 12345678915, 12345678916, 12345678917, 12345678918, 12345678919, 12345678920, 12345678921, 12345678922, 12345678923, 12345678924, 12345678925, 12345678926, 12345678927, 12345678928, 12345678929, 12345678930, 12345678931, 12345678932, 12345678933, 12345678934, 12345678935, 12345678936, 12345678937, 12345678938, 12345678939, 12345678940, 12345678941, 12345678942, 12345678943, 12345678944, 12345678945, 12345678946, 12345678947, 12345678948, 12345678949, 12345678950, 12345678951, 12345678952, 12345678953, 12345678954, 12345678955, 12345678956)  and t.CompanyId = 133 AND 
        t.TransactionType ='Invoice' AND t.CreatedDate = '2026-06-08 12:47:44.983';... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:49,897 - [25822] - src.utils.log - INFO - ✅ Fetched 47 rows - __SPLIT__
2026-06-08 16:47:50,570 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  in (22493, 28281, 37149, 52672, 53197, 53880, 63779, 64670, 65476, 67114, 67118, 67121, 67126, 67142, 67146, 67149, 67173, 67175, 67181, 67182, 67183, 67184, 67189, 67194, 67196, 67219, 67225, 67232, 67233, 67239, 67241, 67256, 67259, 67266, 67270, 67282, 67286, 67313, 67322, 67330, 67344, 67367, 67391, 67394, 67402, 67424, 67426, 67437);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:51,308 - [25822] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-08 16:47:51,980 - [25822] - src.utils.log - INFO - 📝 Executing: 
                    UPDATE Billing.[Transaction]
                    SET ModifiedBy = NULL
                    WHERE ModifiedBy IN (12345678910,12345678911,12345678912,12345678913,12345678914,12345678915,12345678916,12345678917,12345678918,12345678919,12345678920,12345678921,12345678922,12345678923,12345678924,12345678925,12345678926,12345678927,12345678928,12345678929,12345678930,12345678931,12345678932,12345678933,12345678934,12345678935,12345678936,12345678937,12345678938,12345678939,12345678940,12345678941,12345678942,12345678943,12345678944,12345678945,12345678946,12345678947,12345678948,12345678949,12345678950,12345678951,12345678952,12345678953,12345678954,12345678955,12345678956)
                    AND CreatedDate = '2026-06-08 12:47:44.983';
                ... (Thread: ThreadPoolExecutor-12_0) - __SPLIT__
2026-06-08 16:47:53,024 - [25822] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-08 16:47:53,722 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:47:54,394 - [25822] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 47 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:55,112 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 47) into Billing.Invoice - __SPLIT__
2026-06-08 16:47:55,973 - [25822] - src.utils.log - INFO - ✅ All 47 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-06-08 16:47:56,646 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('516072', '516084', '516073', '516082', '516077', '516104', '516081', '516115', '516071', '516112', '516097', '516117', '516111', '516089', '516069', '516100', '516095', '516102', '516119', '516086', '516079', '516076', '516065', '516116', '516075', '516101', '516114', '516107', '516070', '516098', '516099', '516092', '516068', '516067', '516083', '516108', '516090', '516110', '516087', '516105', '516088', '516103', '516091', '516093', '516109', '516113', '516096')... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:47:59,355 - [25822] - src.utils.log - INFO - ✅ Fetched 47 rows - __SPLIT__
2026-06-08 16:48:00,031 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.Name as  NonStandardServiceName, sm.Description , sm.ServiceMasterId as ServiceId
        FROM ServiceCore.ServiceSetupServices sss join ServiceCore.ServiceMaster sm on sm.ServiceMasterId = sss.ServiceId 
        where ServiceSetupId in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149) and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:00,729 - [25822] - src.utils.log - INFO - ✅ Fetched 64 rows - __SPLIT__
2026-06-08 16:48:01,408 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.Name as  NonStandardServiceName, sm.Description , sm.ServiceMasterId as ServiceId
        FROM ServiceCore.ServiceSetupInitialServices sss join ServiceCore.ServiceMaster sm on sm.ServiceMasterId = sss.ServiceId 
        where ServiceSetupId in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149) and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:02,433 - [25822] - src.utils.log - INFO - ✅ Fetched 40 rows - __SPLIT__
2026-06-08 16:48:03,116 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.servicename as  NonStandardServiceName, sm.Description , sss.ServiceId
        FROM ServiceCore.ServiceSetupServices sss join ServiceCore.SoldServiceNonStandard sm on sm.SoldServiceNonStandardId = sss.NonStdSoldServiceId 
        where ServiceSetupId in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149)  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:03,827 - [25822] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-08 16:48:04,508 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.servicename as  NonStandardServiceName, sm.Description , sss.ServiceId
        FROM ServiceCore.ServiceSetupInitialServices sss join ServiceCore.SoldServiceNonStandard sm on sm.SoldServiceNonStandardId = sss.NonStdSoldServiceId 
        where ServiceSetupId in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149)  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:05,230 - [25822] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-08 16:48:05,917 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:06,627 - [25822] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-08 16:48:07,314 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId, 
        AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId  from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:08,025 - [25822] - src.utils.log - INFO - ✅ Fetched 11 rows - __SPLIT__
2026-06-08 16:48:08,713 - [25822] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
        IsDiscountPercent,DiscountPercent,DiscountDescription, ServiceSetupId from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId  in (67189, 67266, 67259, 67181, 67233, 67118, 22493, 37149, 67196, 53880, 65476, 53197, 67270, 28281, 67322, 67344, 67175, 67286, 67391, 67256, 67394, 67183, 67437, 67146, 67239, 67241, 67182, 67219, 67184, 67367, 63779, 67330, 67232, 67282, 67402, 67313, 67173, 67142, 67426, 67225, 67114, 67194, 67149);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:09,440 - [25822] - src.utils.log - INFO - ✅ Fetched 11 rows - __SPLIT__
2026-06-08 16:48:10,131 - [25822] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-06-08 16:48:10,810 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:48:11,491 - [25822] - src.utils.log - INFO - 📥 Inserting into Billing.AccountDiscountSetup: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:12,232 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into Billing.AccountDiscountSetup - __SPLIT__
2026-06-08 16:48:13,032 - [25822] - src.utils.log - INFO - ✅ All 6 rows inserted successfully into Billing.AccountDiscountSetup in 1 batches - __SPLIT__
2026-06-08 16:48:13,709 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:48:14,381 - [25822] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 68 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:15,112 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 68) into Billing.InvoiceCharges - __SPLIT__
2026-06-08 16:48:15,999 - [25822] - src.utils.log - INFO - ✅ All 68 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-06-08 16:48:16,976 - [25822] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-08 16:48:17,651 - [25822] - src.utils.log - INFO - 📥 Inserting into Billing.DiscountApplied: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:18,383 - [25822] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into Billing.DiscountApplied - __SPLIT__
2026-06-08 16:48:19,166 - [25822] - src.utils.log - INFO - ✅ All 6 rows inserted successfully into Billing.DiscountApplied in 1 batches - __SPLIT__
2026-06-08 16:48:19,846 - [25822] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-06-08 16:48:20,525 - [25822] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-06-08 16:48:21,262 - [25822] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 25822
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:21,967 - [25822] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-08 16:48:22,648 - [25822] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-06-08 16:48:23,368 - [25822] - src.utils.log - INFO - 🛠 Creating temp table #tbl_bb63a13579 - __SPLIT__
2026-06-08 16:48:24,076 - [25822] - src.utils.log - INFO - 📌 Bulk inserting 48 rows into #tbl_bb63a13579 - __SPLIT__
2026-06-08 16:48:25,335 - [25822] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-06-08 16:48:26,032 - [25822] - src.utils.log - INFO - ✔ SQL reported affected rows: 48 - __SPLIT__
2026-06-08 16:48:26,725 - [25822] - src.utils.log - INFO - 🔍 Verified successfully updated 48 rows via #tbl_bb63a13579 - __SPLIT__
2026-06-08 16:48:27,406 - [25822] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_bb63a13579 - __SPLIT__
2026-06-08 16:48:28,090 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 25822
               (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:28,793 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:29,471 - [25822] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-06-08 16:48:30,166 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:30,878 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:31,844 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:32,550 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:33,252 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:33,958 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:34,639 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:35,438 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:36,117 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:36,863 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:37,542 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:38,253 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:38,931 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:39,646 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:40,327 - [25822] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:41,221 - [25822] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-08 16:48:41,899 - [25822] - src.utils.log - INFO - Work order published ids: (678345, 678346, 678347, 678348, 678349, 678350, 678351, 678352, 678353, 678354, 678355, 678356, 678357, 678358, 678359, 678360, 678361, 678362, 678363, 678364, 678365, 678366, 678367, 678368, 678369, 678370, 678371, 678372, 678373, 678374, 678375, 678376, 678377, 678378, 678379, 678380, 678381, 678382, 678383, 678384, 678385, 678386, 678387, 678388, 678389, 678390, 678391, 678392, 678393, 678394, 678395, 678396, 678397, 678398, 678399, 678400, 678401) - __SPLIT__
2026-06-08 16:48:42,576 - [25822] - src.utils.log - INFO - Time took to perform operation in publishing [25822]: 129.51 - __SPLIT__
2026-06-08 16:48:43,253 - [25822] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [25822] - __SPLIT__
2026-06-08 16:48:43,934 - [25822] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-06-08 12:48:41.898' WHERE CompanyId = 133 AND 
                        GenerateWorkOrderHistoryId = 25822;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-08 16:48:44,642 - [25822] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__