2026-05-19 06:14:08,495 - [42411] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory SET PublishStatus = 'InProgress',
InvoicePublishStartDateTime = '2026-05-19 02:14:08.495' WHERE CompanyId = 133 AND
GenerateInvoiceHistoryId = 42411;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:10,491 - [42411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:14:10,555 - [42411] - src.utils.log - INFO - 🔍 Fetching data:
SELECT i.* FROM Billing.InvoiceAutoGeneration i
join Billing.TransactionAutoGeneration t on i.TransactionAutoGenerationId = t.TransactionAutoGenerationId
WHERE t.GenerateWorkOrderHistoryId = 42411;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:10,913 - [42411] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:14:10,982 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.TransactionAutoGeneration tag WHERE
tag.TransactionAutoGenerationId in (636647, 636648, 636649);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:11,320 - [42411] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:14:11,386 - [42411] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:11,868 - [42411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-05-19 06:14:12,902 - [42411] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-05-19 06:14:13,104 - [42411] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-19 06:14:13,170 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy
from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911, 12345678912);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:13,741 - [42411] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:14:13,865 - [42411] - src.utils.log - INFO - 📝 Executing:
UPDATE Billing.[Transaction]
SET ModifiedBy = NULL
WHERE ModifiedBy IN (12345678910,12345678911,12345678912);
... (Thread: ThreadPoolExecutor-4_0) - __SPLIT__
2026-05-19 06:14:14,437 - [42411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:14:14,505 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 133 AND EnitityNumberType in ('Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:14,855 - [42411] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-19 06:14:14,924 - [42411] - src.utils.log - INFO - 3 Invoice Generated : [1477236, 1477237, 1477238] - __SPLIT__
2026-05-19 06:14:14,996 - [42411] - src.utils.log - INFO - 📝 Executing: UPDATE Common.GenerateNumberConfig SET NextNumber = '1477239'
WHERE CompanyId = 133 AND EnitityNumberType in ('Invoice');... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:15,354 - [42411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:14:15,427 - [42411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-19 06:14:15,492 - [42411] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:15,851 - [42411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Invoice - __SPLIT__
2026-05-19 06:14:16,934 - [42411] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-05-19 06:14:17,002 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, InvoiceId FROM Billing.Invoice WHERE
TransactionId in (3692573, 3692574, 3692575);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:17,403 - [42411] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:14:17,474 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.InvoiceChargesAutoGeneration icag WHERE
InvoiceAutoGenerationId in (444732, 444733, 444734);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:17,835 - [42411] - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-05-19 06:14:17,934 - [42411] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.InvoiceAutoGenerationAppliedDiscount iagad WHERE
InvoiceAutoGenerationId in (444732, 444733, 444734);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:18,282 - [42411] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-19 06:14:18,355 - [42411] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-19 06:14:18,425 - [42411] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:18,783 - [42411] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into Billing.InvoiceCharges - __SPLIT__
2026-05-19 06:14:19,889 - [42411] - src.utils.log - INFO - ✅ All 9 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-05-19 06:14:19,958 - [42411] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-05-19 06:14:20,033 - [42411] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-05-19 06:14:20,101 - [42411] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceAutoGenerationAppliedDiscount WHERE
InvoiceAutoGenerationId in (444732, 444733, 444734) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:20,454 - [42411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:14:20,522 - [42411] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceChargesAutoGeneration WHERE
InvoiceAutoGenerationId in (444732, 444733, 444734) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:20,904 - [42411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:14:20,971 - [42411] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceAutoGeneration WHERE
InvoiceAutoGenerationId in (444732, 444733, 444734) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:21,378 - [42411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:14:21,450 - [42411] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.TransactionAutoGeneration WHERE
TransactionAutoGenerationId in (636647, 636648, 636649) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:21,812 - [42411] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:14:21,880 - [42411] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-05-19 02:14:08.495' WHERE CompanyId = 133 AND
GenerateInvoiceHistoryId = 42411;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:14:22,224 - [42411] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:14:22,290 - [42411] - src.utils.log - INFO - Sequential invoice publish completed successfully - Time took: 16.2 - __SPLIT__
2026-05-19 06:28:37,468 - [13556] - src.utils.log - INFO - ParallelProcessing=False temp_invoice=[] user_id=122885 company_id=135 project_id=[13556] publish_all=True - __SPLIT__
2026-05-19 06:28:37,587 - [13556] - src.utils.log - INFO - Invoice Published Successfully - __SPLIT__
2026-05-19 06:28:37,654 - [13556] - src.utils.log - INFO - Sequential invoice publish in progress - __SPLIT__
2026-05-19 06:28:37,720 - [13556] - src.utils.log - INFO - ✅ Successfully connected to database - __SPLIT__
2026-05-19 06:28:37,786 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT ConnectionStringName FROM Common.CompanyTenantMaster WHERE
CompanyKey = 'Fortive'... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:39,946 - [13556] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-19 06:28:40,009 - [13556] - src.utils.log - INFO - Connection string not found connecting to common DB - __SPLIT__
2026-05-19 06:28:40,073 - [13556] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory SET PublishStatus = 'InProgress',
InvoicePublishStartDateTime = '2026-05-19 02:28:40.073' WHERE CompanyId = 135 AND
GenerateInvoiceHistoryId = 13556;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:40,424 - [13556] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:28:40,490 - [13556] - src.utils.log - INFO - 🔍 Fetching data:
SELECT i.* FROM Billing.InvoiceAutoGeneration i
join Billing.TransactionAutoGeneration t on i.TransactionAutoGenerationId = t.TransactionAutoGenerationId
WHERE t.GenerateWorkOrderHistoryId = 13556;
... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:40,850 - [13556] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:28:40,915 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.TransactionAutoGeneration tag WHERE
tag.TransactionAutoGenerationId in (799193, 799194, 799195);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:41,297 - [13556] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:28:41,360 - [13556] - src.utils.log - INFO - 📥 Inserting into Billing.Transaction (skip triggers): 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:41,897 - [13556] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Transaction (triggers skipped) - __SPLIT__
2026-05-19 06:28:43,024 - [13556] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Transaction in 1 batches (triggers skipped) - __SPLIT__
2026-05-19 06:28:43,231 - [13556] - src.utils.log - INFO - 🔄 Triggers re-enabled for session - __SPLIT__
2026-05-19 06:28:43,289 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, ModifiedBy
from Billing.[Transaction] t WHERE t.ModifiedBy in (12345678910, 12345678911, 12345678912);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:43,811 - [13556] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:28:43,871 - [13556] - src.utils.log - INFO - 📝 Executing:
UPDATE Billing.[Transaction]
SET ModifiedBy = NULL
WHERE ModifiedBy IN (12345678910,12345678911,12345678912);
... (Thread: ThreadPoolExecutor-5_0) - __SPLIT__
2026-05-19 06:28:44,390 - [13556] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:28:44,502 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Common.GenerateNumberConfig gnc
WHERE CompanyId = 135 AND EnitityNumberType in ('Invoice'); ... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:44,860 - [13556] - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-05-19 06:28:44,928 - [13556] - src.utils.log - INFO - 3 Invoice Generated : [166153, 166154, 166155] - __SPLIT__
2026-05-19 06:28:44,991 - [13556] - src.utils.log - INFO - 📝 Executing: UPDATE Common.GenerateNumberConfig SET NextNumber = '166156'
WHERE CompanyId = 135 AND EnitityNumberType in ('Invoice');... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:45,343 - [13556] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:28:45,410 - [13556] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-19 06:28:45,476 - [13556] - src.utils.log - INFO - 📥 Inserting into Billing.Invoice: 3 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:45,852 - [13556] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 3) into Billing.Invoice - __SPLIT__
2026-05-19 06:28:47,031 - [13556] - src.utils.log - INFO - ✅ All 3 rows inserted successfully into Billing.Invoice in 1 batches - __SPLIT__
2026-05-19 06:28:47,102 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT TransactionId, InvoiceId FROM Billing.Invoice WHERE
TransactionId in (406720, 406721, 406722);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:47,455 - [13556] - src.utils.log - INFO - ✅ Fetched 3 rows - __SPLIT__
2026-05-19 06:28:47,530 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.InvoiceChargesAutoGeneration icag WHERE
InvoiceAutoGenerationId in (854094, 854095, 854096);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:48,193 - [13556] - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-05-19 06:28:48,262 - [13556] - src.utils.log - INFO - 🔍 Fetching data: SELECT * FROM Billing.InvoiceAutoGenerationAppliedDiscount iagad WHERE
InvoiceAutoGenerationId in (854094, 854095, 854096);... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:48,695 - [13556] - src.utils.log - INFO - ✅ Fetched 0 rows - __SPLIT__
2026-05-19 06:28:48,764 - [13556] - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-05-19 06:28:48,824 - [13556] - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceCharges: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:49,202 - [13556] - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into Billing.InvoiceCharges - __SPLIT__
2026-05-19 06:28:50,297 - [13556] - src.utils.log - INFO - ✅ All 9 rows inserted successfully into Billing.InvoiceCharges in 1 batches - __SPLIT__
2026-05-19 06:28:50,362 - [13556] - src.utils.log - INFO - 📥 Empty dataframe of Billing.AccountDiscountSetup: - __SPLIT__
2026-05-19 06:28:50,481 - [13556] - src.utils.log - INFO - 📥 Empty dataframe of Billing.DiscountApplied: - __SPLIT__
2026-05-19 06:28:50,554 - [13556] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceAutoGenerationAppliedDiscount WHERE
InvoiceAutoGenerationId in (854094, 854095, 854096) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:50,912 - [13556] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:28:50,981 - [13556] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceChargesAutoGeneration WHERE
InvoiceAutoGenerationId in (854094, 854095, 854096) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:51,330 - [13556] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:28:51,399 - [13556] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.InvoiceAutoGeneration WHERE
InvoiceAutoGenerationId in (854094, 854095, 854096) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:51,763 - [13556] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:28:51,830 - [13556] - src.utils.log - INFO - 🗑️ Deleting records: delete FROM Billing.TransactionAutoGeneration WHERE
TransactionAutoGenerationId in (799193, 799194, 799195) (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:52,202 - [13556] - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-05-19 06:28:52,312 - [13556] - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory SET PublishStatus = 'Completed',
PublishStatusDateTime = '2026-05-19 02:28:40.073' WHERE CompanyId = 135 AND
GenerateInvoiceHistoryId = 13556;... (Thread: AnyIO worker thread) - __SPLIT__
2026-05-19 06:28:52,726 - [13556] - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-05-19 06:28:52,803 - [13556] - src.utils.log - INFO - Sequential invoice publish completed successfully - Time took: 15.08 - __SPLIT__