Python LogViewer

2026-01-12 07:26:32,219 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:32,279 - 11690 - 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-01-12 00:00:00' and 
        ServiceDate <= '2026-02-28 00:00:00' and ServiceSetupId = 23252 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:32,678 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:33,348 - 11690 - src.utils.log - INFO - Generating work orders for setup: 23252 - __SPLIT__
2026-01-12 07:26:33,737 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 1388;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:34,079 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:34,149 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 1364;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:34,528 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:34,634 - 11690 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-01-12 07:26:34,695 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=135 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:35,037 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:35,101 - 11690 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-01-12 07:26:35,164 - 11690 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-01-12 07:26:35,227 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:35,580 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:35,646 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:36,013 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:36,072 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:36,437 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:36,494 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:36,857 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:36,917 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:37,324 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:37,384 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:37,737 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:37,794 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23252
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:38,140 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:38,199 - 11690 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 23252
           (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:38,831 - 11690 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-12 07:26:38,891 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 42 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:39,275 - 11690 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 42) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-01-12 07:26:41,507 - 11690 - src.utils.log - INFO - ✅ All 42 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-01-12 07:26:41,568 - 11690 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 42 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-01-08 11:05:03.618'
    and ServiceSetupId = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:41,967 - 11690 - src.utils.log - INFO - ✅ Fetched 42 rows - __SPLIT__
2026-01-12 07:26:42,027 - 11690 - src.utils.log - INFO - Id's of work order inserted to DB: [2656592 2656593 2656594 2656595 2656596 2656597 2656598 2656599 2656600
 2656601 2656602 2656603 2656604 2656605 2656606 2656607 2656608 2656609
 2656610 2656611 2656612 2656613 2656614 2656615 2656616 2656617 2656618
 2656619 2656620 2656621 2656622 2656623 2656624 2656625 2656626 2656627
 2656628 2656629 2656630 2656631 2656632 2656633] - __SPLIT__
2026-01-12 07:26:42,085 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 23252;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:42,436 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:42,495 - 11690 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-01-12 07:26:42,565 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:42,906 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:42,964 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:43,308 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:43,429 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:43,797 - 11690 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-01-12 07:26:43,868 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:44,239 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:44,308 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 23252... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:44,663 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:44,731 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 23252;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:45,076 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:45,150 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 23252;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:45,535 - 11690 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-12 07:26:45,602 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 23252;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:45,973 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:46,043 - 11690 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 23252;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:46,391 - 11690 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-12 07:26:46,477 - 11690 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-01-12 07:26:46,541 - 11690 - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:46,901 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-01-12 07:26:46,973 - 11690 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-01-12 07:26:47,042 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.CommunicationPreferencesServiceReportNotification: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:47,390 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.CommunicationPreferencesServiceReportNotification in 0 batches - __SPLIT__
2026-01-12 07:26:47,510 - 11690 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-01-12 07:26:47,580 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SetupAutoGenerationSourceMapping: 42 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:47,941 - 11690 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 42) into ServiceCore.SetupAutoGenerationSourceMapping - __SPLIT__
2026-01-12 07:26:48,865 - 11690 - src.utils.log - INFO - ✅ All 42 rows inserted successfully into ServiceCore.SetupAutoGenerationSourceMapping in 1 batches - __SPLIT__
2026-01-12 07:26:48,950 - 11690 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-01-12 07:26:49,012 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationAppliedDiscount: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:49,365 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationAppliedDiscount in 0 batches - __SPLIT__
2026-01-12 07:26:49,434 - 11690 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-01-12 07:26:49,500 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrderAutoGeneration: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:49,889 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 0 batches - __SPLIT__
2026-01-12 07:26:49,954 - 11690 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-01-12 07:26:50,027 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:50,368 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment in 0 batches - __SPLIT__
2026-01-12 07:26:50,435 - 11690 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-01-12 07:26:50,501 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:50,872 - 11690 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission in 0 batches - __SPLIT__
2026-01-12 07:26:50,938 - 11690 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-01-12 07:26:50,997 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 42 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:51,355 - 11690 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 42) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-01-12 07:26:52,560 - 11690 - src.utils.log - INFO - ✅ All 42 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-01-12 07:26:52,685 - 11690 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-01-12 07:26:52,750 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:53,103 - 11690 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-01-12 07:26:54,183 - 11690 - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-01-12 07:26:54,249 - 11690 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-01-12 07:26:54,310 - 11690 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 41 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:54,655 - 11690 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 41) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-01-12 07:26:55,947 - 11690 - src.utils.log - INFO - ✅ All 41 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-01-12 07:26:56,007 - 11690 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-01-12 07:26:56,063 - 11690 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 11690;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:56,405 - 11690 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-12 07:26:56,469 - 11690 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-01-12 07:26:56,527 - 11690 - src.utils.log - INFO - Time took to perform operation: 28.68 - __SPLIT__
2026-01-12 07:26:56,587 - 11690 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 11690;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:56,935 - 11690 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-12 07:26:57,004 - 11690 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-01-12 02:26:57.004' WHERE  
                    GenerateWorkOrderHistoryId = 11690;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-12 07:26:57,368 - 11690 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-01-05

Latest changes applied: tuple (2026-01-29)
