2026-06-16 13:22:23,995 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:24,671 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationSalesPersonCommission 
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 105946
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:25,407 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:26,118 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationAppliedDiscount
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 105946
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:26,848 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:27,524 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SetupAutoGenerationSourceMapping
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 105946
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:28,246 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:28,926 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.SubWorkOrderAutoGeneration
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 105946
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:29,980 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:30,663 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGenerationCommissionAdjustment
        WHERE WorkOrderAutoGenerationId IN (
            SELECT WorkOrderAutoGenerationId 
            FROM ServiceCore.WorkOrderAutoGeneration 
            WHERE ServiceSetupId = 105946
        )
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:31,369 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:32,048 - 56457 - src.utils.log - INFO - 🗑️ Deleting records: 
        DELETE FROM ServiceCore.WorkOrderAutoGeneration 
        WHERE ServiceSetupId = 105946
           (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:37,013 - 56457 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-06-16 13:22:37,688 - 56457 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-16 13:22:38,371 - 56457 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGeneration: 113 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:39,107 - 56457 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 113) into ServiceCore.WorkOrderAutoGeneration - __SPLIT__
2026-06-16 13:22:40,524 - 56457 - src.utils.log - INFO - ✅ All 113 rows inserted successfully into ServiceCore.WorkOrderAutoGeneration in 1 batches - __SPLIT__
2026-06-16 13:22:41,204 - 56457 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 113 WorkOrderAutoGenerationId, ServiceSetupId , ModifiedBy,
    ModifiedDate, IsInitial From ServiceCore.WorkOrderAutoGeneration WHERE ModifiedDate='2026-06-10 12:12:22.357'
    and ServiceSetupId = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:41,937 - 56457 - src.utils.log - INFO - ✅ Fetched 113 rows - __SPLIT__
2026-06-16 13:22:42,610 - 56457 - src.utils.log - INFO - Id's of work order inserted to DB: [578575 578576 578577 578578 578579 578580 578581 578582 578583 578584
 578585 578586 578587 578588 578589 578590 578591 578592 578593 578594
 578595 578596 578597 578598 578599 578600 578601 578602 578603 578604
 578605 578606 578607 578608 578609 578610 578611 578612 578613 578614
 578615 578616 578617 578618 578619 578620 578621 578622 578623 578624
 578625 578626 578627 578628 578629 578630 578631 578632 578633 578634
 578635 578636 578637 578638 578639 578640 578641 578642 578643 578644
 578645 578646 578647 578648 578649 578650 578651 578652 578653 578654
 578655 578656 578657 578658 578659 578660 578661 578662 578663 578664
 578665 578666 578667 578668 578669 578670 578671 578672 578673 578674
 578675 578676 578677 578678 578679 578680 578681 578682 578683 578684
 578685 578686 578687] - __SPLIT__
2026-06-16 13:22:43,294 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSubWorkOrder ssswo WHERE 
     ssswo.ServiceSetupId  = 105946;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:43,999 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:44,679 - 56457 - src.utils.log - INFO - Inside get_remaining_temp_tables - __SPLIT__
2026-06-16 13:22:45,353 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.serviceSetupServices sss where ServiceSetupId
                = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:46,056 - 56457 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:22:46,732 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from servicecore.ServiceSetupInitialServices sss where ServiceSetupId
                = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:47,434 - 56457 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:22:48,118 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCrew ssc where ServiceSetupId
      = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:49,110 - 56457 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:22:49,783 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupSalesPersonCommission ssspc where 
    ServiceSetupId = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:50,474 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:51,146 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.ServiceSetupCommissionAdjustment ssspc where 
    ServiceSetupId = 105946... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:51,836 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:52,505 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.serviceSetupAppliedDiscount WHERE 
     ServiceSetupId  = 105946;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:53,200 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:53,867 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.SetupSourceMapping WHERE 
     ServiceSetupId  = 105946;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:54,562 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:55,236 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM [ServiceCore].[CommunicationPreferencesServiceReportNotification] WITH(NOLOCK) WHERE 
        EntityType = 'Setup' AND ServiceSetupId = 105946;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:55,943 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:56,609 - 56457 - src.utils.log - INFO - 🔍 Fetching data: SELECT * From CRM.LeadNote WHERE RefType = 'Setup' and RefId = 105946;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:22:57,298 - 56457 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:22:57,979 - 56457 - src.utils.log - INFO - Inside insert_data_in_temp_tables for work order generation - __SPLIT__
