2026-07-21 08:47:19,821 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:19,888 - [12703] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.subWorkOrderIssue: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:20,265 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into ServiceAuto.subWorkOrderIssue - __SPLIT__
2026-07-21 08:47:21,216 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into ServiceAuto.subWorkOrderIssue in 1 batches - __SPLIT__
2026-07-21 08:47:21,278 - [12703] - src.utils.log - INFO - 🔍 Fetching data: Select SubWorkOrderIssueId, SubWorkOrderId, ModifiedBy From ServiceAuto.subWorkOrderIssue
where SubWorkOrderId in (82368, 82370, 82369) and ModifiedBy in ('999999999', '1000000000', '1000000001')... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:21,622 - [12703] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-07-21 08:47:21,694 - [12703] - src.utils.log - INFO - 📝 Executing:
UPDATE ServiceAuto.subWorkOrderIssue
SET ModifiedBy = 'Fortive'
WHERE ModifiedBy IN ('999999999', '1000000000', '1000000001');
... (Thread: ThreadPoolExecutor-86_0) - __SPLIT__
2026-07-21 08:47:22,421 - [12703] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-07-21 08:47:22,495 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:22,570 - [12703] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.subWOIssueRepair: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:22,944 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into ServiceAuto.subWOIssueRepair - __SPLIT__
2026-07-21 08:47:23,871 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into ServiceAuto.subWOIssueRepair in 1 batches - __SPLIT__
2026-07-21 08:47:23,941 - [12703] - src.utils.log - INFO - 🔍 Fetching data: Select IssueRepairId, ModifiedBy From
ServiceAuto.subWOIssueRepair where SubWorkOrderIssueId in (148161, 148162, 148163)... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:24,289 - [12703] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-07-21 08:47:24,358 - [12703] - src.utils.log - INFO - 📝 Executing:
UPDATE ServiceAuto.subWOIssueRepair
SET ModifiedBy = 'Fortive'
WHERE ModifiedBy IN ('0___TMP___148161', '0___TMP___148162', '0___TMP___148163')
AND CreatedDate = '2026-07-21 04:47:19.819';
... (Thread: ThreadPoolExecutor-87_0) - __SPLIT__
2026-07-21 08:47:24,708 - [12703] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-07-21 08:47:24,785 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:24,852 - [12703] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.SubWOIssueRepairLabor: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:25,220 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into ServiceAuto.SubWOIssueRepairLabor - __SPLIT__
2026-07-21 08:47:26,282 - [12703] - src.utils.log - INFO - ✅ All 6 rows inserted successfully into ServiceAuto.SubWOIssueRepairLabor in 1 batches - __SPLIT__
2026-07-21 08:47:26,356 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:26,422 - [12703] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.SubWOIssueRepairPart: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:26,801 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into ServiceAuto.SubWOIssueRepairPart - __SPLIT__
2026-07-21 08:47:27,873 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into ServiceAuto.SubWOIssueRepairPart in 1 batches - __SPLIT__
2026-07-21 08:47:27,939 - [12703] - 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 = 34443... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:28,300 - [12703] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-07-21 08:47:28,371 - [12703] - src.utils.log - INFO - Size of Transaction: 3 - __SPLIT__
2026-07-21 08:47:28,481 - [12703] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:28,989 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-07-21 08:47:30,041 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-07-21 08:47:30,262 - [12703] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-07-21 08:47:30,336 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911, 12345678912) and t.CompanyId = 135 AND
t.TransactionType ='Invoice' AND t.CreatedDate = '2026-07-21 04:47:28.367';... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:30,707 - [12703] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-07-21 08:47:30,771 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 34443;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:31,119 - [12703] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-07-21 08:47:31,194 - [12703] - src.utils.log - INFO - 📝 Executing:
UPDATE Billing.[Transaction]
SET ModifiedBy = NULL
WHERE ModifiedBy IN (12345678910,12345678911,12345678912)
AND CreatedDate = '2026-07-21 04:47:28.367';
... (Thread: ThreadPoolExecutor-88_0) - __SPLIT__
2026-07-21 08:47:31,559 - [12703] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-07-21 08:47:31,633 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:31,701 - [12703] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:32,068 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Invoice - __SPLIT__
2026-07-21 08:47:33,125 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-07-21 08:47:33,183 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('169432R', '169434R', '169433R')... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:33,557 - [12703] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-07-21 08:47:33,638 - [12703] - 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 = 34443 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:33,985 - [12703] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-07-21 08:47:34,043 - [12703] - 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 = 34443 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:34,381 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:34,501 - [12703] - 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 = 34443 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:34,858 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:34,929 - [12703] - 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 = 34443 and sss.IsDeleted =0; ... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:35,278 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:35,363 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 34443;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:35,723 - [12703] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-07-21 08:47:35,793 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,
AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 34443;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:36,138 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:36,217 - [12703] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 34443;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:36,570 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:36,629 - [12703] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-07-21 08:47:36,700 - [12703] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-07-21 08:47:36,767 - [12703] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-07-21 08:47:36,841 - [12703] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:37,223 - [12703] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.InvoiceCharges - __SPLIT__
2026-07-21 08:47:38,289 - [12703] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-07-21 08:47:38,356 - [12703] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-07-21 08:47:38,416 - [12703] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-07-21 08:47:38,486 - [12703] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-07-21 08:47:38,557 - [12703] - src.utils.log - INFO - 🔍 Fetching data:
SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 12703
GROUP BY ServiceSetupId;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:38,965 - [12703] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-07-21 08:47:39,036 - [12703] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-07-21 08:47:39,237 - [12703] - src.utils.log - INFO - 🛠 Creating temp table #tbl_c41ffbf1b7 - __SPLIT__
2026-07-21 08:47:39,586 - [12703] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_c41ffbf1b7 - __SPLIT__
2026-07-21 08:47:39,940 - [12703] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-07-21 08:47:40,149 - [12703] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-07-21 08:47:40,356 - [12703] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_c41ffbf1b7 - __SPLIT__
2026-07-21 08:47:40,427 - [12703] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_c41ffbf1b7 - __SPLIT__
2026-07-21 08:47:40,493 - [12703] - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 12703
(Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:40,843 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:40,907 - [12703] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-07-21 08:47:40,994 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:41,361 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:41,432 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:41,790 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:41,851 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:42,201 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:42,268 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:42,648 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:42,707 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:43,125 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:43,222 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:43,578 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:43,651 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:44,002 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:44,069 - [12703] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (2737894, 2737895, 2737896) (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:44,445 - [12703] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-07-21 08:47:44,514 - [12703] - src.utils.log - INFO - Work order published ids: (2737894, 2737895, 2737896) - __SPLIT__
2026-07-21 08:47:44,583 - [12703] - src.utils.log - INFO - Time took to perform operation in publishing [12703]: 48.46 - __SPLIT__
2026-07-21 08:47:44,660 - [12703] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [12703] - __SPLIT__
2026-07-21 08:47:44,734 - [12703] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-07-21 04:47:44.514' WHERE CompanyId = 135 AND
GenerateWorkOrderHistoryId = 12703;... (Thread: AnyIO worker thread) - __SPLIT__
2026-07-21 08:47:45,092 - [12703] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__