2026-05-27 13:23:45,184 - 56361 - src.utils.log - INFO - ParallelProcessing=False GenerateWorkOrderHistoryId=56361 - __SPLIT__
2026-05-27 13:23:47,709 - 56361 - src.utils.log - INFO - Sequential Work order generation algo started for GenerateWorkOrderHistoryId: 56361 - __SPLIT__
2026-05-27 13:23:47,709 - 56361 - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-05-27 13:23:47,709 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE 
        CompanyKey  = 'Samsung'... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:47,875 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:47,875 - 56361 - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-05-27 13:23:47,875 - 56361 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'InProgress' WHERE GenerateWorkOrderHistoryId = 56361;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:47,897 - 56361 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-27 13:23:47,897 - 56361 - src.utils.log - INFO - 🔍 Fetching data:  
    SELECT sss.RecurringServicePrice, gw.StartDate, gw.EndDate, gw.CreatedBy AS NewCreatedBy, gw.RouteIds, ss.* FROM 
    ServiceCore.GenerateWorkOrderHistory gw JOIN ServiceCore.ServiceSetup ss ON gw.CompanyId = ss.CompanyId AND (
    (ss.NextGenerationDate <= gw.EndDate AND ss.NextGenerationDate >= gw.StartDate) OR ss.NextGenerationDate IS NULL) 
    AND (gw.AccountNumber IS NULL OR ss.AccountNumber = gw.AccountNumber) AND (gw.ServiceSetupId IS NULL OR 
    ss.ServiceSetupId = gw.ServiceSetupId)AND (gw.RouteIds IS NULL OR ss.RouteMasterId IN (SELECT CAST(value AS INT) FROM 
    STRING_SPLIT((SELECT RouteIds FROM ServiceCore.GenerateWorkOrderHistory WHERE GenerateWorkOrderHistoryid = 
    56361), ',' )) OR ss.InitialRouteId IN ( SELECT CAST(value AS INT) FROM STRING_SPLIT((SELECT RouteIds 
    FROM ServiceCore.GenerateWorkOrderHistory WHERE GenerateWorkOrderHistoryid = 56361), ','))) JOIN (SELECT 
    SUM(Price) AS RecurringServicePrice, ServiceSetupId FROM ServiceCore.ServiceSetupServices GROUP BY ServiceSetupId
    ) sss ON sss.ServiceSetupId = ss.ServiceSetupId WHERE gw.GenerateWorkOrderHistoryid = 56361 AND 
    ss.FrequencyScheduleId IS NOT NULL AND ss.IsActive = 1 AND ss.IsDeleted = 0 AND ss.Status <> 'Canceled' 
    AND ((ss.OrderType = gw.OrderType) OR gw.OrderType IS NULL);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:47,961 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:47,961 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.GenerateWorkOrderHistory gwoh WHERE GenerateWorkOrderHistoryId = 56361;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:47,986 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:47,988 - 56361 - src.utils.log - INFO - FrequencyScheduleId missing for setups: []: Ignored these setups - __SPLIT__
2026-05-27 13:23:47,988 - 56361 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT  fsd.IntervalDays, fs.CreatedDate ,f.FrequencyId , fs.FrequencyScheduleId,  f.[SysName], f.FrequencyValue, 
        f.YearlyOccurrence , fs.ScheduleFormat,fsd.Days, fsd.Weeks, fsd.Months,fsc.[Month] as sch_months, fsd.StartMonth , 
        fsd.DateDay,fsd.DateMonth FROM [ServiceCore].[FrequencyMaster] f inner join [ServiceCore].[FrequencySchedule] fs 
        on fs.FrequencyId = f.FrequencyId left join ServiceCore.FrequencyScheduleCycle fsc on 
        fsc.FrequencyScheduleId = fs.FrequencyScheduleId left join [ServiceCore].[FrequencyScheduleDetail] fsd on 
        fsd.FrequencyScheduleId = fs.FrequencyScheduleId WHERE fsd.FrequencyScheduleId = 14828... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,018 - 56361 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-27 13:23:48,018 - 56361 - src.utils.log - INFO - Found the Setups and Frequencies - __SPLIT__
2026-05-27 13:23:48,021 - 56361 - src.utils.log - INFO - Inside work order function - __SPLIT__
2026-05-27 13:23:48,021 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,056 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:48,057 - 56361 - src.utils.log - INFO - 🔍 Fetching data: select ServiceDate, ServiceSetupId, IsInitial from serviceCore.WorkOrder wo inner join 
        ServiceCore.WorkOrderStatus wos on wo.WoStatusId = wos.WoStatusId where  ServiceDate >= '2026-05-27 00:00:00' and 
        ServiceDate <= '2027-12-31 00:00:00' and ServiceSetupId = 106052 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,090 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:48,158 - 56361 - src.utils.log - INFO - Generating work orders for setup: 106052 - __SPLIT__
