Python LogViewer

2026-04-17 07:51:46,551 - 12026 - src.utils.log - INFO - ✅ Fetched 60 rows - __SPLIT__
2026-04-17 07:51:46,616 - 12026 - src.utils.log - INFO - Found the Setups and Frequencies - __SPLIT__
2026-04-17 07:51:46,693 - 12026 - src.utils.log - INFO - Inside work order function - __SPLIT__
2026-04-17 07:51:46,766 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:47,109 - 12026 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-17 07:51:47,176 - 12026 - 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-01-01 00:00:00' and 
        ServiceDate <= '2031-12-31 00:00:00' and ServiceSetupId = 23663 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:47,542 - 12026 - src.utils.log - INFO - ✅ Fetched 16 rows - __SPLIT__
2026-04-17 07:51:48,253 - 12026 - src.utils.log - INFO - Generating work orders for setup: 23663 - __SPLIT__
2026-04-17 07:51:49,655 - 12026 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-04-17 07:51:49,725 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=135 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:50,072 - 12026 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-17 07:51:50,135 - 12026 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-04-17 07:51:50,199 - 12026 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-04-17 07:51:50,259 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:50,837 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:50,894 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:51,401 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:51,461 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:51,916 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:51,984 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:52,833 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:52,898 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:53,387 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:53,447 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:54,517 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:54,585 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 23663
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:54,960 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:55,081 - 12026 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 23663
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:55,640 - 12026 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-17 07:51:55,709 - 12026 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-17 07:51:55,778 - 12026 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 48 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:56,186 - 12026 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 48) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-04-17 07:51:59,043 - 12026 - src.utils.log - INFO - ✅ All 48 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-04-17 07:51:59,110 - 12026 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 48 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-04-10 12:03:22.412'
    and ServiceSetupId = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:59,471 - 12026 - src.utils.log - INFO - ✅ Fetched 48 rows - __SPLIT__
2026-04-17 07:51:59,542 - 12026 - src.utils.log - INFO - Id's of work order inserted to DB: [2727333 2727334 2727335 2727336 2727337 2727338 2727339 2727340 2727341
 2727342 2727343 2727344 2727345 2727346 2727347 2727348 2727349 2727350
 2727351 2727352 2727353 2727354 2727355 2727356 2727357 2727358 2727359
 2727360 2727361 2727362 2727363 2727364 2727365 2727366 2727367 2727368
 2727369 2727370 2727371 2727372 2727373 2727374 2727375 2727376 2727377
 2727378 2727379 2727380] - __SPLIT__
2026-04-17 07:51:59,612 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:51:59,964 - 12026 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-17 07:52:00,039 - 12026 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-04-17 07:52:00,113 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:00,469 - 12026 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-17 07:52:00,533 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:00,891 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:00,954 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:01,288 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:01,359 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:01,709 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:01,836 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 23663... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:02,189 - 12026 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-17 07:52:02,267 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:02,626 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:02,695 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:03,045 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:03,114 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:04,237 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:04,310 - 12026 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 23663;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:04,663 - 12026 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-17 07:52:04,738 - 12026 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-04-17 07:52:04,808 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-04-17 07:52:04,873 - 12026 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-04-17 07:52:04,943 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-04-17 07:52:05,014 - 12026 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-04-17 07:52:05,085 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SetupAutoGenerationSourceMapping: - __SPLIT__
2026-04-17 07:52:05,156 - 12026 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-04-17 07:52:05,220 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-04-17 07:52:05,282 - 12026 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-04-17 07:52:05,345 - 12026 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-17 07:52:05,465 - 12026 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (2727333, 2727334, 2727335, 2727336, 2727337, 2727338, 2727339, 2727340, 2727341, 2727342, 2727343, 2727344, 2727345, 2727346, 2727347, 2727348, 2727349, 2727350, 2727351, 2727352, 2727353, 2727354, 2727355, 2727356, 2727357, 2727358, 2727359, 2727360, 2727361, 2727362, 2727363, 2727364, 2727365, 2727366, 2727367, 2727368, 2727369, 2727370, 2727371, 2727372, 2727373, 2727374, 2727375, 2727376, 2727377, 2727378, 2727379, 2727380)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:05,829 - 12026 - src.utils.log - INFO - ✅ Fetched 48 rows - __SPLIT__
2026-04-17 07:52:05,892 - 12026 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrderAutoGeneration: 48 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:06,274 - 12026 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 48) into ServiceCore.SubWorkOrderAutoGeneration - __SPLIT__
2026-04-17 07:52:09,012 - 12026 - src.utils.log - INFO - ✅ All 48 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-04-17 07:52:09,086 - 12026 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-04-17 07:52:09,156 - 12026 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-17 07:52:09,226 - 12026 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (2727333, 2727334, 2727335, 2727336, 2727337, 2727338, 2727339, 2727340, 2727341, 2727342, 2727343, 2727344, 2727345, 2727346, 2727347, 2727348, 2727349, 2727350, 2727351, 2727352, 2727353, 2727354, 2727355, 2727356, 2727357, 2727358, 2727359, 2727360, 2727361, 2727362, 2727363, 2727364, 2727365, 2727366, 2727367, 2727368, 2727369, 2727370, 2727371, 2727372, 2727373, 2727374, 2727375, 2727376, 2727377, 2727378, 2727379, 2727380)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:09,591 - 12026 - src.utils.log - INFO - ✅ Fetched 48 rows - __SPLIT__
2026-04-17 07:52:09,658 - 12026 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: 48 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:10,040 - 12026 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 48) into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment - __SPLIT__
2026-04-17 07:52:10,982 - 12026 - src.utils.log - INFO - ✅ All 48 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment in 1 batches - __SPLIT__
2026-04-17 07:52:11,053 - 12026 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-04-17 07:52:11,119 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-04-17 07:52:11,185 - 12026 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-04-17 07:52:11,252 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCrews: - __SPLIT__
2026-04-17 07:52:11,321 - 12026 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-04-17 07:52:11,389 - 12026 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationServices: - __SPLIT__
2026-04-17 07:52:11,458 - 12026 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-04-17 07:52:11,521 - 12026 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-17 07:52:11,641 - 12026 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 48 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:12,009 - 12026 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 48) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-04-17 07:52:13,286 - 12026 - src.utils.log - INFO - ✅ All 48 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-04-17 07:52:13,356 - 12026 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-04-17 07:52:13,424 - 12026 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 12026;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:13,813 - 12026 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-17 07:52:13,879 - 12026 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-04-17 07:52:13,955 - 12026 - src.utils.log - INFO - Time took to perform operation: 31.33 - __SPLIT__
2026-04-17 07:52:14,018 - 12026 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 12026;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:14,364 - 12026 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-17 07:52:14,440 - 12026 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-04-17 03:52:14.440' WHERE  
                    GenerateWorkOrderHistoryId = 12026;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-17 07:52:14,787 - 12026 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-04-06

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