2026-02-05 13:46:26,853 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149822 - __SPLIT__
2026-02-05 13:46:26,930 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149842 - __SPLIT__
2026-02-05 13:46:27,046 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149843 - __SPLIT__
2026-02-05 13:46:27,143 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149845 - __SPLIT__
2026-02-05 13:46:27,230 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149846 - __SPLIT__
2026-02-05 13:46:27,366 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149847 - __SPLIT__
2026-02-05 13:46:27,454 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149848 - __SPLIT__
2026-02-05 13:46:27,545 - 123942 - src.utils.log - INFO - Generating work orders for setup: 149850 - __SPLIT__
2026-02-05 13:46:27,678 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId in (1132.0, 11437.0, -1.0);... (Thread: ThreadPoolExecutor-24_4) - __SPLIT__
2026-02-05 13:46:28,008 - 123942 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-05 13:46:28,090 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId in (11426.0, 11427.0, 11428.0, 1127.0, 1130.0, 11435.0, 1132.0, 1133.0, 1131.0);... (Thread: ThreadPoolExecutor-24_4) - __SPLIT__
2026-02-05 13:46:28,425 - 123942 - src.utils.log - INFO - β
Fetched 9 rows - __SPLIT__
2026-02-05 13:46:28,622 - 123942 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-02-05 13:46:28,704 - 123942 - src.utils.log - INFO - π Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=133 and
[SysName]= 'Incomplete' ;... (Thread: ThreadPoolExecutor-24_4) - __SPLIT__
2026-02-05 13:46:29,051 - 123942 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-05 13:46:29,127 - 123942 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-02-05 13:46:29,191 - 123942 - src.utils.log - INFO - Running deletes in PARALLEL⦠- __SPLIT__
2026-02-05 13:46:29,258 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationServices
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_0) - __SPLIT__
2026-02-05 13:46:29,260 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_1) - __SPLIT__
2026-02-05 13:46:29,260 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_2) - __SPLIT__
2026-02-05 13:46:29,260 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_3) - __SPLIT__
2026-02-05 13:46:29,260 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_4) - __SPLIT__
2026-02-05 13:46:29,261 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_5) - __SPLIT__
2026-02-05 13:46:29,261 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
)
(Thread: ThreadPoolExecutor-25_6) - __SPLIT__
2026-02-05 13:46:29,632 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:29,773 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:29,782 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:29,883 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:29,930 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:29,964 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:30,020 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:30,199 - 123942 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:30,705 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:30,775 - 123942 - src.utils.log - INFO - ποΈ Deleting records: delete FROM [ServiceCore].[WorkOrderSkipMonthAutoGeneration]
WHERE ServiceSetupId= 149839 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:31,113 - 123942 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-05 13:46:31,174 - 123942 - src.utils.log - INFO - Deleted WorkOrderSkipMonthAutoGeneration entry - __SPLIT__
2026-02-05 13:46:31,240 - 123942 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderSkipMonthAutoGeneration: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:31,617 - 123942 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderSkipMonthAutoGeneration - __SPLIT__
2026-02-05 13:46:32,531 - 123942 - src.utils.log - INFO - β
All 1 rows inserted successfully into ServiceCore.WorkOrderSkipMonthAutoGeneration in 1 batches - __SPLIT__
2026-02-05 13:46:32,606 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId in (36892, 53806, 39481, 58443, 129618, 22612, 58456, 58460, 34910, 58462, 129633, 58472, 51356, 119474, 119476, 119480, 32958, 58567, 149703, 58571, 48334, 149711, 149715, 58580, 55510, 149719, 149721, 149737, 149738, 33004, 46320, 149753, 149755, 149756, 149759, 149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 53525, 58649, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149839, 149842, 149843, 149845, 149846, 149847, 58712, 149848, 149850, 149855, 149857, 46434, 47462, 139663, 69019, 48573, 58306, 44538);... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:32,954 - 123942 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-05 13:46:33,016 - 123942 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-02-05 13:46:33,083 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759)... (Thread: ThreadPoolExecutor-26_0) - __SPLIT__
2026-02-05 13:46:33,083 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759)... (Thread: ThreadPoolExecutor-26_1) - __SPLIT__
2026-02-05 13:46:33,083 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where
ServiceSetupId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759)... (Thread: ThreadPoolExecutor-26_2) - __SPLIT__
2026-02-05 13:46:33,083 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where
ServiceSetupId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759)... (Thread: ThreadPoolExecutor-26_3) - __SPLIT__
2026-02-05 13:46:33,084 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE
ServiceSetupId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759);... (Thread: ThreadPoolExecutor-26_4) - __SPLIT__
2026-02-05 13:46:33,086 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE
ServiceSetupId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759);... (Thread: ThreadPoolExecutor-26_5) - __SPLIT__
2026-02-05 13:46:33,086 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE
EntityType = 'Setup' AND ServiceSetupId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759);... (Thread: ThreadPoolExecutor-26_6) - __SPLIT__
2026-02-05 13:46:33,086 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759);... (Thread: ThreadPoolExecutor-26_7) - __SPLIT__
2026-02-05 13:46:33,423 - 123942 - src.utils.log - INFO - β
Fetched 126 rows - __SPLIT__
2026-02-05 13:46:33,496 - 123942 - src.utils.log - INFO - β
Fetched 82 rows - __SPLIT__
2026-02-05 13:46:33,561 - 123942 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-05 13:46:33,613 - 123942 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-05 13:46:33,668 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
in (149760, 149761, 149762, 149763, 149764, 149765, 149766, 149767, 149768, 149769, 149770, 149771, 149772, 149773, 149774, 149775, 149776, 149787, 149788, 149789, 149790, 149794, 149795, 149796, 149797, 149798, 149799, 149800, 149801, 149802, 149803, 149804, 149805, 149806, 149807, 149809, 149810, 149811, 149812, 149813, 149814, 149815, 149816, 149817, 149818, 149819, 149820, 149821, 149822, 149703, 149711, 149842, 149715, 149843, 149845, 149846, 149847, 149848, 149721, 149850, 149719, 149855, 149857, 149737, 149738, 149753, 149755, 149756, 149759)... (Thread: ThreadPoolExecutor-26_0) - __SPLIT__
2026-02-05 13:46:33,687 - 123942 - src.utils.log - INFO - β
Fetched 32 rows - __SPLIT__
2026-02-05 13:46:33,747 - 123942 - src.utils.log - INFO - β
Fetched 6 rows - __SPLIT__
2026-02-05 13:46:33,838 - 123942 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-05 13:46:33,887 - 123942 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-05 13:46:34,251 - 123942 - src.utils.log - INFO - β
Fetched 17 rows - __SPLIT__
2026-02-05 13:46:34,351 - 123942 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 123942;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:34,688 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-05 13:46:34,752 - 123942 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
WorkOrderStatusDateTime = '2026-02-05 08:46:34.752' WHERE CompanyId = 133 AND
GenerateWorkOrderHistoryId = 123942;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:35,074 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-05 13:46:35,139 - 123942 - src.utils.log - INFO - - __SPLIT__
2026-02-05 13:46:35,230 - 123942 - src.utils.log - INFO - Work order generation successful - Time took: 30.07 - __SPLIT__
2026-02-05 13:46:35,297 - 123942 - src.utils.log - INFO - Work order publish in progress for GenerateWorkOrderHistoryId: 123942 - __SPLIT__
2026-02-05 13:46:35,363 - 123942 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'InProgress',
WoPublishStartDateTime = '2026-02-05 08:46:35.363' WHERE CompanyId = 133 AND
GenerateWorkOrderHistoryId = 123942;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:35,694 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-05 13:46:35,768 - 123942 - src.utils.log - INFO - π Fetching data: Select CreatedBy from ServiceCore.GenerateWorkOrderHistory
WHERE GenerateWorkOrderHistoryId = 123942;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:36,105 - 123942 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-05 13:46:36,169 - 123942 - src.utils.log - INFO - Inside get_work_order_table - __SPLIT__
2026-02-05 13:46:36,288 - 123942 - 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 = 133 AND d2.CompanyId = bm.CompanyId AND sss.ServiceSetupId in (149759, 149857, 149788, 149789, 149737, 149711, 149703, 149855, 149721, 149715, 149848, 149847, 149846, 149845, 149843, 149842, 149787, 149850, 149753, 149766, 149794, 149767, 149763, 149797, 149795, 149765, 149796, 149764, 149803, 149755, 149802, 149801, 149804, 149807, 149806, 149805, 149719, 149760, 149800, 149799, 149762, 149798, 149761, 149790, 149738, 149822, 149770, 149821, 149820, 149772, 149773, 149774, 149769, 149812, 149811, 149810, 149809, 149771, 149756, 149768, 149776, 149775, 149819, 149818, 149817, 149816, 149815, 149814, 149813)
AND sss.IsPrimary = 1;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:36,640 - 123942 - src.utils.log - INFO - β
Fetched 69 rows - __SPLIT__
2026-02-05 13:46:36,702 - 123942 - 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 = 133 AND d2.CompanyId = bm.CompanyId AND
sss.ServiceSetupId in (149759, 149857, 149788, 149789, 149737, 149711, 149703, 149855, 149721, 149715, 149848, 149847, 149846, 149845, 149843, 149842, 149787, 149850, 149753, 149766, 149794, 149767, 149763, 149797, 149795, 149765, 149796, 149764, 149803, 149755, 149802, 149801, 149804, 149807, 149806, 149805, 149719, 149760, 149800, 149799, 149762, 149798, 149761, 149790, 149738, 149822, 149770, 149821, 149820, 149772, 149773, 149774, 149769, 149812, 149811, 149810, 149809, 149771, 149756, 149768, 149776, 149775, 149819, 149818, 149817, 149816, 149815, 149814, 149813) AND sss.IsPrimary = 1;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:37,056 - 123942 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-05 13:46:37,126 - 123942 - 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 = 133 AND d2.CompanyId = bm.CompanyId AND
sss.ServiceSetupId in (149759, 149857, 149788, 149789, 149737, 149711, 149703, 149855, 149721, 149715, 149848, 149847, 149846, 149845, 149843, 149842, 149787, 149850, 149753, 149766, 149794, 149767, 149763, 149797, 149795, 149765, 149796, 149764, 149803, 149755, 149802, 149801, 149804, 149807, 149806, 149805, 149719, 149760, 149800, 149799, 149762, 149798, 149761, 149790, 149738, 149822, 149770, 149821, 149820, 149772, 149773, 149774, 149769, 149812, 149811, 149810, 149809, 149771, 149756, 149768, 149776, 149775, 149819, 149818, 149817, 149816, 149815, 149814, 149813) AND sss.IsPrimary = 1;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:37,487 - 123942 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-05 13:46:37,565 - 123942 - src.utils.log - INFO - π Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 133 AND EnitityNumberType in ('WorkOrder','Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:37,898 - 123942 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-05 13:46:37,963 - 123942 - src.utils.log - INFO - π Fetching data: SELECT IsInvoiceSameAsWorkorder,BillingIsCreateInvoice FROM
Common.CompanyConfiguration cc WHERE cc.CompanyId = 133;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:38,299 - 123942 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-05 13:46:38,369 - 123942 - src.utils.log - INFO - π Executing: UPDATE Common.GenerateNumberConfig SET NextNumber = '1312227'
WHERE CompanyId = 133 AND EnitityNumberType in ('WorkOrder');... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:38,723 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-05 13:46:38,792 - 123942 - src.utils.log - INFO - π Executing: UPDATE Common.GenerateNumberConfig SET NextNumber = '1369584'
WHERE CompanyId = 133 AND EnitityNumberType in ('Invoice');... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:39,128 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-05 13:46:39,200 - 123942 - 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 (149759, 149857, 149788, 149789, 149737, 149711, 149703, 149855, 149721, 149715, 149848, 149847, 149846, 149845, 149843, 149842, 149787, 149850, 149753, 149766, 149794, 149767, 149763, 149797, 149795, 149765, 149796, 149764, 149803, 149755, 149802, 149801, 149804, 149807, 149806, 149805, 149719, 149760, 149800, 149799, 149762, 149798, 149761, 149790, 149738, 149822, 149770, 149821, 149820, 149772, 149773, 149774, 149769, 149812, 149811, 149810, 149809, 149771, 149756, 149768, 149776, 149775, 149819, 149818, 149817, 149816, 149815, 149814, 149813)... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:39,543 - 123942 - src.utils.log - INFO - β
Fetched 69 rows - __SPLIT__
2026-02-05 13:46:39,728 - 123942 - src.utils.log - INFO - Size of Transaction: 127 - __SPLIT__
2026-02-05 13:46:39,796 - 123942 - src.utils.log - INFO - π₯ Inserting into Billing.Transaction (skip triggers): 127 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:40,260 - 123942 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 127) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-02-05 13:46:42,115 - 123942 - src.utils.log - INFO - π Triggers re-enabled for session - __SPLIT__
2026-02-05 13:46:42,231 - 123942 - src.utils.log - ERROR - β Error in insertion: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot insert the value NULL into column 'TransactionDate', table 'pstrmcore.Billing.Transaction'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW)")
[SQL: INSERT INTO [Billing].[Transaction] ([CompanyId], [BillingAddressId], [ServiceAddressId], [Notes], [CreatedBy], [TransactionDate], [AccountNo], [TransactionType], [IsActive], [IsDelete], [CreatedDate], [ModifiedDate], [ModifiedBy]) VALUES (?, ?, ?, ? ... 5094 characters truncated ... ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (133, 6990718, 6990717, None, 43135, Timestamp('2026-02-23 00:00:00'), '14555', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678910, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678911, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678912, 133, 6990647, 6990646, None, 43135, Timestamp('2026-03-23 00:00:00'), '14520', 'Invoice', 1, 0, '2026-02-05 08:46:39.722' ... 1551 parameters truncated ... 6990743, None, 43135, Timestamp('2026-02-13 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679033, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-16 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679034, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-20 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679035, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-06 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679036)]
(Background on this error at: https://sqlalche.me/e/20/gkpj) - __SPLIT__
2026-02-05 13:46:42,293 - 123942 - src.utils.log - ERROR - β insert_into_with_skip_triggers failed after 1 attempts: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot insert the value NULL into column 'TransactionDate', table 'pstrmcore.Billing.Transaction'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW)")
[SQL: INSERT INTO [Billing].[Transaction] ([CompanyId], [BillingAddressId], [ServiceAddressId], [Notes], [CreatedBy], [TransactionDate], [AccountNo], [TransactionType], [IsActive], [IsDelete], [CreatedDate], [ModifiedDate], [ModifiedBy]) VALUES (?, ?, ?, ? ... 5094 characters truncated ... ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (133, 6990718, 6990717, None, 43135, Timestamp('2026-02-23 00:00:00'), '14555', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678910, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678911, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678912, 133, 6990647, 6990646, None, 43135, Timestamp('2026-03-23 00:00:00'), '14520', 'Invoice', 1, 0, '2026-02-05 08:46:39.722' ... 1551 parameters truncated ... 6990743, None, 43135, Timestamp('2026-02-13 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679033, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-16 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679034, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-20 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679035, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-06 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679036)]
(Background on this error at: https://sqlalche.me/e/20/gkpj) - __SPLIT__
2026-02-05 13:46:42,362 - 123942 - src.utils.log - INFO - Error: (pyodbc.IntegrityError) ('23000', "[23000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot insert the value NULL into column 'TransactionDate', table 'pstrmcore.Billing.Transaction'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW)")
[SQL: INSERT INTO [Billing].[Transaction] ([CompanyId], [BillingAddressId], [ServiceAddressId], [Notes], [CreatedBy], [TransactionDate], [AccountNo], [TransactionType], [IsActive], [IsDelete], [CreatedDate], [ModifiedDate], [ModifiedBy]) VALUES (?, ?, ?, ? ... 5094 characters truncated ... ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (133, 6990718, 6990717, None, 43135, Timestamp('2026-02-23 00:00:00'), '14555', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678910, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678911, 133, 6980569, 6980568, None, 43135, Timestamp('2026-03-04 00:00:00'), '14479', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345678912, 133, 6990647, 6990646, None, 43135, Timestamp('2026-03-23 00:00:00'), '14520', 'Invoice', 1, 0, '2026-02-05 08:46:39.722' ... 1551 parameters truncated ... 6990743, None, 43135, Timestamp('2026-02-13 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679033, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-16 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679034, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-20 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679035, 133, 6990744, 6990743, None, 43135, Timestamp('2026-02-06 00:00:00'), '14568', 'Invoice', 1, 0, '2026-02-05 08:46:39.722', '2026-02-05 08:46:39.722', 12345679036)]
(Background on this error at: https://sqlalche.me/e/20/gkpj) - __SPLIT__
2026-02-05 13:46:42,426 - 123942 - src.utils.log - INFO - Time took to perform operation in publishing 123942: 37.36 - __SPLIT__
2026-02-05 13:46:42,505 - 123942 - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: 123942 - __SPLIT__
2026-02-05 13:46:42,571 - 123942 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-02-05 08:46:42.571' WHERE CompanyId = 133 AND
GenerateWorkOrderHistoryId = 123942;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-05 13:46:42,925 - 123942 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__