2026-09-21 13:16:35,925 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
cm WHERE CompanyId = 135;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:36,280 - [12868] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-09-21 13:16:36,310 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 135 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:36,671 - [12868] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-09-21 13:16:36,707 - [12868] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-09-21 13:16:36,737 - [12868] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:37,118 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-09-21 13:16:38,437 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-09-21 13:16:38,467 - [12868] - src.utils.log - INFO - 🔍 Fetching data:
SELECT
WorkOrderAutoGenerationPublishHistoryId,
WorkOrderNo,
ServiceSetupId
FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
WHERE
ServiceSetupId = 34534 AND WorkOrderNo IN ('5131141', '6265506', '7152321', '8387991', '4485421', '3015915', '9962812', '3130077', '9466878', '1013584', '4044597', '6590143', '6057461', '6280725', '5540841', '8047822', '5545927', '1347911', '7716276', '7212461', '8040994', '4844077', '9870802', '4248508', '8341403', '8763902') AND GenerateWorkOrderHistoryId = 12868;... (Thread: ThreadPoolExecutor-8_0) - __SPLIT__
2026-09-21 13:16:38,850 - [12868] - src.utils.log - INFO - ✅ Fetched 26 rows - __SPLIT__
2026-09-21 13:16:38,883 - [12868] - src.utils.log - INFO - 🏁 Final merged rows: 26 - __SPLIT__
2026-09-21 13:16:38,915 - [12868] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-09-21 13:16:38,948 - [12868] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-09-21 13:16:38,982 - [12868] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:39,350 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into ServiceCore.WorkOrderServices - __SPLIT__
2026-09-21 13:16:40,583 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-09-21 13:16:40,608 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderAppliedDiscount: - __SPLIT__
2026-09-21 13:16:40,636 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderSalesPersonCommission: - __SPLIT__
2026-09-21 13:16:40,664 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-09-21 13:16:40,696 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderCrew: - __SPLIT__
2026-09-21 13:16:40,726 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkorderSourceMapping: - __SPLIT__
2026-09-21 13:16:40,756 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-09-21 13:16:40,782 - [12868] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-09-21 13:16:40,808 - [12868] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:41,172 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-09-21 13:16:42,401 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-09-21 13:16:42,431 - [12868] - 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 = 34534... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:42,787 - [12868] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-09-21 13:16:42,823 - [12868] - src.utils.log - INFO - Size of Transaction: 26 - __SPLIT__
2026-09-21 13:16:42,854 - [12868] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:43,387 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-09-21 13:16:44,608 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-09-21 13:16:44,796 - [12868] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-09-21 13:16:44,828 - [12868] - 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) and t.CompanyId = 135 AND
t.TransactionType ='Invoice' AND t.CreatedDate = '2026-09-21 09:16:42.818';... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:45,226 - [12868] - src.utils.log - INFO - ✅ Fetched 26 rows - __SPLIT__
2026-09-21 13:16:45,260 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 34534;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:45,617 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:45,654 - [12868] - 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)
AND CreatedDate = '2026-09-21 09:16:42.818';
... (Thread: ThreadPoolExecutor-9_0) - __SPLIT__
2026-09-21 13:16:46,058 - [12868] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-09-21 13:16:46,085 - [12868] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:46,455 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into Billing.Invoice - __SPLIT__
2026-09-21 13:16:47,688 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-09-21 13:16:47,722 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('199280R', '199279R', '199278R', '199277R', '199276R', '199275R', '199274R', '199273R', '199272R', '199271R', '199270R', '199269R', '199268R', '199267R', '199266R', '199265R', '199264R', '199263R', '199262R', '199261R', '199260R', '199259R', '199258R', '199257R', '199256R', '199255R')... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:48,214 - [12868] - src.utils.log - INFO - ✅ Fetched 26 rows - __SPLIT__
2026-09-21 13:16:48,299 - [12868] - 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 = 34534 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:48,656 - [12868] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-09-21 13:16:48,680 - [12868] - 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 = 34534 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:49,032 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:49,062 - [12868] - 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 = 34534 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:49,419 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:49,443 - [12868] - 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 = 34534 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:49,801 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:49,837 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 34534;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:50,195 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:50,223 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,
AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 34534;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:50,581 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:50,612 - [12868] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 34534;... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:50,965 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:50,988 - [12868] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-09-21 13:16:51,015 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-09-21 13:16:51,042 - [12868] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-09-21 13:16:51,070 - [12868] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 26 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:51,436 - [12868] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 26) into Billing.InvoiceCharges - __SPLIT__
2026-09-21 13:16:52,664 - [12868] - src.utils.log - INFO - ✅ All 26 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-09-21 13:16:52,691 - [12868] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-09-21 13:16:52,718 - [12868] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-09-21 13:16:52,745 - [12868] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-09-21 13:16:52,770 - [12868] - src.utils.log - INFO - 🔍 Fetching data:
SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 12868
GROUP BY ServiceSetupId;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:53,123 - [12868] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-09-21 13:16:53,157 - [12868] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-09-21 13:16:53,351 - [12868] - src.utils.log - INFO - 🛠 Creating temp table #tbl_ac08a85884 - __SPLIT__
2026-09-21 13:16:53,709 - [12868] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_ac08a85884 - __SPLIT__
2026-09-21 13:16:54,063 - [12868] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-09-21 13:16:54,263 - [12868] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-09-21 13:16:54,455 - [12868] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_ac08a85884 - __SPLIT__
2026-09-21 13:16:54,481 - [12868] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_ac08a85884 - __SPLIT__
2026-09-21 13:16:54,510 - [12868] - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 12868
(Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:54,863 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:54,886 - [12868] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-09-21 13:16:54,915 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:55,299 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:55,323 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:55,699 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:55,726 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:56,087 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:56,118 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:56,533 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:56,561 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:56,950 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:56,978 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:57,337 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:57,361 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:57,721 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:57,747 - [12868] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) (Thread: AnyIO worker thread) - __SPLIT__
2026-09-21 13:16:58,288 - [12868] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-09-21 13:16:58,312 - [12868] - src.utils.log - INFO - Work order published ids: (2772018, 2772019, 2772020, 2772021, 2772022, 2772023, 2772024, 2772025, 2772026, 2772027, 2772028, 2772029, 2772030, 2772031, 2772032, 2772033, 2772034, 2772035, 2772036, 2772037, 2772038, 2772039, 2772040, 2772041, 2772042, 2772043) - __SPLIT__
2026-09-21 13:16:58,335 - [12868] - src.utils.log - INFO - Time took to perform operation in publishing [12868]: 36.64 - __SPLIT__
2026-09-21 13:16:58,362 - [12868] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [12868] - __SPLIT__
2026-09-21 13:16:58,395 - [12868] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-09-21 09:16:58.312' WHERE CompanyId = 135 AND
GenerateWorkOrderHistoryId = 12868;... (Thread: AnyIO worker thread) - __SPLIT__