2026-06-16 13:22:58,643 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of CRM.LeadNote: - __SPLIT__
2026-06-16 13:22:59,308 - 56457 - src.utils.log - INFO - leadNoteDf inserted to dream DB - __SPLIT__
2026-06-16 13:22:59,975 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.CommunicationPreferencesServiceReportNotification: - __SPLIT__
2026-06-16 13:23:00,643 - 56457 - src.utils.log - INFO - CommunicationPreferencesServiceReportNotification inserted to dream DB - __SPLIT__
2026-06-16 13:23:01,315 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SetupAutoGenerationSourceMapping: - __SPLIT__
2026-06-16 13:23:01,983 - 56457 - src.utils.log - INFO - SetupAutoGenerationSourceMapping inserted to dream DB - __SPLIT__
2026-06-16 13:23:02,936 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationAppliedDiscount: - __SPLIT__
2026-06-16 13:23:03,607 - 56457 - src.utils.log - INFO - WorkOrderAutoGenerationAppliedDiscount inserted to dream DB - __SPLIT__
2026-06-16 13:23:04,288 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.SubWorkOrderAutoGeneration: - __SPLIT__
2026-06-16 13:23:04,959 - 56457 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-06-16 13:23:05,631 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationCommissionAdjustment: - __SPLIT__
2026-06-16 13:23:06,302 - 56457 - src.utils.log - INFO - SubWorkOrderAutoGeneration inserted to dream DB - __SPLIT__
2026-06-16 13:23:06,973 - 56457 - src.utils.log - INFO - 📥 Empty dataframe of ServiceCore.WorkOrderAutoGenerationSalesPersonCommission: - __SPLIT__
2026-06-16 13:23:07,648 - 56457 - src.utils.log - INFO - WorkOrderAutoGenerationSalesPersonCommission_df inserted to dream DB - __SPLIT__
2026-06-16 13:23:08,322 - 56457 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-16 13:23:08,996 - 56457 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId = 578575
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:09,687 - 56457 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:23:10,364 - 56457 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationCrews: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:11,073 - 56457 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderAutoGenerationCrews - __SPLIT__
2026-06-16 13:23:11,851 - 56457 - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationCrews in 1 batches - __SPLIT__
2026-06-16 13:23:12,520 - 56457 - src.utils.log - INFO - WorkOrderAutoGenerationCrews inserted to dream DB - __SPLIT__
2026-06-16 13:23:13,198 - 56457 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-16 13:23:13,873 - 56457 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId = 578575
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:14,562 - 56457 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:23:15,237 - 56457 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 1 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:15,938 - 56457 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 1) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-06-16 13:23:16,995 - 56457 - src.utils.log - INFO - ✅ All 1 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-06-16 13:23:17,670 - 56457 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-06-16 13:23:18,342 - 56457 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-06-16 13:23:19,020 - 56457 - src.utils.log - INFO - 🔍 Fetching data: 
            SELECT WorkOrderAutoGenerationId
            FROM ServiceCore.WorkOrderAutoGeneration
            WHERE WorkOrderAutoGenerationId IN (578576, 578577, 578578, 578579, 578580, 578581, 578582, 578583, 578584, 578585, 578586, 578587, 578588, 578589, 578590, 578591, 578592, 578593, 578594, 578595, 578596, 578597, 578598, 578599, 578600, 578601, 578602, 578603, 578604, 578605, 578606, 578607, 578608, 578609, 578610, 578611, 578612, 578613, 578614, 578615, 578616, 578617, 578618, 578619, 578620, 578621, 578622, 578623, 578624, 578625, 578626, 578627, 578628, 578629, 578630, 578631, 578632, 578633, 578634, 578635, 578636, 578637, 578638, 578639, 578640, 578641, 578642, 578643, 578644, 578645, 578646, 578647, 578648, 578649, 578650, 578651, 578652, 578653, 578654, 578655, 578656, 578657, 578658, 578659, 578660, 578661, 578662, 578663, 578664, 578665, 578666, 578667, 578668, 578669, 578670, 578671, 578672, 578673, 578674, 578675, 578676, 578677, 578678, 578679, 578680, 578681, 578682, 578683, 578684, 578685, 578686, 578687)
        ... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:19,729 - 56457 - src.utils.log - INFO - ✅ Fetched 112 rows - __SPLIT__
