2026-02-11 09:48:18,116 - 11804 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-02-11 09:48:18,180 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('122749R', '122752R', '122751R', '122750R')... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:18,549 - 11804 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-11 09:48:18,619 - 11804 - 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 = 23459 and sm.IsActive =1 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:18,978 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:19,043 - 11804 - 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 = 23459 and sm.IsActive =1 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:19,397 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:19,461 - 11804 - 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 = 23459 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:19,811 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:19,909 - 11804 - 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 = 23459 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:20,260 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:20,333 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 23459;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:20,738 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:20,800 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,
AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 23459;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:21,153 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:21,218 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 23459;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:21,574 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:21,633 - 11804 - src.utils.log - INFO - Parallel Insertion in invoice tables begin - __SPLIT__
2026-02-11 09:48:21,692 - 11804 - src.utils.log - INFO - 📥 Inserting into Billing.AccountDiscountSetup: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-12_0) - __SPLIT__
2026-02-11 09:48:21,693 - 11804 - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 4 rows in batches of 25000 (Thread: ThreadPoolExecutor-12_1) - __SPLIT__
2026-02-11 09:48:21,693 - 11804 - src.utils.log - INFO - 📥 Inserting into Billing.DiscountApplied: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-12_2) - __SPLIT__
2026-02-11 09:48:22,038 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into Billing.AccountDiscountSetup in 0 batches - __SPLIT__
2026-02-11 09:48:22,112 - 11804 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into Billing.InvoiceCharges - __SPLIT__
2026-02-11 09:48:22,113 - 11804 - src.utils.log - INFO - Insert success for table: Billing.AccountDiscountSetup - __SPLIT__
2026-02-11 09:48:22,168 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into Billing.DiscountApplied in 0 batches - __SPLIT__
2026-02-11 09:48:22,320 - 11804 - src.utils.log - INFO - Insert success for table: Billing.DiscountApplied - __SPLIT__
2026-02-11 09:48:23,187 - 11804 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-02-11 09:48:23,249 - 11804 - src.utils.log - INFO - Insert success for table: Billing.InvoiceCharges - __SPLIT__
2026-02-11 09:48:23,313 - 11804 - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-02-11 09:48:23,372 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE
CompanyKey = 'Fortive';... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:23,718 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:23,782 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a
WHERE a.AccountNo = '5871' and a.CompanyId = 124;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:24,187 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:24,245 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:24,779 - 11804 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-02-11 09:48:26,099 - 11804 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-02-11 09:48:26,308 - 11804 - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-02-11 09:48:26,373 - 11804 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.ServiceSetup SET IsInitialWoGenerated = 1
WHERE CompanyId = 135 AND
ServiceSetupId = 23459;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:26,741 - 11804 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-02-11 09:48:26,805 - 11804 - src.utils.log - INFO - 🔍 Fetching data:
SELECT WorkorderId, WorkOrderNo
FROM ServiceCore.WorkOrder wo
WHERE wo.WorkOrderNo IN ('122749R', '122750R', '122751R', '122752R')
AND wo.AccountNumber = '5871'
AND wo.CompanyId = 135
... (Thread: ThreadPoolExecutor-13_0) - __SPLIT__
2026-02-11 09:48:27,189 - 11804 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-11 09:48:27,258 - 11804 - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-02-11 09:48:27,338 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
cm WHERE CompanyId = 135;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:27,680 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:27,742 - 11804 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 135 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:28,086 - 11804 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-11 09:48:28,152 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:28,526 - 11804 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-02-11 09:48:29,814 - 11804 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-02-11 09:48:29,875 - 11804 - src.utils.log - INFO - 🔍 Fetching data:
SELECT
WorkOrderAutoGenerationPublishHistoryId,
WorkOrderNo,
ServiceSetupId
FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
WHERE
ServiceSetupId = 23459 AND WorkOrderNo IN (799007, 9852796, 8920509, 3858560) AND GenerateWorkOrderHistoryId = 11804;... (Thread: ThreadPoolExecutor-14_0) - __SPLIT__
2026-02-11 09:48:30,255 - 11804 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-11 09:48:30,321 - 11804 - src.utils.log - INFO - 🏁 Final merged rows: 4 - __SPLIT__
2026-02-11 09:48:30,458 - 11804 - src.utils.log - INFO - Parallel Insertion in work order tables begin - __SPLIT__
2026-02-11 09:48:30,533 - 11804 - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_0) - __SPLIT__
2026-02-11 09:48:30,534 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderAppliedDiscount: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_1) - __SPLIT__
2026-02-11 09:48:30,535 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderSalesPersonCommission: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_2) - __SPLIT__
2026-02-11 09:48:30,535 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderCommissionAdjustment: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_3) - __SPLIT__
2026-02-11 09:48:30,535 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 4 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_4) - __SPLIT__
2026-02-11 09:48:30,535 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrder: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_5) - __SPLIT__
2026-02-11 09:48:30,536 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 3 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_6) - __SPLIT__
2026-02-11 09:48:30,536 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkorderSourceMapping: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_7) - __SPLIT__
2026-02-11 09:48:30,536 - 11804 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 0 rows in batches of 25000 (Thread: ThreadPoolExecutor-15_8) - __SPLIT__
2026-02-11 09:48:30,905 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-02-11 09:48:30,963 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderAppliedDiscount in 0 batches - __SPLIT__
2026-02-11 09:48:31,025 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderSalesPersonCommission in 0 batches - __SPLIT__
2026-02-11 09:48:31,105 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderCommissionAdjustment in 0 batches - __SPLIT__
2026-02-11 09:48:31,171 - 11804 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderServices - __SPLIT__
2026-02-11 09:48:31,219 - 11804 - src.utils.log - INFO - [OK] Lead Notes completed. - __SPLIT__
2026-02-11 09:48:31,237 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SubWorkOrder in 0 batches - __SPLIT__
2026-02-11 09:48:31,305 - 11804 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-02-11 09:48:31,364 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkorderSourceMapping in 0 batches - __SPLIT__
2026-02-11 09:48:31,586 - 11804 - src.utils.log - INFO - [OK] Discount Applied completed. - __SPLIT__
2026-02-11 09:48:31,958 - 11804 - src.utils.log - INFO - [OK] Sales Person Commission completed. - __SPLIT__
2026-02-11 09:48:32,017 - 11804 - src.utils.log - INFO - [OK] Adjustment completed. - __SPLIT__
2026-02-11 09:48:32,099 - 11804 - src.utils.log - INFO - [OK] Sub WO completed. - __SPLIT__
2026-02-11 09:48:32,166 - 11804 - src.utils.log - INFO - [OK] Source Mapping completed. - __SPLIT__
2026-02-11 09:48:32,315 - 11804 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 0 batches - __SPLIT__
2026-02-11 09:48:32,405 - 11804 - src.utils.log - INFO - [OK] Publish Services completed. - __SPLIT__
2026-02-11 09:48:32,544 - 11804 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-02-11 09:48:32,608 - 11804 - src.utils.log - INFO - [OK] Services completed. - __SPLIT__
2026-02-11 09:48:32,787 - 11804 - src.utils.log - INFO - ✅ All 3 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-02-11 09:48:32,855 - 11804 - src.utils.log - INFO - [OK] Crew completed. - __SPLIT__
2026-02-11 09:48:32,918 - 11804 - src.utils.log - INFO - All publish tasks completed successfully. - __SPLIT__
2026-02-11 09:48:32,986 - 11804 - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-02-11 09:48:33,051 - 11804 - src.utils.log - INFO - 🔍 Fetching data:
SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 11804
GROUP BY ServiceSetupId;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:33,414 - 11804 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-11 09:48:33,484 - 11804 - src.utils.log - INFO - 🔄 Updating next gen date parallely: inside update_next_workorder_generation - __SPLIT__
2026-02-11 09:48:33,694 - 11804 - src.utils.log - INFO - 🛠 Creating temp table #tbl_9d9d406797 - __SPLIT__
2026-02-11 09:48:33,901 - 11804 - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_9d9d406797 - __SPLIT__
2026-02-11 09:48:34,531 - 11804 - src.utils.log - INFO - 🔁 Running UPDATE to apply changes - __SPLIT__
2026-02-11 09:48:34,904 - 11804 - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-02-11 09:48:34,974 - 11804 - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_9d9d406797 - __SPLIT__
2026-02-11 09:48:35,096 - 11804 - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 11804
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:35,465 - 11804 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-11 09:48:35,530 - 11804 - src.utils.log - INFO - Work order published ids: (0, 1, 2, 3) - __SPLIT__
2026-02-11 09:48:35,595 - 11804 - src.utils.log - INFO - Time took to perform operation in publishing 11804: 39.63 - __SPLIT__
2026-02-11 09:48:35,659 - 11804 - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: 11804 - __SPLIT__
2026-02-11 09:48:35,720 - 11804 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-02-11 04:48:35.530' WHERE CompanyId = 135 AND
GenerateWorkOrderHistoryId = 11804;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-11 09:48:36,064 - 11804 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__