Python LogViewer

2026-01-23 08:32:30,095 - [123896] - src.utils.log - INFO - 📥 Inserting into Billing.DiscountApplied: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:30,368 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into Billing.DiscountApplied in 0 batches - __SPLIT__
2026-01-23 08:32:30,368 - [123896] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-01-23 08:32:30,370 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT x.CompanyId FROM CRM.CompanyMaster x WHERE 
    CompanyKey = 'abcdallas';... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:30,642 - [123896] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-23 08:32:30,643 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT CollectionStatus,IsHold,AccountNo FROM CRM.Account a 
        WHERE a.AccountNo = '14554' and a.CompanyId = 121;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:30,916 - [123896] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-23 08:32:30,918 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrder (skip triggers): 92 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:31,364 - [123896] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 92) into ServiceCore.WorkOrder (triggers skipped) - __SPLIT__
2026-01-23 08:32:33,639 - [123896] - src.utils.log - INFO - ✅ All 92 rows inserted successfully into ServiceCore.WorkOrder in 1 batches (triggers skipped) - __SPLIT__
2026-01-23 08:32:33,776 - [123896] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-01-23 08:32:33,777 - [123896] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.ServiceSetup SET IsInitialWoGenerated = 1
                         WHERE CompanyId = 133 AND 
                        ServiceSetupId = 149754;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:34,054 - [123896] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-01-23 08:32:34,055 - [123896] - src.utils.log - INFO - 🔍 Fetching data: 
                SELECT WorkorderId, WorkOrderNo 
                FROM ServiceCore.WorkOrder wo
                WHERE wo.WorkOrderNo IN ('1302106', '1302107', '1302108', '1302109', '1302110', '1302111', '1302112', '1302113', '1302114', '1302115', '1302116', '1302117', '1302118', '1302119', '1302120', '1302121', '1302122', '1302123', '1302124', '1302125', '1302126', '1302127', '1302128', '1302129', '1302130', '1302131', '1302132', '1302133', '1302134', '1302135', '1302136', '1302137', '1302138', '1302139', '1302140', '1302141', '1302142', '1302143', '1302144', '1302145', '1302146', '1302147', '1302148', '1302149', '1302150', '1302151', '1302152', '1302153', '1302154', '1302155', '1302156', '1302157', '1302158', '1302159', '1302160', '1302161', '1302162', '1302163', '1302164', '1302165', '1302166', '1302167', '1302168', '1302169', '1302170', '1302171', '1302172', '1302173', '1302174', '1302175', '1302176', '1302177', '1302178', '1302179', '1302180', '1302181', '1302182', '1302183', '1302184', '1302185', '1302186', '1302187', '1302188', '1302189', '1302190', '1302191', '1302192', '1302193', '1302194', '1302195', '1302196', '1302197')
                  AND wo.AccountNumber = '14554'
                  AND wo.CompanyId = 133
            ... (Thread: ThreadPoolExecutor-38_0) - __SPLIT__
2026-01-23 08:32:34,354 - [123896] - src.utils.log - INFO - ✅ Fetched 92 rows - __SPLIT__
2026-01-23 08:32:34,355 - [123896] - src.utils.log - INFO - Sequential fetching temp table records - __SPLIT__
2026-01-23 08:32:34,355 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationServices woag WHERE woag.WorkOrderAutoGenerationId
     in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:34,651 - [123896] - src.utils.log - INFO - ✅ Fetched 92 rows - __SPLIT__
2026-01-23 08:32:34,651 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SubWorkOrderAutoGeneration woag WHERE woag.WorkOrderAutoGenerationId
     in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:34,937 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:34,937 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationCrews woag WHERE woag.WorkOrderAutoGenerationId
     in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:35,226 - [123896] - src.utils.log - INFO - ✅ Fetched 92 rows - __SPLIT__
