2026-02-13 05:59:44,648 - 123974 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-13 05:59:45,199 - 123974 - src.utils.log - INFO - Generating work orders for setup: 149877 - __SPLIT__
2026-02-13 05:59:45,412 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * FROM COMMON.RangeofTime where RangeofTimeId = 11428;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:45,674 - 123974 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-13 05:59:45,802 - 123974 - src.utils.log - INFO - Updating Next Gen Date - __SPLIT__
2026-02-13 05:59:45,837 - 123974 - src.utils.log - INFO - π Fetching data: SELECT WoStatusId From ServiceCore.WorkOrderStatus wos where CompanyId=133 and
[SysName]= 'Incomplete' ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:46,098 - 123974 - src.utils.log - INFO - β
Fetched 1 rows - __SPLIT__
2026-02-13 05:59:46,102 - 123974 - src.utils.log - INFO - Deleting duplicate records - __SPLIT__
2026-02-13 05:59:46,102 - 123974 - src.utils.log - INFO - Running deletes SEQUENTIALLY⦠- __SPLIT__
2026-02-13 05:59:46,103 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationServices
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:46,381 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:46,382 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:46,666 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:46,667 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:46,932 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:46,932 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:47,211 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:47,212 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:47,536 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:47,537 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:47,803 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:47,803 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
WHERE WorkOrderAutoGenerationId IN (
SELECT WorkOrderAutoGenerationId
FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
)
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:48,065 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:48,065 - 123974 - src.utils.log - INFO - ποΈ Deleting records:
DELETE FROM ServiceCore.WorkOrderAutoGeneration
WHERE ServiceSetupId = 149877
(Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:48,360 - 123974 - src.utils.log - INFO - β
Records deleted successfully - __SPLIT__
2026-02-13 05:59:48,360 - 123974 - src.utils.log - INFO - π Inserting 27 work orders for route: 1 - __SPLIT__
2026-02-13 05:59:48,360 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGeneration: 27 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:48,678 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 27) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-02-13 05:59:50,862 - 123974 - src.utils.log - INFO - β
All 27 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-02-13 05:59:50,863 - 123974 - src.utils.log - INFO - π Fetching data: Select TOP 27 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-02-11 16:22:17.623'
and ServiceSetupId = 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:51,138 - 123974 - src.utils.log - INFO - β
Fetched 27 rows - __SPLIT__
2026-02-13 05:59:51,139 - 123974 - src.utils.log - INFO - β
Work order IDs inserted for route 1: 27 records - __SPLIT__
2026-02-13 05:59:51,139 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE
ssswo.ServiceSetupId = 149877;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:51,400 - 123974 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-13 05:59:51,400 - 123974 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-02-13 05:59:51,401 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
= 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:51,664 - 123974 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-13 05:59:51,664 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
= 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:51,927 - 123974 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-13 05:59:51,935 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
= 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:52,203 - 123974 - src.utils.log - INFO - β
Fetched 3 rows - __SPLIT__
2026-02-13 05:59:52,204 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where
ServiceSetupId = 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:52,467 - 123974 - src.utils.log - INFO - β
Fetched 4 rows - __SPLIT__
2026-02-13 05:59:52,469 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where
ServiceSetupId = 149877... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:52,730 - 123974 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-13 05:59:52,730 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE
ServiceSetupId = 149877;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:52,993 - 123974 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-13 05:59:52,994 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE
ServiceSetupId = 149877;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:53,256 - 123974 - src.utils.log - INFO - β
Fetched 2 rows - __SPLIT__
2026-02-13 05:59:53,257 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE
EntityType = 'Setup' AND ServiceSetupId = 149877;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:53,536 - 123974 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-13 05:59:53,536 - 123974 - src.utils.log - INFO - π Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 149877;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:53,799 - 123974 - src.utils.log - INFO - β
Fetched 0 rows - __SPLIT__
2026-02-13 05:59:53,822 - 123974 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-02-13 05:59:53,822 - 123974 - src.utils.log - INFO - π₯ Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:54,110 - 123974 - src.utils.log - INFO - β
All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-02-13 05:59:54,110 - 123974 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-02-13 05:59:54,110 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.CommunicationPreferencesServiceReportNotification: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:54,394 - 123974 - src.utils.log - INFO - β
All 0 rows inserted successfully into ServiceCore.CommunicationPreferencesServiceReportNotification in 0 batches - __SPLIT__
2026-02-13 05:59:54,395 - 123974 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-02-13 05:59:54,395 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.SetupAutoGenerationSourceMapping: 54 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:54,681 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 54) into ServiceCore.SetupAutoGenerationSourceMapping - __SPLIT__
2026-02-13 05:59:55,474 - 123974 - src.utils.log - INFO - β
All 54 rows inserted successfully into ServiceCore.SetupAutoGenerationSourceMapping in 1 batches - __SPLIT__
2026-02-13 05:59:55,474 - 123974 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-02-13 05:59:55,474 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationAppliedDiscount: 27 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:55,765 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 27) into ServiceCore.WorkOrderAutoGenerationAppliedDiscount - __SPLIT__
2026-02-13 05:59:56,773 - 123974 - src.utils.log - INFO - β
All 27 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationAppliedDiscount in 1 batches - __SPLIT__
2026-02-13 05:59:56,773 - 123974 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-02-13 05:59:56,773 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.SubWorkOrderAutoGeneration: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:57,056 - 123974 - src.utils.log - INFO - β
All 0 rows inserted successfully into ServiceCore.SubWorkOrderAutoGeneration in 0 batches - __SPLIT__
2026-02-13 05:59:57,056 - 123974 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-02-13 05:59:57,056 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:57,339 - 123974 - src.utils.log - INFO - β
All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCommissionAdjustment in 0 batches - __SPLIT__
2026-02-13 05:59:57,339 - 123974 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-02-13 05:59:57,340 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: 54 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:57,627 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 54) into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission - __SPLIT__
2026-02-13 05:59:58,590 - 123974 - src.utils.log - INFO - β
All 54 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationSalesPersonCommission in 1 batches - __SPLIT__
2026-02-13 05:59:58,591 - 123974 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-02-13 05:59:58,591 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 54 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 05:59:58,878 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 54) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-02-13 05:59:59,825 - 123974 - src.utils.log - INFO - β
All 54 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-02-13 05:59:59,825 - 123974 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-02-13 05:59:59,826 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationServices: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 06:00:00,124 - 123974 - src.utils.log - INFO - β
All 0 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 0 batches - __SPLIT__
2026-02-13 06:00:00,124 - 123974 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-02-13 06:00:00,124 - 123974 - src.utils.log - INFO - π₯ Inserting into ServiceCore.WorkOrderAutoGenerationServices: 54 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 06:00:00,394 - 123974 - src.utils.log - INFO - π€ Inserting batch 1/1 (0 to 54) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-02-13 06:00:01,388 - 123974 - src.utils.log - INFO - β
All 54 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-02-13 06:00:01,388 - 123974 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-02-13 06:00:01,388 - 123974 - src.utils.log - INFO - β
Temp tables populated for route: 1 - __SPLIT__
2026-02-13 06:00:01,389 - 123974 - src.utils.log - INFO - β
Route 1 generation complete - __SPLIT__
2026-02-13 06:00:01,389 - 123974 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 123974;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 06:00:01,651 - 123974 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-13 06:00:01,651 - 123974 - src.utils.log - INFO - β±οΈ Total time: 22.49s | Status: Completed - __SPLIT__
2026-02-13 06:00:01,651 - 123974 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 123974;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 06:00:01,912 - 123974 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-13 06:00:01,912 - 123974 - src.utils.log - INFO - π Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET
WorkOrderStatusDateTime = '2026-02-13 01:00:01.912' WHERE
GenerateWorkOrderHistoryId = 123974;... (Thread: AnyIO worker thread) - __SPLIT__
2026-02-13 06:00:02,176 - 123974 - src.utils.log - INFO - β
Command executed successfully - __SPLIT__
2026-02-13 06:00:02,177 - 123974 - src.utils.log - INFO - π Connection pool closed - __SPLIT__