Python LogViewer

2026-04-07 10:53:16,088 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:17,134 - 56193 - src.utils.log - INFO - Generating work orders for setup: 95739 - __SPLIT__
2026-04-07 10:53:17,860 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11461;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:18,551 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:19,258 - 56193 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-04-07 10:53:19,940 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=145 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:20,635 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:21,307 - 56193 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-04-07 10:53:21,981 - 56193 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-04-07 10:53:22,656 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:23,383 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:24,058 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:24,772 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:25,445 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:26,164 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:26,836 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:27,581 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:28,251 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:28,973 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:29,636 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:30,357 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:31,332 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 95739
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:32,038 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:32,712 - 56193 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 95739
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:33,453 - 56193 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-07 10:53:34,114 - 56193 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-07 10:53:34,787 - 56193 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:35,518 - 56193 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-04-07 10:53:36,430 - 56193 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-04-07 10:53:37,103 - 56193 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 9 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-04-02 12:12:09.096'
    and ServiceSetupId = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:37,814 - 56193 - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-04-07 10:53:38,483 - 56193 - src.utils.log - INFO - Id's of work order inserted to DB: [507579 507580 507581 507582 507583 507584 507585 507586 507587] - __SPLIT__
2026-04-07 10:53:39,152 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 95739;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:39,847 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:40,523 - 56193 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-04-07 10:53:41,192 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:41,883 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:42,552 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:43,252 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:43,931 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:44,647 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:45,604 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:46,307 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:46,980 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 95739... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:47,673 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:48,337 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 95739;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:49,035 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:49,703 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 95739;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:50,403 - 56193 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-07 10:53:51,082 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 95739;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:52,405 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:53,077 - 56193 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 95739;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:53,774 - 56193 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-07 10:53:54,453 - 56193 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-04-07 10:53:55,125 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-04-07 10:53:55,792 - 56193 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-04-07 10:53:56,465 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-04-07 10:53:57,144 - 56193 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-04-07 10:53:57,815 - 56193 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-07 10:53:58,490 - 56193 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN ('507581', '507579', '507587', '507582', '507580', '507584', '507583', '507585', '507586')
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:53:59,185 - 56193 - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-04-07 10:54:00,157 - 56193 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SetupAutoGenerationSourceMapping: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:00,881 - 56193 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SetupAutoGenerationSourceMapping in 0 batches - __SPLIT__
2026-04-07 10:54:01,583 - 56193 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-04-07 10:54:02,254 - 56193 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-07 10:54:02,929 - 56193 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (507584, 507585, 507586, 507587, 507580, 507581, 507582, 507583)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:03,633 - 56193 - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-04-07 10:54:04,303 - 56193 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationAppliedDiscount: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:05,043 - 56193 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into ServiceCore.WorkOrderAutoGenerationAppliedDiscount - __SPLIT__
2026-04-07 10:54:05,829 - 56193 - src.utils.log - INFO - ✅ All 8 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationAppliedDiscount in 1 batches - __SPLIT__
2026-04-07 10:54:06,504 - 56193 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-04-07 10:54:07,196 - 56193 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-07 10:54:07,875 - 56193 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (507584, 507585, 507586, 507587, 507579, 507580, 507581, 507582, 507583)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:08,572 - 56193 - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-04-07 10:54:09,240 - 56193 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrderAutoGeneration: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:09,963 - 56193 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into ServiceCore.SubWorkOrderAutoGeneration - __SPLIT__
2026-04-07 10:54:10,774 - 56193 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-04-07 10:54:11,449 - 56193 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-04-07 10:54:12,132 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-04-07 10:54:12,802 - 56193 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-04-07 10:54:13,471 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-04-07 10:54:14,438 - 56193 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-04-07 10:54:15,127 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCrews: - __SPLIT__
2026-04-07 10:54:15,793 - 56193 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-04-07 10:54:16,457 - 56193 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationServices: - __SPLIT__
2026-04-07 10:54:17,130 - 56193 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-04-07 10:54:17,797 - 56193 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-07 10:54:18,467 - 56193 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:19,181 - 56193 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-04-07 10:54:19,954 - 56193 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-04-07 10:54:20,621 - 56193 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-04-07 10:54:21,291 - 56193 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56193;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:21,980 - 56193 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-07 10:54:22,651 - 56193 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-04-07 10:54:23,313 - 56193 - src.utils.log - INFO - Time took to perform operation: 79.05 - __SPLIT__
2026-04-07 10:54:23,977 - 56193 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56193;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:24,666 - 56193 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-07 10:54:25,338 - 56193 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-04-07 06:54:25.338' WHERE  
                    GenerateWorkOrderHistoryId = 56193;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-07 10:54:26,035 - 56193 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-03-30

Latest changes applied: fixed table name (2026-04-28)
