2026-02-03 11:53:02,150 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-02-03 11:53:02,804 - [55880] - src.utils.log - INFO - 📥 Inserting into Billing.DiscountApplied: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:03,502 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into Billing.DiscountApplied in 0 batches - __SPLIT__
2026-02-03 11:53:04,153 - [55880] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-02-03 11:53:04,804 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE 
    CompanyKey = 'Samsung';... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:05,476 - [55880] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-03 11:53:06,125 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a 
        WHERE a.AccountNo = '2543' and a.CompanyId = 133;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:06,805 - [55880] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-03 11:53:07,462 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:08,196 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-02-03 11:53:09,074 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-02-03 11:53:09,742 - [55880] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-02-03 11:53:10,392 - [55880] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT WorkorderId, WorkOrderNo 
                FROM ServiceCore.WorkOrder wo
                WHERE wo.WorkOrderNo IN ('222000', '222001', '222002', '222003')
                  AND wo.AccountNumber = '2543'
                  AND wo.CompanyId = 145
            ... (Thread: ThreadPoolExecutor-1_0) - __SPLIT__
2026-02-03 11:53:11,088 - [55880] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-03 11:53:11,749 - [55880] - src.utils.log - INFO - Sequential fetching temp table records - __SPLIT__
2026-02-03 11:53:12,395 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationServices woag WHERE woag.WorkOrderAutoGenerationId
     in (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:13,086 - [55880] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-03 11:53:13,743 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SubWorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:14,441 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:15,378 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationCrews woag WHERE woag.WorkOrderAutoGenerationId
     in (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:16,075 - [55880] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-03 11:53:16,742 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationSalesPersonCommission woag WHERE woag.WorkOrderAutoGenerationId
     in (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:17,427 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:18,086 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SetupAutoGenerationSourceMapping woag WHERE woag.WorkOrderAutoGenerationId
     in (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:18,784 - [55880] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-03 11:53:19,446 - [55880] - 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 (472916, 472917, 472918, 472919)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:20,171 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:20,834 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from CRM.LeadNote woag WHERE woag.RefId in (472916, 472917, 472918, 472919) and
         woag.RefType = 'TempWorkorder';... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:21,534 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:22,199 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM  ServiceCore.WorkOrderAutoGenerationCommissionAdjustment woagca 
        WHERE woagca.WorkOrderAutoGenerationId  in (472916, 472917, 472918, 472919);... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:22,894 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:23,559 - [55880] - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-02-03 11:53:24,234 - [55880] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
     cm WHERE CompanyId = 145;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:24,916 - [55880] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-03 11:53:25,582 - [55880] - 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-03 11:53:26,272 - [55880] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-02-03 11:53:26,934 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:27,657 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-02-03 11:53:28,487 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-02-03 11:53:29,443 - [55880] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId = 95346 AND WorkOrderNo IN ('3942993', '6215272', '1426930', '4809142') AND GenerateWorkOrderHistoryId = 55880;... (Thread: ThreadPoolExecutor-2_0) - __SPLIT__
2026-02-03 11:53:30,155 - [55880] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-02-03 11:53:30,809 - [55880] - src.utils.log - INFO - 🏁 Final merged rows: 4 - __SPLIT__
2026-02-03 11:53:31,467 - [55880] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-02-03 11:53:32,126 - [55880] - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:32,809 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-02-03 11:53:33,463 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderAppliedDiscount: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:34,164 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderAppliedDiscount in 0 batches - __SPLIT__
2026-02-03 11:53:34,820 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderSalesPersonCommission: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:35,522 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderSalesPersonCommission in 0 batches - __SPLIT__
2026-02-03 11:53:36,187 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:36,887 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderCommissionAdjustment in 0 batches - __SPLIT__
2026-02-03 11:53:37,552 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:38,257 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderServices - __SPLIT__
2026-02-03 11:53:39,009 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-02-03 11:53:39,664 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrder: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:40,354 - [55880] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SubWorkOrder in 0 batches - __SPLIT__
2026-02-03 11:53:41,004 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:41,704 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-02-03 11:53:42,454 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-02-03 11:53:43,396 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkorderSourceMapping: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:44,102 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkorderSourceMapping - __SPLIT__
2026-02-03 11:53:44,854 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkorderSourceMapping in 1 batches - __SPLIT__
2026-02-03 11:53:45,509 - [55880] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:46,217 - [55880] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-02-03 11:53:46,980 - [55880] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-02-03 11:53:47,632 - [55880] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-02-03 11:53:48,289 - [55880] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 55880
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:48,984 - [55880] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-02-03 11:53:49,654 - [55880] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-02-03 11:53:50,330 - [55880] - src.utils.log - INFO - 🛠 Creating temp table #tbl_bc56d3a273 - __SPLIT__
2026-02-03 11:53:51,019 - [55880] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_bc56d3a273 - __SPLIT__
2026-02-03 11:53:51,725 - [55880] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-02-03 11:53:52,396 - [55880] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-02-03 11:53:53,069 - [55880] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_bc56d3a273 - __SPLIT__
2026-02-03 11:53:53,732 - [55880] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_bc56d3a273 - __SPLIT__
2026-02-03 11:53:54,396 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 55880
               (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:55,086 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:53:55,746 - [55880] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-02-03 11:53:56,405 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:57,416 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:53:58,093 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:53:58,819 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:53:59,492 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:00,201 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:00,889 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:01,619 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:02,302 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:03,015 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:03,692 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:04,429 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:05,121 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:05,827 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:06,507 - [55880] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (472916, 472917, 472918, 472919)   (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:07,342 - [55880] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-02-03 11:54:08,028 - [55880] - src.utils.log - INFO - Work order published ids: (472916, 472917, 472918, 472919) - __SPLIT__
2026-02-03 11:54:08,707 - [55880] - src.utils.log - INFO - Time took to perform operation in publishing [55880]: 107.8 - __SPLIT__
2026-02-03 11:54:09,389 - [55880] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [55880] - __SPLIT__
2026-02-03 11:54:10,096 - [55880] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-02-03 06:54:08.028' WHERE CompanyId = 145 AND 
                        GenerateWorkOrderHistoryId = 55880;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-03 11:54:10,803 - [55880] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__