2026-05-27 13:23:48,192 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11398;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,214 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:48,250 - 56361 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-05-27 13:23:48,255 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=145 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,276 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:48,278 - 56361 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-05-27 13:23:48,278 - 56361 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-05-27 13:23:48,278 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,440 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,440 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,494 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,494 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,546 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,547 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,599 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,599 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,650 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,650 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,705 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,705 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106052
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,734 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,734 - 56361 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 106052
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,829 - 56361 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-27 13:23:48,829 - 56361 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-27 13:23:48,829 - 56361 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:48,930 - 56361 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-05-27 13:23:49,115 - 56361 - src.utils.log - INFO - ✅ All 6 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-05-27 13:23:49,115 - 56361 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 6 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-05-13 16:42:40.938'
    and ServiceSetupId = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,166 - 56361 - src.utils.log - INFO - ✅ Fetched 6 rows - __SPLIT__
2026-05-27 13:23:49,167 - 56361 - src.utils.log - INFO - Id's of work order inserted to DB: [577556 577557 577558 577559 577560 577561] - __SPLIT__
2026-05-27 13:23:49,167 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,189 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,189 - 56361 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-05-27 13:23:49,190 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,213 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:49,213 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,235 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,238 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,276 - 56361 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-27 13:23:49,277 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,302 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,303 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 106052... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,327 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,327 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,350 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,350 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,371 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,372 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,632 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,632 - 56361 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 106052;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,657 - 56361 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-27 13:23:49,664 - 56361 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SetupAutoGenerationSourceMapping: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SubWorkOrderAutoGeneration: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-27 13:23:49,665 - 56361 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (577556, 577557, 577558, 577559, 577560, 577561)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,687 - 56361 - src.utils.log - INFO - ✅ Fetched 6 rows - __SPLIT__
2026-05-27 13:23:49,688 - 56361 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,729 - 56361 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-05-27 13:23:49,812 - 56361 - src.utils.log - INFO - ✅ All 6 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-05-27 13:23:49,813 - 56361 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,813 - 56361 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationServices: - __SPLIT__
2026-05-27 13:23:49,813 - 56361 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,813 - 56361 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-27 13:23:49,813 - 56361 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (577556, 577557, 577558, 577559, 577560, 577561)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,833 - 56361 - src.utils.log - INFO - ✅ Fetched 6 rows - __SPLIT__
2026-05-27 13:23:49,834 - 56361 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 6 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,877 - 56361 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 6) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-05-27 13:23:49,965 - 56361 - src.utils.log - INFO - ✅ All 6 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-05-27 13:23:49,966 - 56361 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-27 13:23:49,966 - 56361 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56361;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:49,987 - 56361 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-27 13:23:49,987 - 56361 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-05-27 13:23:49,987 - 56361 - src.utils.log - INFO - Time took to perform operation: 2.28 - __SPLIT__
2026-05-27 13:23:49,987 - 56361 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56361;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:50,007 - 56361 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-27 13:23:50,008 - 56361 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-05-27 09:23:50.007' WHERE  
                    GenerateWorkOrderHistoryId = 56361;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-27 13:23:50,030 - 56361 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 08:54:50,928 - [56365] - src.utils.log - INFO - ParallelProcessing=False temp_wo=[577566, 577568] user_id=44502 company_id=145 project_id=[56365] publish_all=False - __SPLIT__
2026-05-28 08:54:50,929 - [56365] - src.utils.log - INFO - ParallelProcessing=False temp_wo=[577566, 577568] user_id=44502 company_id=145 project_id=[56365] publish_all=False - __SPLIT__
2026-05-28 08:54:50,929 - [56365] - src.utils.log - INFO - Sequential Work order publish in progress for GenerateWorkOrderHistoryId: [56365] - __SPLIT__
2026-05-28 08:54:50,930 - [56365] - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-05-28 08:54:50,930 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE 
            CompanyKey  = 'Samsung'... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,079 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:51,079 - [56365] - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-05-28 08:54:51,080 - [56365] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'InProgress'
                        WHERE CompanyId = 145 AND 
                        GenerateWorkOrderHistoryId = 56365;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,103 - [56365] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 08:54:51,103 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,128 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:51,128 - [56365] - src.utils.log - INFO - Inside get_work_order_table - __SPLIT__
