2026-02-15 10:48:51,777 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE
CompanyKey = 'Samsung';... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:48:52,458 - [55906] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-15 10:48:53,111 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a
WHERE a.AccountNo = '2786' and a.CompanyId = 133;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:48:53,795 - [55906] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-15 10:48:54,442 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:48:55,169 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-02-15 10:48:55,967 - [55906] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-02-15 10:48:56,634 - [55906] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-02-15 10:48:57,291 - [55906] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.ServiceSetup SET IsInitialWoGenerated = 1
WHERE CompanyId = 145 AND
ServiceSetupId = 95377;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:48:57,975 - [55906] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-02-15 10:48:58,623 - [55906] - src.utils.log - INFO - 🔍 Fetching data:
SELECT WorkorderId, WorkOrderNo
FROM ServiceCore.WorkOrder wo
WHERE wo.WorkOrderNo IN ('222088', '222089')
AND wo.AccountNumber = '2786'
AND wo.CompanyId = 145
... (Thread: ThreadPoolExecutor-22_0) - __SPLIT__
2026-02-15 10:48:59,313 - [55906] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-02-15 10:48:59,958 - [55906] - src.utils.log - INFO - Sequential fetching temp table records - __SPLIT__
2026-02-15 10:49:00,609 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.WorkOrderAutoGenerationServices woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:01,626 - [55906] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-15 10:49:02,302 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SubWorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:03,023 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:03,717 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.WorkOrderAutoGenerationCrews woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:04,431 - [55906] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-02-15 10:49:05,111 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.WorkOrderAutoGenerationSalesPersonCommission woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:05,815 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:06,488 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupAutoGenerationSourceMapping woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:07,198 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:07,880 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT DiscountType, DiscountCode, DiscountAmount, DiscountDescription, DiscountName, IsActive,
CreatedBy, ModifiedBy, CreatedDate, ModifiedDate, DiscountPercent, IsDiscountPercent,
AppliedDiscountAmt, ApplyOnPartPrice, ApplyOnLaborPrice, DiscountSetupId, WorkOrderAutoGenerationId
from ServiceCore.WorkOrderAutoGenerationAppliedDiscount woag WHERE woag.WorkOrderAutoGenerationId
in (473157, 473158)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:08,585 - [55906] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-15 10:49:09,259 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from CRM.LeadNote woag WHERE woag.RefId in (473157, 473158) and
woag.RefType = 'TempWorkorder';... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:09,967 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:10,646 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment woagca
WHERE woagca.WorkOrderAutoGenerationId in (473157, 473158);... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:11,349 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:12,023 - [55906] - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-02-15 10:49:12,712 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
cm WHERE CompanyId = 145;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:13,415 - [55906] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-15 10:49:14,095 - [55906] - src.utils.log - INFO - 🔍 Fetching data: Select DiscountSetupId, [SysName] as DiscountSysName from Common.DiscountSetupMaster WHERE
DiscountSetupId IN (882, 881, 886) AND CompanyId = 145 AND IsActive = 1;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:14,803 - [55906] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-02-15 10:49:15,763 - [55906] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 145 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:16,460 - [55906] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-15 10:49:17,124 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:17,851 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-02-15 10:49:18,643 - [55906] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-02-15 10:49:19,307 - [55906] - src.utils.log - INFO - 🔍 Fetching data:
SELECT
WorkOrderAutoGenerationPublishHistoryId,
WorkOrderNo,
ServiceSetupId
FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
WHERE
ServiceSetupId = 95377 AND WorkOrderNo IN ('602142', '9074903') AND GenerateWorkOrderHistoryId = 55906;... (Thread: ThreadPoolExecutor-23_0) - __SPLIT__
2026-02-15 10:49:20,034 - [55906] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-02-15 10:49:20,692 - [55906] - src.utils.log - INFO - 🏁 Final merged rows: 2 - __SPLIT__
2026-02-15 10:49:21,360 - [55906] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-02-15 10:49:22,021 - [55906] - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:22,712 - [55906] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-02-15 10:49:23,375 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderAppliedDiscount: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:24,087 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceAuto.WorkOrderAppliedDiscount - __SPLIT__
2026-02-15 10:49:24,861 - [55906] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceAuto.WorkOrderAppliedDiscount in 1 batches - __SPLIT__
2026-02-15 10:49:25,527 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderSalesPersonCommission: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:26,221 - [55906] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderSalesPersonCommission in 0 batches - __SPLIT__
2026-02-15 10:49:26,884 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:27,580 - [55906] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderCommissionAdjustment in 0 batches - __SPLIT__
2026-02-15 10:49:28,241 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:28,930 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderServices - __SPLIT__
2026-02-15 10:49:29,976 - [55906] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-02-15 10:49:30,629 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrder: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:31,310 - [55906] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SubWorkOrder in 0 batches - __SPLIT__
2026-02-15 10:49:31,956 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:32,647 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-02-15 10:49:33,405 - [55906] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-02-15 10:49:34,057 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkorderSourceMapping: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:34,732 - [55906] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkorderSourceMapping in 0 batches - __SPLIT__
2026-02-15 10:49:35,376 - [55906] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:36,058 - [55906] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-02-15 10:49:36,841 - [55906] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-02-15 10:49:37,499 - [55906] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-02-15 10:49:38,151 - [55906] - src.utils.log - INFO - 🔍 Fetching data:
SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 55906
GROUP BY ServiceSetupId;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:38,830 - [55906] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-15 10:49:39,485 - [55906] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-02-15 10:49:40,144 - [55906] - src.utils.log - INFO - 🛠 Creating temp table #tbl_15a8a57858 - __SPLIT__
2026-02-15 10:49:40,829 - [55906] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_15a8a57858 - __SPLIT__
2026-02-15 10:49:41,503 - [55906] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-02-15 10:49:42,171 - [55906] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-02-15 10:49:42,843 - [55906] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_15a8a57858 - __SPLIT__
2026-02-15 10:49:43,818 - [55906] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_15a8a57858 - __SPLIT__
2026-02-15 10:49:44,493 - [55906] - src.utils.log - INFO - 🗑️ Deleting records:
DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
WHERE GenerateWorkOrderHistoryId = 55906
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:45,201 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:45,876 - [55906] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-02-15 10:49:46,553 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:47,299 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:47,970 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:48,704 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:49,378 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:50,083 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:50,756 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:51,465 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:52,165 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:52,871 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:53,541 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:54,276 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:54,947 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:55,648 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:56,328 - [55906] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (473157, 473158) (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:49:57,126 - [55906] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-15 10:49:58,077 - [55906] - src.utils.log - INFO - Work order published ids: (473157, 473158) - __SPLIT__
2026-02-15 10:49:58,738 - [55906] - src.utils.log - INFO - Time took to perform operation in publishing [55906]: 112.09 - __SPLIT__
2026-02-15 10:49:59,395 - [55906] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [55906] - __SPLIT__
2026-02-15 10:50:00,053 - [55906] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-02-15 05:49:58.077' WHERE CompanyId = 145 AND
GenerateWorkOrderHistoryId = 55906;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-15 10:50:00,741 - [55906] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__