2026-01-28 11:10:06,116 - 11758 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-28 11:10:06,185 - 11758 - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (23224, 23296, 23299, 23294)
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:06,897 - 11758 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-28 11:10:06,959 - 11758 - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (23224, 23296, 23299, 23294)
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:07,512 - 11758 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-28 11:10:07,579 - 11758 - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (23224, 23296, 23299, 23294)
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:07,950 - 11758 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-28 11:10:08,013 - 11758 - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (23224, 23296, 23299, 23294)
(Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:08,615 - 11758 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-28 11:10:08,678 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 28 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:09,100 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 28) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-01-28 11:10:11,534 - 11758 - src.utils.log - INFO - ✅ All 28 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-01-28 11:10:11,599 - 11758 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 28 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-01-13 12:12:47.836'
and ServiceSetupId in (23224, 23296, 23299, 23294)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:12,008 - 11758 - src.utils.log - INFO - ✅ Fetched 28 rows - __SPLIT__
2026-01-28 11:10:12,078 - 11758 - src.utils.log - INFO - Id's of work order inserted to DB: [2662796 2662797 2662798 2662799 2662800 2662801 2662802 2662803 2662804
2662805 2662806 2662807 2662808 2662809 2662810 2662811 2662812 2662813
2662814 2662815 2662816 2662817 2662818 2662819 2662820 2662821 2662822
2662823] - __SPLIT__
2026-01-28 11:10:12,143 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId in (23224, 23296, 23299, 23294);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:12,505 - 11758 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-28 11:10:12,564 - 11758 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-01-28 11:10:12,628 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
in (23296, 23299, 23294, 23224)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:12,982 - 11758 - src.utils.log - INFO - ✅ Fetched 6 rows - __SPLIT__
2026-01-28 11:10:13,047 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
in (23296, 23299, 23294, 23224)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:13,410 - 11758 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-01-28 11:10:13,546 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
in (23296, 23299, 23294, 23224)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:13,909 - 11758 - src.utils.log - INFO - ✅ Fetched 6 rows - __SPLIT__
2026-01-28 11:10:13,980 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where
ServiceSetupId in (23296, 23299, 23294, 23224)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:14,342 - 11758 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-28 11:10:14,402 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where
ServiceSetupId in (23296, 23299, 23294, 23224)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:14,795 - 11758 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-28 11:10:14,871 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE
ServiceSetupId in (23296, 23299, 23294, 23224);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:15,235 - 11758 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-01-28 11:10:15,307 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE
ServiceSetupId in (23296, 23299, 23294, 23224);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:15,687 - 11758 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-01-28 11:10:15,763 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE
EntityType = 'Setup' AND ServiceSetupId in (23296, 23299, 23294, 23224);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:16,186 - 11758 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-28 11:10:16,254 - 11758 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId in (23296, 23299, 23294, 23224);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:16,631 - 11758 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-28 11:10:16,720 - 11758 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-01-28 11:10:16,802 - 11758 - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:17,197 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into CRM.LeadNote - __SPLIT__
2026-01-28 11:10:18,373 - 11758 - src.utils.log - INFO - ✅ All 8 rows inserted successfully into CRM.LeadNote in 1 batches - __SPLIT__
2026-01-28 11:10:18,473 - 11758 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-01-28 11:10:18,542 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.CommunicationPreferencesServiceReportNotification: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:18,969 - 11758 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.CommunicationPreferencesServiceReportNotification in 0 batches - __SPLIT__
2026-01-28 11:10:19,029 - 11758 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-01-28 11:10:19,100 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SetupAutoGenerationSourceMapping: 13 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:19,469 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 13) into ServiceCore.SetupAutoGenerationSourceMapping - __SPLIT__
2026-01-28 11:10:20,401 - 11758 - src.utils.log - INFO - ✅ All 13 rows inserted successfully into ServiceCore.SetupAutoGenerationSourceMapping in 1 batches - __SPLIT__
2026-01-28 11:10:20,467 - 11758 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-01-28 11:10:20,530 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationAppliedDiscount: 33 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:20,912 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 33) into ServiceCore.WorkOrderAutoGenerationAppliedDiscount - __SPLIT__
2026-01-28 11:10:22,198 - 11758 - src.utils.log - INFO - ✅ All 33 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationAppliedDiscount in 1 batches - __SPLIT__
2026-01-28 11:10:22,261 - 11758 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-01-28 11:10:22,325 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrderAutoGeneration: 5 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:22,713 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 5) into ServiceCore.SubWorkOrderAutoGeneration - __SPLIT__
2026-01-28 11:10:23,987 - 11758 - src.utils.log - INFO - ✅ All 5 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-01-28 11:10:24,056 - 11758 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-01-28 11:10:24,115 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:24,487 - 11758 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment in 0 batches - __SPLIT__
2026-01-28 11:10:24,559 - 11758 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-01-28 11:10:24,625 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:25,012 - 11758 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission in 0 batches - __SPLIT__
2026-01-28 11:10:25,073 - 11758 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-01-28 11:10:25,183 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 23 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:25,566 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 23) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-01-28 11:10:26,669 - 11758 - src.utils.log - INFO - ✅ All 23 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-01-28 11:10:26,791 - 11758 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-01-28 11:10:26,847 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:27,241 - 11758 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 0 batches - __SPLIT__
2026-01-28 11:10:27,304 - 11758 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-01-28 11:10:27,370 - 11758 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 41 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:27,751 - 11758 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 41) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-01-28 11:10:29,069 - 11758 - src.utils.log - INFO - ✅ All 41 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-01-28 11:10:29,135 - 11758 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-01-28 11:10:29,197 - 11758 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 11758;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:29,552 - 11758 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 11:10:29,609 - 11758 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-01-28 11:10:29,666 - 11758 - src.utils.log - INFO - Time took to perform operation: 35.61 - __SPLIT__
2026-01-28 11:10:29,730 - 11758 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 11758;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:30,081 - 11758 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 11:10:30,146 - 11758 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
WorkOrderStatusDateTime = '2026-01-28 06:10:30.145' WHERE
GenerateWorkOrderHistoryId = 11758;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 11:10:30,530 - 11758 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 12:56:29,720 - 13393 - src.utils.log - INFO - ParallelProcessing=False GenerateInvoiceHistoryId=13393 - __SPLIT__
2026-01-28 12:56:29,853 - 13393 - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-01-28 12:56:29,926 - 13393 - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE
CompanyKey = 'Fortive'... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:32,067 - 13393 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-28 12:56:32,131 - 13393 - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-01-28 12:56:32,204 - 13393 - src.utils.log - INFO - Sequential Invoice generation algo started for GenerateInvoiceHistoryId: 13393 - __SPLIT__
2026-01-28 12:56:32,270 - 13393 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
SET Status = 'InProgress' WHERE GenerateInvoiceHistoryId = 13393;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:32,651 - 13393 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 12:56:32,719 - 13393 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.GenerateInvoiceHistory WHERE
GenerateInvoiceHistoryId = 13393;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:33,087 - 13393 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-28 12:56:33,153 - 13393 - src.utils.log - INFO - 🔍 Fetching data:
SELECT sss.ServiceId as ServiceMasterId,ss.FrequencyScheduleId as setup_frequency_schedule_id, ssb.*, ss.IsBilling, ss.DepartmentMasterId, ss.AccountNumber, ss.CompanyId, ss.BillingLocationId,
ss.ServiceLocationId, ss.TaxSysName, ss.TermId, t.NetDueIn, ss.TaxPercent, ss.PoNumber,
ss.DisplayServiceAsSeparateLineItem, ss.SetupEndDate, ss.SetupStartDate from ServiceCore.ServiceSetup ss
join ServiceCore.ServiceSetupBilling ssb on ss.ServiceSetupId = ssb.ServiceSetupId join
Billing.PaymentTypeMaster ptm on ptm.PaymentTypeMasterId = ssb.PaymentTypeMasterId join Billing.Term t
on ss.TermId = t.TermId join ServiceCore.ServiceSetupServices sss on ss.ServiceSetupId = sss.ServiceSetupId
where ptm.PaymentType= 'Payment Plan' and ss.IsActive =1 and ss.CompanyId= 135
AND ss.IsDeleted =0 AND ss.Status <> 'Canceled'
and ss.AccountNumber = '1979' and ss.ServiceSetupId = 23299;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:33,518 - 13393 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-28 12:56:33,582 - 13393 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
SET Status = 'Completed' WHERE GenerateInvoiceHistoryId = 13393;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:33,946 - 13393 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 12:56:34,011 - 13393 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
SET InvoiceStatusDateTime = '2026-01-28 07:56:34.011' WHERE GenerateInvoiceHistoryId = 13393;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-28 12:56:34,365 - 13393 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-28 12:56:34,430 - 13393 - src.utils.log - INFO - 🔒 Connection pool closed - __SPLIT__
2026-01-28 12:56:34,496 - 13393 - src.utils.log - INFO - Error in Sequential Invoice Gen ProjectId:13393 - Time took: 4.64 - Error:No setups found for GenerateWorkOrderHistoryid: 13393 - __SPLIT__