2026-05-28 08:54:51,129 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT DISTINCT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.ServiceCategoryMaster c ON c.DepartmentId = dm.DepartmentMasterId
                    JOIN ServiceCore.ServiceMaster sm ON c.CategoryId = sm.CategoryId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.ServiceId = sm.ServiceMasterId
                    WHERE dm.CompanyId = 145 AND d2.CompanyId = bm.CompanyId AND
                     sss.ServiceSetupId = 106055 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,157 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,157 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.SoldServiceNonStandard x on dm.DepartmentMasterId = x.DepartmentId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.NonStdSoldServiceId  = x.SoldServiceNonStandardId 
                    WHERE dm.CompanyId = 145 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId = 106055 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,183 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:51,183 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    Inner JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    Inner JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    Inner JOIN [ServiceCore].[ServiceCategoryMaster] scm ON dm.DepartmentMasterId = scm.DepartmentId
                    Inner JOIN ServiceCore.ServiceMaster sm ON scm.CategoryId = sm.CategoryId
                    Inner JOIN ServiceCore.SoldServiceStandard x on x.ServiceId  =  sm.ServiceMasterId 
                    Inner JOIN ServiceCore.ServiceSetupServices sss ON sss.StdSoldServiceId  = x.SoldServiceStandardId
                    WHERE dm.CompanyId = 145 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId = 106055 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,224 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:51,228 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInvoiceSameAsWorkorder,BillingIsCreateInvoice FROM 
    Common.CompanyConfiguration cc WHERE cc.CompanyId = 145;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,256 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,256 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
    WHERE CompanyId = 145 AND EnitityNumberType in ('WorkOrder','Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,285 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:51,286 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT IsInvoiceSameAsWorkorder, BillingIsCreateInvoice
        FROM Common.CompanyConfiguration cc
        WHERE cc.CompanyId = 145;
    ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,310 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,311 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
        UPDATE Common.GenerateNumberConfig
        SET NextNumber = NextNumber + 2
        OUTPUT INSERTED.NextNumber - 2 AS StartNumber
        WHERE CompanyId = 145
        AND EnitityNumberType IN ('WorkOrder','Invoice');
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,335 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:51,337 - [56365] - 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 = 106055... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,365 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,367 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE 
    CompanyKey = 'Samsung';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,388 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,388 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a 
        WHERE a.AccountNo = '3613' and a.CompanyId = 133;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,410 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:51,412 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
                    SELECT WorkOrderNo FROM ServiceCore.WorkOrder
                    WHERE WorkOrderNo IN ('225550', '225551') AND CompanyId = 145
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,438 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:51,438 - [56365] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,522 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-05-28 08:54:51,788 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-05-28 08:54:51,799 - [56365] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-28 08:54:51,801 - [56365] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.ServiceSetup SET IsInitialWoGenerated = 1
                         WHERE CompanyId = 145 AND 
                        ServiceSetupId = 106055;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,825 - [56365] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 08:54:51,826 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT WorkorderId, WorkOrderNo 
                FROM ServiceCore.WorkOrder wo
                WHERE wo.WorkOrderNo IN ('225550', '225551')
                  AND wo.AccountNumber = '3613'
                  AND wo.CompanyId = 145
            ... (Thread: ThreadPoolExecutor-36_0) - __SPLIT__
2026-05-28 08:54:51,854 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:51,855 - [56365] - src.utils.log - INFO - Sequential fetching temp table records - __SPLIT__
2026-05-28 08:54:51,855 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationServices woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:51,917 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:51,917 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SubWorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,236 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,237 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationCrews woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,284 - [56365] - src.utils.log - INFO - ✅ Fetched 5 rows - __SPLIT__
2026-05-28 08:54:52,284 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationSalesPersonCommission woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,311 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,311 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SetupAutoGenerationSourceMapping woag WHERE woag.WorkOrderAutoGenerationId
     in (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,337 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,338 - [56365] - 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 (577566, 577568)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,374 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,374 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from CRM.LeadNote woag WHERE woag.RefId in (577566, 577568) and
         woag.RefType = 'TempWorkorder';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,399 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,399 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM  ServiceCore.WorkOrderAutoGenerationCommissionAdjustment woagca 
        WHERE woagca.WorkOrderAutoGenerationId  in (577566, 577568);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,422 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:52,423 - [56365] - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-05-28 08:54:52,433 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
     cm WHERE CompanyId = 145;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,455 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:52,455 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
        WHERE CompanyId = 145 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,478 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:52,480 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:52,481 - [56365] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,542 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-05-28 08:54:52,639 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-05-28 08:54:52,641 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId = 106055 AND WorkOrderNo IN ('208347', '1496084') AND GenerateWorkOrderHistoryId = 56365;... (Thread: ThreadPoolExecutor-37_0) - __SPLIT__
2026-05-28 08:54:52,704 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:52,705 - [56365] - src.utils.log - INFO - 🏁 Final merged rows: 2 - __SPLIT__
2026-05-28 08:54:52,710 - [56365] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-05-28 08:54:52,710 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:52,710 - [56365] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:52,804 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderServices - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderAppliedDiscount: - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderSalesPersonCommission: - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:52,970 - [56365] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 5 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,012 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 5) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-05-28 08:54:53,095 - [56365] - src.utils.log - INFO - ✅ All 5 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-05-28 08:54:53,096 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkorderSourceMapping: - __SPLIT__
2026-05-28 08:54:53,096 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-05-28 08:54:53,096 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:53,096 - [56365] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,138 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-05-28 08:54:53,228 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-05-28 08:54:53,229 - [56365] - 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 = 106055... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,250 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:53,257 - [56365] - src.utils.log - INFO - Size of Transaction: 2 - __SPLIT__
2026-05-28 08:54:53,257 - [56365] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,308 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-05-28 08:54:53,397 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-05-28 08:54:53,408 - [56365] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-28 08:54:53,408 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911)  and t.CompanyId = 145 AND 
        t.TransactionType ='Invoice' AND t.CreatedDate = '2026-05-28 04:54:53.253';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,583 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:53,585 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106055;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,763 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:53,771 - [56365] - src.utils.log - INFO - 📝 Executing: 
                    UPDATE Billing.[Transaction]
                    SET ModifiedBy = NULL
                    WHERE ModifiedBy IN (12345678910,12345678911)
                    AND CreatedDate = '2026-05-28 04:54:53.253';
                ... (Thread: ThreadPoolExecutor-38_0) - __SPLIT__