2026-01-23 08:32:35,226 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.WorkOrderAutoGenerationSalesPersonCommission woag WHERE woag.WorkOrderAutoGenerationId
     in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:35,511 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:35,512 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from ServiceCore.SetupAutoGenerationSourceMapping woag WHERE woag.WorkOrderAutoGenerationId
     in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:35,799 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:35,799 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  DiscountType, DiscountCode, DiscountAmount, DiscountDescription, DiscountName, IsActive,
                CreatedBy, ModifiedBy, CreatedDate, ModifiedDate, DiscountPercent, IsDiscountPercent, 
                AppliedDiscountAmt, ApplyOnPartPrice, ApplyOnLaborPrice,  DiscountSetupId, WorkOrderAutoGenerationId 
                from ServiceCore.WorkOrderAutoGenerationAppliedDiscount woag WHERE woag.WorkOrderAutoGenerationId 
                in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:36,108 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:36,108 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT  * from CRM.LeadNote woag WHERE woag.RefId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150) and
         woag.RefType = 'TempWorkorder';... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:36,487 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:36,487 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM  ServiceCore.WorkOrderAutoGenerationCommissionAdjustment woagca 
        WHERE woagca.WorkOrderAutoGenerationId  in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150);... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:36,771 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:36,774 - [123896] - src.utils.log - INFO - Updating temp tables - __SPLIT__
2026-01-23 08:32:36,786 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyKey FROM Common.CompanyMaster
     cm WHERE CompanyId = 133;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:37,059 - [123896] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-23 08:32:37,060 - [123896] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc 
        WHERE CompanyId = 133 AND EnitityNumberType in ('SubWorkOrder'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:37,333 - [123896] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-01-23 08:32:37,337 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 92 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:37,636 - [123896] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 92) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-01-23 08:32:39,450 - [123896] - src.utils.log - INFO - ✅ All 92 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-01-23 08:32:39,452 - [123896] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId = 149754 AND WorkOrderNo IN ('551735', '5755973', '9440661', '9158928', '9966852', '3255774', '8184906', '8105380', '9537517', '2853367', '4922199', '2954550', '7290707', '1770903', '2824931', '9238147', '8124787', '8097653', '4823989', '3957115', '3352510', '2951135', '3941799', '3916816', '1096824', '2675085', '1295482', '5868828', '8766746', '5169630', '9473903', '7558242', '2212130', '7086567', '2719543', '2692904', '4779811', '2484221', '9678128', '3208472', '4143831', '6006483', '7498111', '5311781', '1388924', '1574436', '5532340', '5924477', '3573109', '2967029', '7434168', '7527721', '7619385', '6005706', '3532140', '3119183', '6541992', '2964388', '8260498', '4296331', '3098628', '7794136', '5890360', '2358187', '8450428', '3928527', '9560281', '8479965', '3606853', '6723353', '6122531', '5938771', '4059105', '3813832', '4753536', '8566444', '3702558', '7534827', '8114558', '5455546', '1309542', '8570871', '5453038', '1062812', '8344336', '5673676', '1434306', '1300555', '7108310', '4689892', '8010798', '5145283') AND GenerateWorkOrderHistoryId = 123896;... (Thread: ThreadPoolExecutor-39_0) - __SPLIT__
