Python LogViewer

2026-04-14 14:44:48,753 - 56213 - src.utils.log - INFO - Unable to get work order table Error: "['EmployeeNo', 'CustomerPONumber'] not in index" - __SPLIT__
2026-04-14 14:44:49,421 - 56213 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-04-14 14:44:50,366 - 56213 - src.utils.log - INFO - Running deletes in PARALLEL… - __SPLIT__
2026-04-14 14:44:51,015 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationServices 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_0) - __SPLIT__
2026-04-14 14:44:51,017 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_1) - __SPLIT__
2026-04-14 14:44:51,017 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_2) - __SPLIT__
2026-04-14 14:44:51,017 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_3) - __SPLIT__
2026-04-14 14:44:51,017 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_4) - __SPLIT__
2026-04-14 14:44:51,017 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_5) - __SPLIT__
2026-04-14 14:44:51,018 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
        )
           (Thread: ThreadPoolExecutor-1_6) - __SPLIT__
2026-04-14 14:44:51,721 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:52,378 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:53,036 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:53,682 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:54,335 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:54,998 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:44:55,610 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:45:00,134 - 56213 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531)
           (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:00,875 - 56213 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-04-14 14:45:01,536 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  in (95745, 95751, 95763, 95264, 1597, 2625, 1628, 1636, 1637, 1642, 1682, 1683, 1685, 1686, 1694, 1696, 1697, 1698, 1707, 2223, 9392, 9393, 9426, 9427, 9429, 95452, 95468, 95469, 2298, 2300, 2319, 9493, 2336, 2339, 2346, 2354, 2363, 2365, 2367, 2368, 2371, 2372, 2373, 2374, 2375, 2376, 2378, 2379, 2382, 2383, 2388, 2389, 2393, 2394, 2395, 95067, 2401, 2402, 2434, 95651, 95652, 2470, 2480, 95160, 2490, 9152, 9153, 1477, 1478, 1480, 1482, 1483, 1485, 1486, 1487, 2511, 1490, 1491, 1493, 1494, 1495, 1496, 2527, 2532, 2533, 2538, 1528, 1530, 1531);... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:02,225 - 56213 - src.utils.log - INFO - ✅ Fetched 7 rows - __SPLIT__
2026-04-14 14:45:02,874 - 56213 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-04-14 14:45:03,830 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
         in (95745, 95763, 95751)... (Thread: ThreadPoolExecutor-2_0) - __SPLIT__
2026-04-14 14:45:03,831 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
     in (95745, 95763, 95751)... (Thread: ThreadPoolExecutor-2_1) - __SPLIT__
2026-04-14 14:45:03,833 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId in (95745, 95763, 95751)... (Thread: ThreadPoolExecutor-2_2) - __SPLIT__
2026-04-14 14:45:03,833 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId in (95745, 95763, 95751)... (Thread: ThreadPoolExecutor-2_3) - __SPLIT__
2026-04-14 14:45:03,835 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  in (95745, 95763, 95751);... (Thread: ThreadPoolExecutor-2_5) - __SPLIT__
2026-04-14 14:45:03,835 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  in (95745, 95763, 95751);... (Thread: ThreadPoolExecutor-2_4) - __SPLIT__
2026-04-14 14:45:03,835 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId in (95745, 95763, 95751);... (Thread: ThreadPoolExecutor-2_6) - __SPLIT__
2026-04-14 14:45:03,836 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId in (95745, 95763, 95751);... (Thread: ThreadPoolExecutor-2_7) - __SPLIT__
2026-04-14 14:45:04,535 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:05,216 - 56213 - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-04-14 14:45:05,889 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:06,565 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:07,235 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:07,919 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:08,609 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:09,267 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:09,913 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
         in (95745, 95763, 95751)... (Thread: ThreadPoolExecutor-2_0) - __SPLIT__
2026-04-14 14:45:15,371 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:16,074 - 56213 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56213;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:16,786 - 56213 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-14 14:45:17,750 - 56213 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
                        WorkOrderStatusDateTime = '2026-04-14 10:45:17.750' WHERE CompanyId = 80 AND 
                        GenerateWorkOrderHistoryId = 56213;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:18,438 - 56213 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-14 14:45:19,107 - 56213 - src.utils.log - INFO -  - __SPLIT__
2026-04-14 14:45:19,771 - 56213 - src.utils.log - INFO - Work order generation successful - Time took: 218.73 - __SPLIT__
2026-04-14 14:45:20,425 - 56213 - src.utils.log - INFO - Work order publish in progress for GenerateWorkOrderHistoryId: 56213 - __SPLIT__
2026-04-14 14:45:21,082 - 56213 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'InProgress', 
                    WoPublishStartDateTime = '2026-04-14 10:45:21.082' WHERE CompanyId = 80 AND 
                    GenerateWorkOrderHistoryId = 56213;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:21,787 - 56213 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-04-14 14:45:22,449 - 56213 - src.utils.log - INFO - 🔍 Fetching data: Select CreatedBy from ServiceCore.GenerateWorkOrderHistory
                         WHERE GenerateWorkOrderHistoryId = 56213;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:23,136 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:23,796 - 56213 - src.utils.log - INFO - Inside get_work_order_table - __SPLIT__
2026-04-14 14:45:24,456 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT DISTINCT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.ServiceCategoryMaster c ON c.DepartmentId = dm.DepartmentMasterId
                    JOIN ServiceCore.ServiceMaster sm ON c.CategoryId = sm.CategoryId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.ServiceId = sm.ServiceMasterId
                    WHERE dm.CompanyId = 80 AND d2.CompanyId = bm.CompanyId AND sss.ServiceSetupId in (95763, 95751, 95745)
                    AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:25,152 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:25,813 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    JOIN ServiceCore.SoldServiceNonStandard x on dm.DepartmentMasterId = x.DepartmentId
                    JOIN ServiceCore.ServiceSetupServices sss ON sss.NonStdSoldServiceId  = x.SoldServiceNonStandardId 
                    WHERE dm.CompanyId = 80 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId in (95763, 95751, 95745) AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:26,507 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:27,174 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT sss.ServiceSetupId, dm.DepartmentMasterId, bm.BranchMasterId FROM Common.DepartmentMaster dm
                    Inner JOIN Common.DivisionMaster d2 ON dm.DivisionMasterId = d2.DivisionMasterId
                    Inner JOIN Common.BranchMaster bm ON d2.BranchMasterId = bm.BranchMasterId
                    Inner JOIN [ServiceCore].[ServiceCategoryMaster] scm ON dm.DepartmentMasterId = scm.DepartmentId
                    Inner JOIN ServiceCore.ServiceMaster sm ON scm.CategoryId = sm.CategoryId
                    Inner JOIN ServiceCore.SoldServiceStandard x on x.ServiceId  =  sm.ServiceMasterId 
                    Inner JOIN ServiceCore.ServiceSetupServices sss ON sss.StdSoldServiceId  = x.SoldServiceStandardId 
                    WHERE dm.CompanyId = 80 AND d2.CompanyId = bm.CompanyId AND
                    sss.ServiceSetupId in (95763, 95751, 95745) AND sss.IsPrimary = 1;
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:27,870 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:28,540 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInvoiceSameAsWorkorder,BillingIsCreateInvoice FROM 
    Common.CompanyConfiguration cc WHERE cc.CompanyId = 80;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:29,232 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:29,888 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
    WHERE CompanyId = 80 AND EnitityNumberType in ('WorkOrder','Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:30,579 - 56213 - src.utils.log - INFO - ✅ Fetched 2 rows - __SPLIT__
2026-04-14 14:45:31,520 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT IsInvoiceSameAsWorkorder, BillingIsCreateInvoice
        FROM Common.CompanyConfiguration cc
        WHERE cc.CompanyId = 80;
    ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:32,206 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:32,860 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
            UPDATE Common.GenerateNumberConfig WITH (ROWLOCK)
            SET NextNumber = NextNumber + 5
            OUTPUT deleted.NextNumber AS StartNumber
            WHERE CompanyId = 80
              AND EnitityNumberType = 'WorkOrder';
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:33,541 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:34,195 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
            UPDATE Common.GenerateNumberConfig WITH (ROWLOCK)
            SET NextNumber = NextNumber + 5
            OUTPUT deleted.NextNumber AS StartNumber
            WHERE CompanyId = 80
              AND EnitityNumberType = 'Invoice';
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:34,878 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:35,537 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT ss.ServiceSetupId as SetupId, ss.FrequencyScheduleId as setup_frequency_schedule_id, ss.AccountNumber, ss.CompanyId, 
        ss.BillingLocationId, ss.ServiceLocationId, ss.TaxSysName, ss.TermId,  ss.TaxPercent, ss.PoNumber, ss.IsTaxExempt,
        ss.DisplayServiceAsSeparateLineItem, ss.GenerateInvoice, ss.IsGenerateInvoiceforInitalSetup, 
        ss.IsGenerateInvoiceforInitalSetupBilling, ss.IsBilling, t.NetDueIn, ptm.PaymentType, ssb.* 
        FROM ServiceCore.ServiceSetup ss LEFT JOIN ServiceCore.ServiceSetupBilling ssb 
        ON ss.ServiceSetupId = ssb.ServiceSetupId LEFT JOIN Billing.PaymentTypeMaster ptm ON 
        ptm.PaymentTypeMasterId = ssb.PaymentTypeMasterId left join Billing.Term t on ss.TermId = t.TermId 
        WHERE ss.ServiceSetupId in (95763, 95751, 95745)... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:36,223 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:36,880 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE 
    CompanyKey = 'dream.service';... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:37,582 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:38,239 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a 
        WHERE a.AccountNo in ('1166', '1161', '1194') and a.CompanyId = 71;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:38,929 - 56213 - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-04-14 14:45:39,583 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
                    SELECT WorkOrderNo FROM ServiceCore.WorkOrder
                    WHERE WorkOrderNo IN ('3476', '3477', '3478', '3479', '3480') AND CompanyId = 80
                ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:40,269 - 56213 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-04-14 14:45:40,921 - 56213 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 5 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:41,687 - 56213 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 5) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-04-14 14:45:42,544 - 56213 - src.utils.log - INFO - ✅ All 5 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-04-14 14:45:43,211 - 56213 - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-04-14 14:45:43,871 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT WorkorderId, WorkOrderNo 
                FROM ServiceCore.WorkOrder wo
                WHERE wo.WorkOrderNo IN ('3476', '3477', '3478', '3479', '3480')
                  AND wo.AccountNumber IN ('1194', '1161', '1166')
                  AND wo.CompanyId = 80
            ... (Thread: ThreadPoolExecutor-3_0) - __SPLIT__
2026-04-14 14:45:44,565 - 56213 - src.utils.log - INFO - ✅ Fetched 5 rows - __SPLIT__
2026-04-14 14:45:45,517 - 56213 - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-04-14 14:45:46,194 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
     cm WHERE CompanyId = 80;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:46,880 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:47,532 - 56213 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
        WHERE CompanyId = 80 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:48,213 - 56213 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-04-14 14:45:48,866 - 56213 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-04-14 14:45:49,521 - 56213 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 5 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:50,231 - 56213 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 5) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-04-14 14:45:51,013 - 56213 - src.utils.log - INFO - ✅ All 5 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-04-14 14:45:51,661 - 56213 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId IN (95763, 95751, 95745) AND WorkOrderNo IN (8123591, 4879242, 1418949, 6887012, 1492969) AND GenerateWorkOrderHistoryId = 56213;... (Thread: ThreadPoolExecutor-4_0) - __SPLIT__
2026-04-14 14:45:52,378 - 56213 - src.utils.log - INFO - ✅ Fetched 5 rows - __SPLIT__
2026-04-14 14:45:53,038 - 56213 - src.utils.log - INFO - 🏁 Final merged rows: 5 - __SPLIT__
2026-04-14 14:45:53,696 - 56213 - src.utils.log - INFO - Error: insert_all_publish_tables_parallel() takes 11 positional arguments but 12 were given - __SPLIT__
2026-04-14 14:45:54,346 - 56213 - src.utils.log - INFO - Time took to perform operation in publishing 56213: 253.97 - __SPLIT__
2026-04-14 14:45:55,002 - 56213 - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: 56213 - __SPLIT__
2026-04-14 14:45:55,654 - 56213 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-04-14 10:45:55.654' WHERE CompanyId = 80 AND 
                        GenerateWorkOrderHistoryId = 56213;... (Thread: AnyIO worker thread) - __SPLIT__
2026-04-14 14:45:56,343 - 56213 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-04-06

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