Python LogViewer

2026-06-29 19:42:12,020 - [26411] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishHistory: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:12,747 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into ServiceCore.WorkOrderAutoGenerationPublishHistory - __SPLIT__
2026-06-29 19:42:13,561 - [26411] - src.utils.log - INFO - ✅ All 8 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishHistory in 1 batches - __SPLIT__
2026-06-29 19:42:14,217 - [26411] - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT 
            WorkOrderAutoGenerationPublishHistoryId,
            WorkOrderNo,
            ServiceSetupId
        FROM ServiceCore.WorkOrderAutoGenerationPublishHistory
        WHERE
    ServiceSetupId IN (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855) AND WorkOrderNo IN ('4474745', '4788382', '4864279', '2890857', '8669002', '5419888', '7325730', '2161381') AND GenerateWorkOrderHistoryId = 26411;... (Thread: ThreadPoolExecutor-11_0) - __SPLIT__
2026-06-29 19:42:15,000 - [26411] - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-06-29 19:42:15,666 - [26411] - src.utils.log - INFO - 🏁 Final merged rows: 8 - __SPLIT__
2026-06-29 19:42:16,334 - [26411] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-06-29 19:42:16,993 - [26411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-29 19:42:17,656 - [26411] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 15 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:18,372 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 15) into ServiceCore.WorkOrderServices - __SPLIT__
2026-06-29 19:42:19,189 - [26411] - src.utils.log - INFO - ✅ All 15 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-06-29 19:42:19,848 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderAppliedDiscount: - __SPLIT__
2026-06-29 19:42:20,506 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderSalesPersonCommission: - __SPLIT__
2026-06-29 19:42:21,170 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-06-29 19:42:22,134 - [26411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-29 19:42:22,803 - [26411] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:23,521 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-06-29 19:42:24,308 - [26411] - src.utils.log - INFO - ✅ All 8 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-06-29 19:42:24,981 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkorderSourceMapping: - __SPLIT__
2026-06-29 19:42:25,652 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-06-29 19:42:26,319 - [26411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-29 19:42:26,994 - [26411] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 15 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:27,895 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 15) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-06-29 19:42:28,705 - [26411] - src.utils.log - INFO - ✅ All 15 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-06-29 19:42:29,375 - [26411] - 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 (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855)... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:30,079 - [26411] - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-06-29 19:42:30,758 - [26411] - src.utils.log - INFO - Size of Transaction: 8 - __SPLIT__
2026-06-29 19:42:31,428 - [26411] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:32,164 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-06-29 19:42:32,963 - [26411] - src.utils.log - INFO - ✅ All 8 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-06-29 19:42:33,649 - [26411] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-06-29 19:42:34,323 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911, 12345678912, 12345678913, 12345678914, 12345678915, 12345678916, 12345678917)  and t.CompanyId = 133 AND 
        t.TransactionType ='Invoice' AND t.CreatedDate = '2026-06-29 15:42:30.754';... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:35,379 - [26411] - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-06-29 19:42:36,058 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  in (67854, 67855, 67856, 67857, 67859, 67860, 67861, 67867);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:37,051 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:37,727 - [26411] - src.utils.log - INFO - 📝 Executing: 
                    UPDATE Billing.[Transaction]
                    SET ModifiedBy = NULL
                    WHERE ModifiedBy IN (12345678910,12345678911,12345678912,12345678913,12345678914,12345678915,12345678916,12345678917)
                    AND CreatedDate = '2026-06-29 15:42:30.754';
                ... (Thread: ThreadPoolExecutor-12_0) - __SPLIT__
2026-06-29 19:42:38,729 - [26411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-29 19:42:39,406 - [26411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-29 19:42:40,076 - [26411] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 8 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:40,795 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 8) into Billing.Invoice - __SPLIT__
2026-06-29 19:42:41,582 - [26411] - src.utils.log - INFO - ✅ All 8 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-06-29 19:42:42,251 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo in ('534000', '534002', '533999', '533998', '533995', '533996', '533997', '534001')... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:43,414 - [26411] - src.utils.log - INFO - ✅ Fetched 8 rows - __SPLIT__
2026-06-29 19:42:44,092 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.Name as  NonStandardServiceName, sm.Description , sm.ServiceMasterId as ServiceId
        FROM ServiceCore.ServiceSetupServices sss join ServiceCore.ServiceMaster sm on sm.ServiceMasterId = sss.ServiceId 
        where ServiceSetupId in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855) and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:44,796 - [26411] - src.utils.log - INFO - ✅ Fetched 15 rows - __SPLIT__
