Python LogViewer

2026-10-17 10:29:42,662 - [29458] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT 
                WorkOrderAutoGenerationPublishHistoryId, 
                WorkOrderNo, 
                ServiceSetupId 
            FROM ServiceCore.WorkOrderAutoGenerationPublishHistory 
            WHERE ServiceSetupId = 70077
              AND WorkOrderNo = '228073'
              AND GenerateWorkOrderHistoryId = 29458;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:42,771 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:42,776 - [29458] - src.utils.log - INFO - Sequential Insertion in work order tables begin - __SPLIT__
2026-10-17 10:29:42,776 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:42,776 - [29458] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderServices: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:42,821 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderServices - __SPLIT__
2026-10-17 10:29:42,917 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderServices in 1 batches - __SPLIT__
2026-10-17 10:29:42,918 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderAppliedDiscount: - __SPLIT__
2026-10-17 10:29:42,918 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderSalesPersonCommission: - __SPLIT__
2026-10-17 10:29:42,918 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of ServiceAuto.WorkOrderCommissionAdjustment: - __SPLIT__
2026-10-17 10:29:42,918 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:42,918 - [29458] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderCrew: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:42,960 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderCrew - __SPLIT__
2026-10-17 10:29:43,053 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderCrew in 1 batches - __SPLIT__
2026-10-17 10:29:43,054 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:43,054 - [29458] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkorderSourceMapping: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,094 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkorderSourceMapping - __SPLIT__
2026-10-17 10:29:43,173 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkorderSourceMapping in 1 batches - __SPLIT__
2026-10-17 10:29:43,174 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-10-17 10:29:43,174 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:43,174 - [29458] - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationPublishServices: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,220 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderAutoGenerationPublishServices - __SPLIT__
2026-10-17 10:29:43,314 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationPublishServices in 1 batches - __SPLIT__
2026-10-17 10:29:43,315 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of Common.AppointmentNotificationEntityStageInfo: - __SPLIT__
2026-10-17 10:29:43,315 - [29458] - 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.BranchId,
        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 = 70077... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,339 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:43,344 - [29458] - src.utils.log - INFO - Size of Transaction: 1 - __SPLIT__
2026-10-17 10:29:43,346 - [29458] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,400 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-10-17 10:29:43,500 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-10-17 10:29:43,511 - [29458] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-10-17 10:29:43,512 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy, TransactionDate as InvoiceDate from Billing.[Transaction] t WHERE t.ModifiedBy = 12345678910 and t.CompanyId = 133 AND
         t.TransactionType ='Invoice' AND t.CreatedDate = '2026-10-17 06:29:43.341';... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,902 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:43,905 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 70077;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:43,929 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:43,937 - [29458] - src.utils.log - INFO - 📝 Executing: 
                    UPDATE Billing.[Transaction]
                    SET ModifiedBy = NULL
                    WHERE ModifiedBy = 12345678910
                    AND CreatedDate = '2026-10-17 06:29:43.341';
                ... (Thread: ThreadPoolExecutor-25_0) - __SPLIT__
2026-10-17 10:29:44,244 - [29458] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-10-17 10:29:44,248 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:44,248 - [29458] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,295 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into Billing.Invoice - __SPLIT__
2026-10-17 10:29:44,401 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-10-17 10:29:44,401 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceId, WorkOrderNo FROM Billing.Invoice i WHERE i.WorkOrderNo = '592062'... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,753 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:44,761 - [29458] - 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 = 70077 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,789 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:44,789 - [29458] - 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 = 70077 and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,817 - [29458] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-10-17 10:29:44,817 - [29458] - 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 = 70077  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,843 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:44,843 - [29458] - 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 = 70077  and sss.IsDeleted =0;  ... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,870 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:44,881 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 70077;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,905 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:44,909 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId, 
        AppliedDiscountAmt as AppliedDiscountAmount,IsActive ,ServiceSetupId  from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 70077;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,934 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:44,936 - [29458] - src.utils.log - INFO - 🔍 Fetching data: SELECT IsInitialSetupDiscount as IsInitial, DiscountSetupId,IsActive,DiscountAmount,
        IsDiscountPercent,DiscountPercent,DiscountDescription , ServiceSetupId from 
        ServiceCore.ServiceSetupAppliedDiscount ssad WHERE ssad.ServiceSetupId = 70077;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:44,961 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:44,961 - [29458] - src.utils.log - INFO - Sequential Insertion in invoice tables begin - __SPLIT__