2026-05-28 08:54:53,851 - [56365] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 08:54:53,855 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:53,855 - [56365] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:53,899 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into Billing.Invoice - __SPLIT__
2026-05-28 08:54:53,990 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-05-28 08:54:53,990 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('225550', '225551')... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,119 - [56365] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 08:54:54,128 - [56365] - 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 = 106055 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,154 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:54,154 - [56365] - 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 = 106055 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,186 - [56365] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 08:54:54,186 - [56365] - 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 = 106055  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,210 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,211 - [56365] - 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 = 106055  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,235 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,246 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106055;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,268 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,272 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId, 
        AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId  from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 106055;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,294 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,296 - [56365] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
        IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 106055;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,319 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,319 - [56365] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-05-28 08:54:54,319 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-05-28 08:54:54,319 - [56365] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 08:54:54,319 - [56365] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,364 - [56365] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into Billing.InvoiceCharges - __SPLIT__
2026-05-28 08:54:54,451 - [56365] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-05-28 08:54:54,451 - [56365] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-05-28 08:54:54,451 - [56365] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-05-28 08:54:54,451 - [56365] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-05-28 08:54:54,451 - [56365] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 56365
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,476 - [56365] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 08:54:54,481 - [56365] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-05-28 08:54:54,493 - [56365] - src.utils.log - INFO - 🛠 Creating temp table #tbl_f1a2e0afb3 - __SPLIT__
2026-05-28 08:54:54,516 - [56365] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_f1a2e0afb3 - __SPLIT__
2026-05-28 08:54:54,537 - [56365] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-05-28 08:54:54,552 - [56365] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-05-28 08:54:54,568 - [56365] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_f1a2e0afb3 - __SPLIT__
2026-05-28 08:54:54,568 - [56365] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_f1a2e0afb3 - __SPLIT__
2026-05-28 08:54:54,568 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 56365
               (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,590 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,590 - [56365] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-05-28 08:54:54,590 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,672 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,672 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,738 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,738 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,763 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,763 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,804 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,804 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,833 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,833 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,893 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,894 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:54,915 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:54,915 - [56365] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (577566, 577568)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:55,032 - [56365] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 08:54:55,033 - [56365] - src.utils.log - INFO - Work order published ids: (577566, 577568) - __SPLIT__
2026-05-28 08:54:55,033 - [56365] - src.utils.log - INFO - Time took to perform operation in publishing [56365]: 4.1 - __SPLIT__
2026-05-28 08:54:55,033 - [56365] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [56365] - __SPLIT__
2026-05-28 08:54:55,033 - [56365] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-05-28 04:54:55.032' WHERE CompanyId = 145 AND 
                        GenerateWorkOrderHistoryId = 56365;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 08:54:55,056 - [56365] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:28:59,817 - 56366 - src.utils.log - INFO - ParallelProcessing=False GenerateWorkOrderHistoryId=56366 - __SPLIT__
2026-05-28 09:28:59,818 - 56366 - src.utils.log - INFO - Sequential Work order generation algo started for GenerateWorkOrderHistoryId: 56366 - __SPLIT__
2026-05-28 09:28:59,819 - 56366 - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-05-28 09:28:59,819 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE 
        CompanyKey  = 'Fortive'... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,045 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:00,045 - 56366 - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-05-28 09:29:00,045 - 56366 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'InProgress' WHERE GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,082 - 56366 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:29:00,082 - 56366 - src.utils.log - INFO - 🔍 Fetching data:  
    SELECT sss.RecurringServicePrice, gw.StartDate, gw.EndDate, gw.CreatedBy AS NewCreatedBy, gw.RouteIds, ss.* FROM 
    ServiceCore.GenerateWorkOrderHistory gw JOIN ServiceCore.ServiceSetup ss ON gw.CompanyId = ss.CompanyId AND (
    (ss.NextGenerationDate <= gw.EndDate AND ss.NextGenerationDate >= gw.StartDate) OR ss.NextGenerationDate IS NULL) 
    AND (gw.AccountNumber IS NULL OR ss.AccountNumber = gw.AccountNumber) AND (gw.ServiceSetupId IS NULL OR 
    ss.ServiceSetupId = gw.ServiceSetupId)AND (gw.RouteIds IS NULL OR ss.RouteMasterId IN (SELECT CAST(value AS INT) FROM 
    STRING_SPLIT((SELECT RouteIds FROM ServiceCore.GenerateWorkOrderHistory WHERE GenerateWorkOrderHistoryid = 
    56366), ',' )) OR ss.InitialRouteId IN ( SELECT CAST(value AS INT) FROM STRING_SPLIT((SELECT RouteIds 
    FROM ServiceCore.GenerateWorkOrderHistory WHERE GenerateWorkOrderHistoryid = 56366), ','))) JOIN (SELECT 
    SUM(Price) AS RecurringServicePrice, ServiceSetupId FROM ServiceCore.ServiceSetupServices GROUP BY ServiceSetupId
    ) sss ON sss.ServiceSetupId = ss.ServiceSetupId WHERE gw.GenerateWorkOrderHistoryid = 56366 AND 
    ss.FrequencyScheduleId IS NOT NULL AND ss.IsActive = 1 AND ss.IsDeleted = 0 AND ss.Status <> 'Canceled' 
    AND ((ss.OrderType = gw.OrderType) OR gw.OrderType IS NULL);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,154 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:00,155 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.GenerateWorkOrderHistory gwoh WHERE GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,187 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:00,189 - 56366 - src.utils.log - INFO - FrequencyScheduleId missing for setups: []: Ignored these setups - __SPLIT__
2026-05-28 09:29:00,190 - 56366 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT  fsd.IntervalDays, fs.CreatedDate ,f.FrequencyId , fs.FrequencyScheduleId,  f.[SysName], f.FrequencyValue, 
        f.YearlyOccurrence , fs.ScheduleFormat,fsd.Days, fsd.Weeks, fsd.Months,fsc.[Month] as sch_months, fsd.StartMonth , 
        fsd.DateDay,fsd.DateMonth FROM [ServiceCore].[FrequencyMaster] f inner join [ServiceCore].[FrequencySchedule] fs 
        on fs.FrequencyId = f.FrequencyId left join ServiceCore.FrequencyScheduleCycle fsc on 
        fsc.FrequencyScheduleId = fs.FrequencyScheduleId left join [ServiceCore].[FrequencyScheduleDetail] fsd on 
        fsd.FrequencyScheduleId = fs.FrequencyScheduleId WHERE fsd.FrequencyScheduleId = 14944... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,227 - 56366 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:29:00,227 - 56366 - src.utils.log - INFO - Found the Setups and Frequencies - __SPLIT__
2026-05-28 09:29:00,230 - 56366 - src.utils.log - INFO - Inside work order function - __SPLIT__
2026-05-28 09:29:00,231 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,261 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:00,261 - 56366 - src.utils.log - INFO - 🔍 Fetching data: select ServiceDate, ServiceSetupId, IsInitial from serviceCore.WorkOrder wo inner join 
        ServiceCore.WorkOrderStatus wos on wo.WoStatusId = wos.WoStatusId where  ServiceDate >= '2026-05-28 00:00:00' and 
        ServiceDate <= '2026-12-31 00:00:00' and ServiceSetupId = 106056 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,298 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:00,377 - 56366 - src.utils.log - INFO - Generating work orders for setup: 106056 - __SPLIT__
2026-05-28 09:29:00,401 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11408;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,430 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:00,437 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11519;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,466 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:00,499 - 56366 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-05-28 09:29:00,504 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=146 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,533 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:00,535 - 56366 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-05-28 09:29:00,535 - 56366 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-05-28 09:29:00,535 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,597 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,597 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,653 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,654 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,710 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,710 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,767 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,767 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,823 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,824 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,880 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,880 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 106056
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:00,912 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:00,912 - 56366 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 106056
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,011 - 56366 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:29:01,012 - 56366 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:29:01,012 - 56366 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,087 - 56366 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-05-28 09:29:01,244 - 56366 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-05-28 09:29:01,245 - 56366 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 4 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-05-13 16:42:40.938'
    and ServiceSetupId = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,301 - 56366 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:29:01,302 - 56366 - src.utils.log - INFO - Id's of work order inserted to DB: [577569 577570 577571 577572] - __SPLIT__
2026-05-28 09:29:01,302 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,331 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,331 - 56366 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-05-28 09:29:01,332 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,362 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:01,362 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,392 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:01,398 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,431 - 56366 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:29:01,432 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,461 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,461 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,490 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,490 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,519 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,520 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,549 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,549 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,596 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,596 - 56366 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,626 - 56366 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SetupAutoGenerationSourceMapping: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SubWorkOrderAutoGeneration: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,638 - 56366 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:29:01,639 - 56366 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (577569, 577570, 577571, 577572)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,667 - 56366 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:29:01,668 - 56366 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,700 - 56366 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-05-28 09:29:01,813 - 56366 - src.utils.log - INFO - ✅ All 8 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-05-28 09:29:01,813 - 56366 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,813 - 56366 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:29:01,814 - 56366 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId = 577569
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,842 - 56366 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:29:01,842 - 56366 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:01,878 - 56366 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-05-28 09:29:01,987 - 56366 - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-05-28 09:29:01,988 - 56366 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-28 09:29:01,988 - 56366 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:29:01,988 - 56366 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (577570, 577571, 577572)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:02,017 - 56366 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-28 09:29:02,018 - 56366 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:02,054 - 56366 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-05-28 09:29:02,167 - 56366 - src.utils.log - INFO - ✅ All 3 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-05-28 09:29:02,167 - 56366 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-28 09:29:02,167 - 56366 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:02,196 - 56366 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:29:02,196 - 56366 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-05-28 09:29:02,196 - 56366 - src.utils.log - INFO - Time took to perform operation: 2.38 - __SPLIT__
2026-05-28 09:29:02,196 - 56366 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:02,224 - 56366 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:29:02,224 - 56366 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-05-28 05:29:02.224' WHERE  
                    GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:29:02,254 - 56366 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:31:37,822 - [56366] - src.utils.log - INFO - ParallelProcessing=False temp_wo=[577571, 577572] user_id=44506 company_id=146 project_id=[56366] publish_all=False - __SPLIT__
2026-05-28 09:31:37,823 - [56366] - src.utils.log - INFO - ParallelProcessing=False temp_wo=[577571, 577572] user_id=44506 company_id=146 project_id=[56366] publish_all=False - __SPLIT__
2026-05-28 09:31:37,823 - [56366] - src.utils.log - INFO - Sequential Work order publish in progress for GenerateWorkOrderHistoryId: [56366] - __SPLIT__
2026-05-28 09:31:37,823 - [56366] - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-05-28 09:31:37,823 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE 
            CompanyKey  = 'Fortive'... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:37,998 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:37,998 - [56366] - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-05-28 09:31:37,999 - [56366] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'InProgress'
                        WHERE CompanyId = 146 AND 
                        GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,024 - [56366] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:31:38,024 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,053 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:38,053 - [56366] - src.utils.log - INFO - Inside get_work_order_table - __SPLIT__
2026-05-28 09:31:38,054 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT DISTINCT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.ServiceCategoryMaster c ON c.DepartmentId = dm.DepartmentMasterId
                    JOIN ServiceCore.ServiceMaster sm ON c.CategoryId = sm.CategoryId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.ServiceId = sm.ServiceMasterId
                    WHERE dm.CompanyId = 146 AND d2.CompanyId = bm.CompanyId AND
                     sss.ServiceSetupId = 106056 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,079 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,079 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.SoldServiceNonStandard x on dm.DepartmentMasterId = x.DepartmentId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.NonStdSoldServiceId  = x.SoldServiceNonStandardId 
                    WHERE dm.CompanyId = 146 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId = 106056 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,103 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,104 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    Inner JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    Inner JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    Inner JOIN [ServiceCore].[ServiceCategoryMaster] scm ON dm.DepartmentMasterId = scm.DepartmentId
                    Inner JOIN ServiceCore.ServiceMaster sm ON scm.CategoryId = sm.CategoryId
                    Inner JOIN ServiceCore.SoldServiceStandard x on x.ServiceId  =  sm.ServiceMasterId 
                    Inner JOIN ServiceCore.ServiceSetupServices sss ON sss.StdSoldServiceId  = x.SoldServiceStandardId
                    WHERE dm.CompanyId = 146 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId = 106056 AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,128 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,132 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInvoiceSameAsWorkorder,BillingIsCreateInvoice FROM 
    Common.CompanyConfiguration cc WHERE cc.CompanyId = 146;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,157 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,157 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
    WHERE CompanyId = 146 AND EnitityNumberType in ('WorkOrder','Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,182 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:38,182 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT IsInvoiceSameAsWorkorder, BillingIsCreateInvoice
        FROM Common.CompanyConfiguration cc
        WHERE cc.CompanyId = 146;
    ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,206 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,207 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
            UPDATE Common.GenerateNumberConfig WITH (ROWLOCK)
            SET NextNumber = NextNumber + 2
            OUTPUT deleted.NextNumber AS StartNumber
            WHERE CompanyId = 146
              AND EnitityNumberType = 'WorkOrder';
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,233 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,233 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
            UPDATE Common.GenerateNumberConfig WITH (ROWLOCK)
            SET NextNumber = NextNumber + 2
            OUTPUT deleted.NextNumber AS StartNumber
            WHERE CompanyId = 146
              AND EnitityNumberType = 'Invoice';
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,258 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,262 - [56366] - 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 = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,288 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,290 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE 
    CompanyKey = 'Fortive';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,314 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,315 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a 
        WHERE a.AccountNo = '2287' and a.CompanyId = 134;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,339 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,341 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
                    SELECT WorkOrderNo FROM ServiceCore.WorkOrder
                    WHERE WorkOrderNo IN ('56337', '56338') AND CompanyId = 146
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,380 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,380 - [56366] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,447 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-05-28 09:31:38,577 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-05-28 09:31:38,589 - [56366] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-28 09:31:38,590 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT WorkorderId, WorkOrderNo 
                FROM ServiceCore.WorkOrder wo
                WHERE wo.WorkOrderNo IN ('56337', '56338')
                  AND wo.AccountNumber = '2287'
                  AND wo.CompanyId = 146
            ... (Thread: ThreadPoolExecutor-39_0) - __SPLIT__
2026-05-28 09:31:38,622 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:38,623 - [56366] - src.utils.log - INFO - Sequential fetching temp table records - __SPLIT__
2026-05-28 09:31:38,623 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationServices woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,665 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:38,665 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SubWorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,716 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,716 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationCrews woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,752 - [56366] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:31:38,752 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationSalesPersonCommission woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,779 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,779 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SetupAutoGenerationSourceMapping woag WHERE woag.WorkOrderAutoGenerationId
     in (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,806 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,806 - [56366] - 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 (577571, 577572)... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,838 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,838 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from CRM.LeadNote woag WHERE woag.RefId in (577571, 577572) and
         woag.RefType = 'TempWorkorder';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,865 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,865 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM  ServiceCore.WorkOrderAutoGenerationCommissionAdjustment woagca 
        WHERE woagca.WorkOrderAutoGenerationId  in (577571, 577572);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,890 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:38,892 - [56366] - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-05-28 09:31:38,903 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
     cm WHERE CompanyId = 146;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,927 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,927 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
        WHERE CompanyId = 146 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,951 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:38,954 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:38,954 - [56366] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:38,998 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-05-28 09:31:39,112 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-05-28 09:31:39,113 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId = 106056 AND WorkOrderNo IN ('6467084', '8336764') AND GenerateWorkOrderHistoryId = 56366;... (Thread: ThreadPoolExecutor-40_0) - __SPLIT__
2026-05-28 09:31:39,172 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:39,172 - [56366] - src.utils.log - INFO - 🏁 Final merged rows: 2 - __SPLIT__
2026-05-28 09:31:39,176 - [56366] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-05-28 09:31:39,176 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:39,177 - [56366] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,207 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderServices - __SPLIT__
2026-05-28 09:31:39,303 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-05-28 09:31:39,304 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderAppliedDiscount: - __SPLIT__
2026-05-28 09:31:39,304 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderSalesPersonCommission: - __SPLIT__
2026-05-28 09:31:39,304 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-05-28 09:31:39,304 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:39,304 - [56366] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,333 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-05-28 09:31:39,429 - [56366] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-05-28 09:31:39,429 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkorderSourceMapping: - __SPLIT__
2026-05-28 09:31:39,430 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-05-28 09:31:39,430 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:39,430 - [56366] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,461 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-05-28 09:31:39,554 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-05-28 09:31:39,554 - [56366] - 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 = 106056... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,580 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:39,586 - [56366] - src.utils.log - INFO - Size of Transaction: 2 - __SPLIT__
2026-05-28 09:31:39,586 - [56366] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,628 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-05-28 09:31:39,718 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-05-28 09:31:39,730 - [56366] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-28 09:31:39,730 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911)  and t.CompanyId = 146 AND 
        t.TransactionType ='Invoice' AND t.CreatedDate = '2026-05-28 05:31:39.581';... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,825 - [56366] - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 09:31:39,828 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:39,864 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:39,872 - [56366] - src.utils.log - INFO - 📝 Executing: 
                    UPDATE Billing.[Transaction]
                    SET ModifiedBy = NULL
                    WHERE ModifiedBy IN (12345678910,12345678911)
                    AND CreatedDate = '2026-05-28 05:31:39.581';
                ... (Thread: ThreadPoolExecutor-41_0) - __SPLIT__
2026-05-28 09:31:40,067 - [56366] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 09:31:40,072 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:40,072 - [56366] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 2 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,104 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 2) into Billing.Invoice - __SPLIT__
2026-05-28 09:31:40,198 - [56366] - src.utils.log - INFO - ✅ All 2 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-05-28 09:31:40,198 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('56338', '56337')... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,275 - [56366] - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 09:31:40,286 - [56366] - 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 = 106056 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,314 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:40,314 - [56366] - 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 = 106056 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,338 - [56366] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 09:31:40,339 - [56366] - 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 = 106056  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,363 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,364 - [56366] - 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 = 106056  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,388 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,400 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,426 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,430 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId, 
        AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId  from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,455 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,458 - [56366] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
        IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 106056;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,483 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,483 - [56366] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-05-28 09:31:40,483 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-05-28 09:31:40,483 - [56366] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 09:31:40,483 - [56366] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,514 - [56366] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into Billing.InvoiceCharges - __SPLIT__
2026-05-28 09:31:40,606 - [56366] - src.utils.log - INFO - ✅ All 4 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-05-28 09:31:40,606 - [56366] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-05-28 09:31:40,606 - [56366] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-05-28 09:31:40,607 - [56366] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-05-28 09:31:40,607 - [56366] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 56366
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,631 - [56366] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 09:31:40,636 - [56366] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-05-28 09:31:40,648 - [56366] - src.utils.log - INFO - 🛠 Creating temp table #tbl_303526bf2d - __SPLIT__
2026-05-28 09:31:40,675 - [56366] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_303526bf2d - __SPLIT__
2026-05-28 09:31:40,700 - [56366] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-05-28 09:31:40,718 - [56366] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-05-28 09:31:40,734 - [56366] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_303526bf2d - __SPLIT__
2026-05-28 09:31:40,734 - [56366] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_303526bf2d - __SPLIT__
2026-05-28 09:31:40,734 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 56366
               (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,759 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:40,759 - [56366] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-05-28 09:31:40,759 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,846 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:40,846 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,916 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:40,916 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,945 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:40,945 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:40,990 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:40,990 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:41,023 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:41,023 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:41,086 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:41,087 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:41,113 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:41,113 - [56366] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (577571, 577572)   (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:41,238 - [56366] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 09:31:41,238 - [56366] - src.utils.log - INFO - Work order published ids: (577571, 577572) - __SPLIT__
2026-05-28 09:31:41,238 - [56366] - src.utils.log - INFO - Time took to perform operation in publishing [56366]: 3.42 - __SPLIT__
2026-05-28 09:31:41,238 - [56366] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [56366] - __SPLIT__
2026-05-28 09:31:41,238 - [56366] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-05-28 05:31:41.238' WHERE CompanyId = 146 AND 
                        GenerateWorkOrderHistoryId = 56366;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 09:31:41,263 - [56366] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__