Python LogViewer

2026-05-28 13:59:04,835 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:05,161 - 124490 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 13:59:05,277 - 124490 - 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 <= '2027-12-31 00:00:00' and ServiceSetupId = 56234 and wo.IsActive = 1 and wos.Name 
        not in ('Void', 'Cancelled');... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:05,603 - 124490 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 13:59:06,221 - 124490 - src.utils.log - INFO - Generating work orders for setup: 56234 - __SPLIT__
2026-05-28 13:59:06,314 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11429;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:06,651 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:06,763 - 124490 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-05-28 13:59:06,843 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=133 and 
    [SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:07,171 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:07,240 - 124490 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-05-28 13:59:07,312 - 124490 - src.utils.log - INFO - Running deletes SEQUENTIALLY… - __SPLIT__
2026-05-28 13:59:07,375 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:07,735 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:07,808 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:08,240 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:08,311 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:08,649 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:08,727 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:09,080 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:09,149 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:09,498 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:09,619 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:09,966 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:10,036 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 56234
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:10,360 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:10,426 - 124490 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 56234
           (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:11,056 - 124490 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-28 13:59:11,131 - 124490 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 13:59:11,203 - 124490 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:11,607 - 124490 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-05-28 13:59:12,755 - 124490 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-05-28 13:59:12,826 - 124490 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 4 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-05-19 18:23:20.402'
    and ServiceSetupId = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:13,227 - 124490 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 13:59:13,299 - 124490 - src.utils.log - INFO - Id's of work order inserted to DB: [3679424 3679425 3679426 3679427] - __SPLIT__
2026-05-28 13:59:13,365 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:13,700 - 124490 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 13:59:13,769 - 124490 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-05-28 13:59:13,834 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:14,159 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:14,229 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:14,571 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:14,795 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:15,138 - 124490 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-05-28 13:59:15,212 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:15,545 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:15,619 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 56234... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:15,941 - 124490 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 13:59:16,014 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:16,381 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:16,451 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:16,789 - 124490 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-28 13:59:16,865 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:17,232 - 124490 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 13:59:17,307 - 124490 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 56234;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:17,635 - 124490 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-28 13:59:17,733 - 124490 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-05-28 13:59:17,801 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-05-28 13:59:17,870 - 124490 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-05-28 13:59:17,936 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-05-28 13:59:18,002 - 124490 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-05-28 13:59:18,092 - 124490 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 13:59:18,218 - 124490 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN ('3679426', '3679424', '3679427', '3679425')
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:18,561 - 124490 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 13:59:18,646 - 124490 - src.utils.log - INFO - 📥 Inserting into ServiceCore.SetupAutoGenerationSourceMapping: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:18,985 - 124490 - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SetupAutoGenerationSourceMapping in 0 batches - __SPLIT__
2026-05-28 13:59:19,056 - 124490 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-05-28 13:59:19,123 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-05-28 13:59:19,199 - 124490 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-05-28 13:59:19,265 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SubWorkOrderAutoGeneration: - __SPLIT__
2026-05-28 13:59:19,339 - 124490 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-28 13:59:19,409 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-05-28 13:59:19,478 - 124490 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-05-28 13:59:19,547 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-05-28 13:59:19,615 - 124490 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-05-28 13:59:19,683 - 124490 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 13:59:19,749 - 124490 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (3679424, 3679425, 3679426, 3679427)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:20,084 - 124490 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 13:59:20,158 - 124490 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:20,493 - 124490 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-05-28 13:59:21,485 - 124490 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-05-28 13:59:21,556 - 124490 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-05-28 13:59:21,670 - 124490 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationServices: - __SPLIT__
2026-05-28 13:59:21,734 - 124490 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-28 13:59:21,798 - 124490 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-28 13:59:21,870 - 124490 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (3679424, 3679425, 3679426, 3679427)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:22,191 - 124490 - src.utils.log - INFO - ✅ Fetched 4 rows - __SPLIT__
2026-05-28 13:59:22,263 - 124490 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 4 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:22,601 - 124490 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 4) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-05-28 13:59:23,597 - 124490 - src.utils.log - INFO - ✅ All 4 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-05-28 13:59:23,659 - 124490 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-05-28 13:59:23,721 - 124490 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 124490;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:24,048 - 124490 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 13:59:24,112 - 124490 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-05-28 13:59:24,188 - 124490 - src.utils.log - INFO - Time took to perform operation: 25.13 - __SPLIT__
2026-05-28 13:59:24,256 - 124490 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 124490;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:24,589 - 124490 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-28 13:59:24,684 - 124490 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                    WorkOrderStatusDateTime = '2026-05-28 09:59:24.684' WHERE  
                    GenerateWorkOrderHistoryId = 124490;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-28 13:59:25,013 - 124490 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-05-18

Latest changes applied: updated rounding logics (2026-06-15)