2026-10-17 10:29:44,961 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-10-17 10:29:44,961 - [29458] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-10-17 10:29:44,961 - [29458] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,006 - [29458] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into Billing.InvoiceCharges - __SPLIT__
2026-10-17 10:29:45,102 - [29458] - src.utils.log - INFO - ✅ All 1 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-10-17 10:29:45,103 - [29458] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-10-17 10:29:45,103 - [29458] - src.utils.log - INFO - Invoice Publish Done - __SPLIT__
2026-10-17 10:29:45,103 - [29458] - src.utils.log - INFO - Updating Next GenerationDate - __SPLIT__
2026-10-17 10:29:45,103 - [29458] - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT ServiceSetupId, MAX(NextWorkOrderGenerationDate) AS MaxNextWorkOrderGeneration
            FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
            WHERE GenerateWorkOrderHistoryId = 29458
            GROUP BY ServiceSetupId;
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,128 - [29458] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-10-17 10:29:45,133 - [29458] - src.utils.log - INFO - 🔄 Updating next gen date sequentially: inside update_next_workorder_generation - __SPLIT__
2026-10-17 10:29:45,147 - [29458] - src.utils.log - INFO - 🛠 Creating temp table #tbl_871f2cc3da - __SPLIT__
2026-10-17 10:29:45,172 - [29458] - src.utils.log - INFO - 📌 Bulk inserting 1 rows into #tbl_871f2cc3da - __SPLIT__
2026-10-17 10:29:45,196 - [29458] - src.utils.log - INFO - 🔁 Running MERGE update to apply changes - __SPLIT__
2026-10-17 10:29:45,214 - [29458] - src.utils.log - INFO - ✔ SQL reported affected rows: 1 - __SPLIT__
2026-10-17 10:29:45,229 - [29458] - src.utils.log - INFO - 🔍 Verified successfully updated 1 rows via #tbl_871f2cc3da - __SPLIT__
2026-10-17 10:29:45,229 - [29458] - src.utils.log - INFO - 🎉 Successfully updated NextGenerationDate using temp table #tbl_871f2cc3da - __SPLIT__
2026-10-17 10:29:45,229 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: 
                DELETE FROM ServiceCore.WorkOrderSkipMonthAutoGeneration
                WHERE GenerateWorkOrderHistoryId = 29458
               (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,253 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,253 - [29458] - src.utils.log - INFO - Sequential deletion from temp tables begin - __SPLIT__
2026-10-17 10:29:45,253 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationServices WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,280 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,281 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCrews WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,306 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,306 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,330 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,330 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,404 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,404 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,448 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,448 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.SubWorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,474 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,474 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,497 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,498 - [29458] - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM ServiceCore.WorkOrderAutoGeneration WHERE WorkOrderAutoGenerationId = 763509   (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,529 - [29458] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-10-17 10:29:45,529 - [29458] - src.utils.log - INFO - Work order published ids: (763509,) - __SPLIT__
2026-10-17 10:29:45,529 - [29458] - src.utils.log - INFO - Time took to perform operation in publishing [29458]: 4.38 - __SPLIT__
2026-10-17 10:29:45,529 - [29458] - src.utils.log - INFO - Publish Completed for GenerateWorkOrderHistoryId: [29458] - __SPLIT__
2026-10-17 10:29:45,529 - [29458] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory SET PublishStatus = 'Completed', 
                        PublishStatusDateTime = '2026-10-17 06:29:45.529' WHERE CompanyId = 133 AND 
                        GenerateWorkOrderHistoryId = 29458;... (Thread: AnyIO worker thread) - __SPLIT__
2026-10-17 10:29:45,554 - [29458] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
app.log.2026-10-12

Latest changes applied: added logs (2026-10-30)
