Python LogViewer

2026-03-18 10:39:03,194 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:03,270 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.GenerateWorkOrderHistory gwoh WHERE GenerateWorkOrderHistoryId = 124155;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:03,609 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:03,684 - 124155 - src.utils.log - INFO - FrequencyScheduleId missing for setups: []: Ignored these setups - __SPLIT__
2026-03-18 10:39:03,762 - 124155 - 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 = 14638... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:04,106 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:04,177 - 124155 - src.utils.log - INFO - Found the Setups and Frequencies - __SPLIT__
2026-03-18 10:39:04,249 - 124155 - src.utils.log - INFO - Inside work order function - __SPLIT__
2026-03-18 10:39:04,319 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:04,658 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:04,781 - 124155 - src.utils.log - INFO - 🔍 Fetching data: select ServiceDate, ServiceSetupId from serviceCore.WorkOrder wo inner join 
        ServiceCore.WorkOrderStatus wos on wo.WoStatusId = wos.WoStatusId where  ServiceDate >= '2026-03-18 00:00:00' and 
        ServiceDate <= '2026-12-31 00:00:00' and ServiceSetupId = 149970 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:05,117 - 124155 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-03-18 10:39:05,737 - 124155 - src.utils.log - INFO - Generating work orders for setup: 149970 - __SPLIT__
2026-03-18 10:39:05,953 - 124155 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-03-18 10:39:06,029 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=133 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:06,367 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:06,443 - 124155 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-03-18 10:39:06,512 - 124155 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-03-18 10:39:06,574 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:06,944 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:07,008 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:07,362 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:07,423 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:07,760 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:07,828 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:08,181 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:08,240 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:08,631 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:08,696 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:09,030 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:09,142 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 149970
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:09,472 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:09,543 - 124155 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 149970
           (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:10,731 - 124155 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-03-18 10:39:10,800 - 124155 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-03-18 10:39:10,866 - 124155 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:11,277 - 124155 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-03-18 10:39:12,620 - 124155 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-03-18 10:39:12,684 - 124155 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 4 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-03-16 12:12:22.248'
    and ServiceSetupId = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:13,056 - 124155 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-03-18 10:39:13,123 - 124155 - src.utils.log - INFO - Id's of work order inserted to DB: [3448952 3448953 3448954 3448955] - __SPLIT__
2026-03-18 10:39:13,193 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:13,530 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:13,621 - 124155 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-03-18 10:39:13,688 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:14,019 - 124155 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-03-18 10:39:14,079 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:14,412 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:14,485 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:14,824 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:14,953 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:15,294 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:15,362 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 149970... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:15,698 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:15,767 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:16,104 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:16,168 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:16,499 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:16,569 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:16,925 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:16,993 - 124155 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 149970;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:17,323 - 124155 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-03-18 10:39:17,402 - 124155 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-03-18 10:39:17,469 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-03-18 10:39:17,534 - 124155 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-03-18 10:39:17,605 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-03-18 10:39:17,675 - 124155 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-03-18 10:39:17,734 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SetupAutoGenerationSourceMapping: - __SPLIT__
2026-03-18 10:39:17,824 - 124155 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-03-18 10:39:17,916 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-03-18 10:39:18,036 - 124155 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-03-18 10:39:18,101 - 124155 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-03-18 10:39:18,169 - 124155 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (3448952, 3448953, 3448954, 3448955)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:18,506 - 124155 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-03-18 10:39:18,597 - 124155 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrderAutoGeneration: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:18,976 - 124155 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.SubWorkOrderAutoGeneration - __SPLIT__
2026-03-18 10:39:20,153 - 124155 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-03-18 10:39:20,224 - 124155 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-03-18 10:39:20,298 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-03-18 10:39:20,370 - 124155 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-03-18 10:39:20,436 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-03-18 10:39:20,508 - 124155 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-03-18 10:39:20,576 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCrews: - __SPLIT__
2026-03-18 10:39:20,645 - 124155 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-03-18 10:39:20,711 - 124155 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationServices: - __SPLIT__
2026-03-18 10:39:20,774 - 124155 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-03-18 10:39:20,838 - 124155 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-03-18 10:39:20,908 - 124155 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:21,282 - 124155 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-03-18 10:39:22,300 - 124155 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-03-18 10:39:22,416 - 124155 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-03-18 10:39:22,482 - 124155 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 124155;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:22,852 - 124155 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-03-18 10:39:22,918 - 124155 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-03-18 10:39:22,990 - 124155 - src.utils.log - INFO - Time took to perform operation: 24.84 - __SPLIT__
2026-03-18 10:39:23,059 - 124155 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 124155;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:23,391 - 124155 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-03-18 10:39:23,457 - 124155 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-03-18 06:39:23.457' WHERE  
                    GenerateWorkOrderHistoryId = 124155;... (Thread: AnyIO worker thread) - __SPLIT__
2026-03-18 10:39:23,792 - 124155 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-03-09

Latest changes applied: added fix for multiple jobs (2026-04-09)