2026-06-16 13:23:20,405 - 56457 - src.utils.log - INFO - 📥 Inserting into ServiceCore.WorkOrderAutoGenerationServices: 112 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:21,112 - 56457 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 112) into ServiceCore.WorkOrderAutoGenerationServices - __SPLIT__
2026-06-16 13:23:22,111 - 56457 - src.utils.log - INFO - ✅ All 112 rows inserted successfully into ServiceCore.WorkOrderAutoGenerationServices in 1 batches - __SPLIT__
2026-06-16 13:23:22,792 - 56457 - src.utils.log - INFO - WorkOrderAutoGenerationServices inserted to dream DB - __SPLIT__
2026-06-16 13:23:23,473 - 56457 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateWorkOrderHistory
                        SET Status = 'Completed' WHERE GenerateWorkOrderHistoryId = 56457;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:23:24,176 - 56457 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-16 13:23:24,851 - 56457 - src.utils.log - INFO - Sequential work order generation successful - __SPLIT__
2026-06-16 13:23:25,526 - 56457 - src.utils.log - INFO - Time took to perform operation: 83.34 - __SPLIT__
2026-06-16 13:36:13,898 - 11973 - src.utils.log - INFO - ParallelProcessing=False GenerateInvoiceHistoryId=11973 - __SPLIT__
2026-06-16 13:36:15,830 - 11973 - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-06-16 13:36:16,514 - 11973 - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE 
    CompanyKey  = 'Samsung'... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:17,505 - 11973 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:36:18,188 - 11973 - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-06-16 13:36:18,865 - 11973 - src.utils.log - INFO - Sequential Invoice generation algo started for GenerateInvoiceHistoryId: 11973 - __SPLIT__
2026-06-16 13:36:19,548 - 11973 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
                        SET Status = 'InProgress' WHERE GenerateInvoiceHistoryId = 11973;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:20,249 - 11973 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-16 13:36:20,929 - 11973 - src.utils.log - INFO - 🔍 Fetching data: SELECT * from ServiceCore.GenerateInvoiceHistory WHERE 
        GenerateInvoiceHistoryId = 11973;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:21,633 - 11973 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-06-16 13:36:22,317 - 11973 - src.utils.log - INFO - 🔍 Fetching data: 
        SELECT sss.ServiceId as ServiceMasterId,ss.FrequencyScheduleId as setup_frequency_schedule_id, ssb.*, ss.IsBilling, ss.DepartmentMasterId, ss.AccountNumber, ss.CompanyId, ss.BillingLocationId, 
        ss.ServiceLocationId, ss.TaxSysName, ss.TermId, t.NetDueIn, ss.TaxPercent, ss.PoNumber, 
        ss.DisplayServiceAsSeparateLineItem, ss.SetupEndDate, ss.SetupStartDate  from ServiceCore.ServiceSetup ss  
        join ServiceCore.ServiceSetupBilling ssb on ss.ServiceSetupId  = ssb.ServiceSetupId join 
        Billing.PaymentTypeMaster ptm on ptm.PaymentTypeMasterId = ssb.PaymentTypeMasterId join Billing.Term t  
        on ss.TermId = t.TermId join ServiceCore.ServiceSetupServices sss on ss.ServiceSetupId = sss.ServiceSetupId
         where ptm.PaymentType= 'Payment Plan' and ss.IsActive =1 and ss.CompanyId= 145 
        AND ss.IsDeleted =0 AND ss.Status <> 'Canceled'
          and ss.AccountNumber = '2543'  and ss.ServiceSetupId = 95236 ;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:23,036 - 11973 - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-06-16 13:36:23,715 - 11973 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
                        SET Status = 'Completed' WHERE GenerateInvoiceHistoryId = 11973;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:24,424 - 11973 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-16 13:36:25,103 - 11973 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
                                SET InvoiceStatusDateTime = '2026-06-16 09:36:25.103' WHERE GenerateInvoiceHistoryId = 11973;... (Thread: AnyIO worker thread) - __SPLIT__
2026-06-16 13:36:25,811 - 11973 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-06-16 13:36:26,493 - 11973 - src.utils.log - INFO - 🔒 Connection pool closed - __SPLIT__
2026-06-16 13:36:27,170 - 11973 - src.utils.log - INFO - Error in Sequential Invoice Gen ProjectId:11973 - Time took: 11.35 - Error:No setups found for GenerateWorkOrderHistoryid: 11973 - __SPLIT__