2026-01-23 08:32:39,767 - [123896] - src.utils.log - INFO - ✅ Fetched 92 rows - __SPLIT__
2026-01-23 08:32:39,768 - [123896] - src.utils.log - INFO - 🏁 Final merged rows: 92 - __SPLIT__
2026-01-23 08:32:39,774 - [123896] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-01-23 08:32:39,774 - [123896] - src.utils.log - INFO - 📥 Inserting into CRM.LeadNote: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:40,047 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into CRM.LeadNote in 0 batches - __SPLIT__
2026-01-23 08:32:40,048 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderAppliedDiscount: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:40,321 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderAppliedDiscount in 0 batches - __SPLIT__
2026-01-23 08:32:40,322 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderSalesPersonCommission: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:40,595 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkOrderSalesPersonCommission in 0 batches - __SPLIT__
2026-01-23 08:32:40,595 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceAuto.WorkOrderCommissionAdjustment: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:40,870 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceAuto.WorkOrderCommissionAdjustment in 0 batches - __SPLIT__
2026-01-23 08:32:40,870 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 92 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:41,151 - [123896] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 92) into ServiceCore.WorkOrderServices - __SPLIT__
2026-01-23 08:32:42,292 - [123896] - src.utils.log - INFO - ✅ All 92 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-01-23 08:32:42,292 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.SubWorkOrder: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:42,567 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.SubWorkOrder in 0 batches - __SPLIT__
2026-01-23 08:32:42,567 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 92 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:42,846 - [123896] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 92) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-01-23 08:32:43,888 - [123896] - src.utils.log - INFO - ✅ All 92 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-01-23 08:32:43,888 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkorderSourceMapping: 0 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:44,162 - [123896] - src.utils.log - INFO - ✅ All 0 rows inserted successfully into ServiceCore.WorkorderSourceMapping in 0 batches - __SPLIT__
2026-01-23 08:32:44,162 - [123896] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 92 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:44,443 - [123896] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 92) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-01-23 08:32:45,599 - [123896] - src.utils.log - INFO - ✅ All 92 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-01-23 08:32:45,600 - [123896] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-01-23 08:32:45,600 - [123896] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 123896
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:45,877 - [123896] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-01-23 08:32:45,883 - [123896] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-01-23 08:32:46,020 - [123896] - src.utils.log - INFO - 🛠 Creating temp table #tbl_0b1731f4ba - __SPLIT__
2026-01-23 08:32:46,297 - [123896] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_0b1731f4ba - __SPLIT__
2026-01-23 08:32:46,571 - [123896] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-01-23 08:32:46,719 - [123896] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-01-23 08:32:46,865 - [123896] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_0b1731f4ba - __SPLIT__
2026-01-23 08:32:46,865 - [123896] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_0b1731f4ba - __SPLIT__
2026-01-23 08:32:46,865 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 123896
               (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:47,138 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:47,138 - [123896] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-01-23 08:32:47,138 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:47,440 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:47,440 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:47,734 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:47,734 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:48,015 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:48,015 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:48,324 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:48,324 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:48,610 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:48,611 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:48,894 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:48,894 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:49,176 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:49,177 - [123896] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150)   (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:49,636 - [123896] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-01-23 08:32:49,636 - [123896] - src.utils.log - INFO - Work order published ids: (3166059, 3166060, 3166061, 3166062, 3166063, 3166064, 3166065, 3166066, 3166067, 3166068, 3166069, 3166070, 3166071, 3166072, 3166073, 3166074, 3166075, 3166076, 3166077, 3166078, 3166079, 3166080, 3166081, 3166082, 3166083, 3166084, 3166085, 3166086, 3166087, 3166088, 3166089, 3166090, 3166091, 3166092, 3166093, 3166094, 3166095, 3166096, 3166097, 3166098, 3166099, 3166100, 3166101, 3166102, 3166103, 3166104, 3166105, 3166106, 3166107, 3166108, 3166109, 3166110, 3166111, 3166112, 3166113, 3166114, 3166115, 3166116, 3166117, 3166118, 3166119, 3166120, 3166121, 3166122, 3166123, 3166124, 3166125, 3166126, 3166127, 3166128, 3166129, 3166130, 3166131, 3166132, 3166133, 3166134, 3166135, 3166136, 3166137, 3166138, 3166139, 3166140, 3166141, 3166142, 3166143, 3166144, 3166145, 3166146, 3166147, 3166148, 3166149, 3166150) - __SPLIT__
2026-01-23 08:32:49,636 - [123896] - src.utils.log - INFO - Time took to perform operation in publishing [123896]: 35.7 - __SPLIT__
2026-01-23 08:32:49,636 - [123896] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [123896] - __SPLIT__
2026-01-23 08:32:49,636 - [123896] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-01-23 03:32:49.636' WHERE CompanyId = 133 AND 
                        GenerateWorkOrderHistoryId = 123896;... (Thread: AnyIO worker thread) - __SPLIT__
2026-01-23 08:32:49,912 - [123896] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-01-19

Latest changes applied: tuple (2026-01-29)