2026-06-29 19:42:45,474 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.Name as  NonStandardServiceName, sm.Description , sm.ServiceMasterId as ServiceId
        FROM ServiceCore.ServiceSetupInitialServices sss join ServiceCore.ServiceMaster sm on sm.ServiceMasterId = sss.ServiceId 
        where ServiceSetupId in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855) and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:46,176 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:46,845 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.servicename as  NonStandardServiceName, sm.Description , sss.ServiceId
        FROM ServiceCore.ServiceSetupServices sss join ServiceCore.SoldServiceNonStandard sm on sm.SoldServiceNonStandardId = sss.NonStdSoldServiceId 
        where ServiceSetupId in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855)  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:47,550 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:48,217 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT sss.ServiceSetupId, sss.NonStdSoldServiceId as SoldServiceNonStandardId, sss.Qty as Quantity, 
        sss.Price as Rate, sss.IsTaxable, sm.servicename as  NonStandardServiceName, sm.Description , sss.ServiceId
        FROM ServiceCore.ServiceSetupInitialServices sss join ServiceCore.SoldServiceNonStandard sm on sm.SoldServiceNonStandardId = sss.NonStdSoldServiceId 
        where ServiceSetupId in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855)  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:48,921 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:49,600 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:50,306 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:50,989 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId, 
        AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId  from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:51,981 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:52,650 - [26411] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
        IsDiscountPercent,DiscountPercent,DiscountDescription, ServiceSetupId from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId  in (67859, 67860, 67861, 67857, 67856, 67854, 67867, 67855);... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:53,358 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:42:54,035 - [26411] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-06-29 19:42:54,701 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-06-29 19:42:55,370 - [26411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-29 19:42:56,042 - [26411] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 15 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:42:56,782 - [26411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 15) into Billing.InvoiceCharges - __SPLIT__
2026-06-29 19:42:57,587 - [26411] - src.utils.log - INFO - ✅ All 15 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-06-29 19:42:58,259 - [26411] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-06-29 19:42:58,923 - [26411] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-06-29 19:42:59,597 - [26411] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-06-29 19:43:00,273 - [26411] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 26411
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:00,992 - [26411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-29 19:43:01,666 - [26411] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-06-29 19:43:02,353 - [26411] - src.utils.log - INFO - 🛠 Creating temp table #tbl_fa236f53b1 - __SPLIT__
2026-06-29 19:43:03,053 - [26411] - src.utils.log - INFO - 📌 Bulk inserting 8 rows into #tbl_fa236f53b1 - __SPLIT__
2026-06-29 19:43:03,856 - [26411] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-06-29 19:43:04,543 - [26411] - src.utils.log - INFO - ✔ SQL reported affected rows: 8 - __SPLIT__
2026-06-29 19:43:05,236 - [26411] - src.utils.log - INFO - 🔍 Verified successfully updated 8 rows via #tbl_fa236f53b1 - __SPLIT__
2026-06-29 19:43:06,191 - [26411] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_fa236f53b1 - __SPLIT__
2026-06-29 19:43:06,851 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 26411
               (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:07,549 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:08,215 - [26411] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-06-29 19:43:08,883 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:09,574 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:10,244 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:10,962 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:11,627 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:12,330 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:13,001 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:13,813 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:14,477 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:15,201 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:15,865 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:16,568 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:17,235 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:17,934 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:18,598 - [26411] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId in (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038)   (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:19,349 - [26411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-29 19:43:20,317 - [26411] - src.utils.log - INFO - Work order published ids: (694031, 694032, 694033, 694034, 694035, 694036, 694037, 694038) - __SPLIT__
2026-06-29 19:43:20,975 - [26411] - src.utils.log - INFO - Time took to perform operation in publishing [26411]: 114.64 - __SPLIT__
2026-06-29 19:43:21,646 - [26411] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [26411] - __SPLIT__
2026-06-29 19:43:22,311 - [26411] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-06-29 15:43:20.317' WHERE CompanyId = 133 AND 
                        GenerateWorkOrderHistoryId = 26411;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-29 19:43:23,002 - [26411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-06-15

Latest changes applied: invoice generation failed message (2026-06-18)
