2026-08-03 17:02:53,907 - 12111 - src.utils.log - INFO - SetupId: 67235, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,913 - 12111 - src.utils.log - INFO - SetupId: 67311, FrequencyScheduleId: 14525 - __SPLIT__
2026-08-03 17:02:53,918 - 12111 - src.utils.log - INFO - SetupId: 67318, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,924 - 12111 - src.utils.log - INFO - SetupId: 67350, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,929 - 12111 - src.utils.log - INFO - SetupId: 67369, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,935 - 12111 - src.utils.log - INFO - SetupId: 67424, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,940 - 12111 - src.utils.log - INFO - SetupId: 67559, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,946 - 12111 - src.utils.log - INFO - SetupId: 67569, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,951 - 12111 - src.utils.log - INFO - SetupId: 67577, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,957 - 12111 - src.utils.log - INFO - SetupId: 67582, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,963 - 12111 - src.utils.log - INFO - SetupId: 67627, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,968 - 12111 - src.utils.log - INFO - SetupId: 67636, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,974 - 12111 - src.utils.log - INFO - SetupId: 67638, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,979 - 12111 - src.utils.log - INFO - SetupId: 67644, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,985 - 12111 - src.utils.log - INFO - SetupId: 67772, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:53,991 - 12111 - src.utils.log - INFO - SetupId: 67775, FrequencyScheduleId: 13962 - __SPLIT__
2026-08-03 17:02:53,994 - 12111 - src.utils.log - INFO - SetupId: 67780, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,000 - 12111 - src.utils.log - INFO - SetupId: 67797, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,005 - 12111 - src.utils.log - INFO - SetupId: 67866, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,011 - 12111 - src.utils.log - INFO - SetupId: 67886, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,017 - 12111 - src.utils.log - INFO - SetupId: 67914, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,022 - 12111 - src.utils.log - INFO - SetupId: 67954, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,028 - 12111 - src.utils.log - INFO - SetupId: 67958, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,034 - 12111 - src.utils.log - INFO - SetupId: 68011, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,040 - 12111 - src.utils.log - INFO - SetupId: 68021, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,045 - 12111 - src.utils.log - INFO - SetupId: 68033, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,051 - 12111 - src.utils.log - INFO - SetupId: 68076, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,057 - 12111 - src.utils.log - INFO - SetupId: 68081, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,063 - 12111 - src.utils.log - INFO - SetupId: 68085, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,069 - 12111 - src.utils.log - INFO - SetupId: 68086, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,074 - 12111 - src.utils.log - INFO - SetupId: 68104, FrequencyScheduleId: 14693 - __SPLIT__
2026-08-03 17:02:54,080 - 12111 - src.utils.log - INFO - SetupId: 68124, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,085 - 12111 - src.utils.log - INFO - SetupId: 68208, FrequencyScheduleId: 14519 - __SPLIT__
2026-08-03 17:02:54,091 - 12111 - src.utils.log - INFO - SetupId: 68220, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,097 - 12111 - src.utils.log - INFO - SetupId: 68274, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,103 - 12111 - src.utils.log - INFO - SetupId: 68279, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,108 - 12111 - src.utils.log - INFO - SetupId: 68379, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,114 - 12111 - src.utils.log - INFO - SetupId: 68412, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,119 - 12111 - src.utils.log - INFO - SetupId: 68415, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,125 - 12111 - src.utils.log - INFO - SetupId: 68418, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,130 - 12111 - src.utils.log - INFO - SetupId: 68467, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,136 - 12111 - src.utils.log - INFO - SetupId: 68471, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,141 - 12111 - src.utils.log - INFO - SetupId: 68490, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,147 - 12111 - src.utils.log - INFO - SetupId: 68492, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,153 - 12111 - src.utils.log - INFO - SetupId: 68496, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,159 - 12111 - src.utils.log - INFO - SetupId: 68505, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,163 - 12111 - src.utils.log - INFO - SetupId: 68570, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,169 - 12111 - src.utils.log - INFO - SetupId: 68575, FrequencyScheduleId: 13966 - __SPLIT__
2026-08-03 17:02:54,180 - 12111 - src.utils.log - INFO - 🔍 Fetching data:
SELECT TransactionAutoGenerationId
FROM Billing.TransactionAutoGeneration
WHERE ServiceSetupId IN (65538, 40964, 57350, 24583, 65543, 65546, 65549, 40976, 65552, 49170, 65554, 65557, 24599, 57367, 65560, 65563, 24604, 49180, 24606, 40990, 57376, 24609, 32811, 57387, 41006, 41007, 49203, 65589, 24644, 24645, 24654, 32851, 32855, 57442, 49261, 24689, 65653, 24694, 24695, 57464, 32889, 24705, 24713, 65673, 24715, 41100, 65677, 32913, 32917, 24731, 24732, 24733, 41119, 65696, 24759, 57528, 65720, 57531, 24781, 24782, 65742, 24785, 32978, 32980, 32984, 24793, 49369, 32999, 41191, 41192, 65769, 65770, 33004, 65771, 65772, 65773, 65774, 65775, 65776, 41203, 41204, 65777, 65778, 57591, 33028, 24848, 24849, 24853, 65815, 41243, 24869, 49446, 33072, 33075, 57658, 24891, 24903, 41295, 24913, 24917, 65880, 49504, 41314, 65893, 49511, 41320, 33152, 24964, 65929, 24971, 24972, 24973, 24975, 33172, 65942, 57752, 24986, 33178, 24988, 24993, 65960, 25002, 65963, 65967, 65969, 33203, 33204, 65972, 65977, 65980, 33216, 41410, 65989, 49606, 65993, 65995, 41423, 66002, 33239, 41435, 49630, 33253, 33254, 66024, 49641, 41450, 41459, 49655, 41464, 41468, 33280, 33281, 33282, 25091, 66049, 57863, 33290, 41484, 25104, 41489, 33298, 25115, 25116, 25117, 49691, 41507, 49699, 25126, 49704, 57897, 33323, 49707, 41519, 49712, 33329, 57910, 57911, 49720, 57912, 66102, 49731, 49735, 25166, 49744, 49752, 49753, 57952, 41569, 49763, 57955, 49767, 49775, 66159, 49779, 25205, 49783, 66169, 49787, 41596, 49791, 25219, 41604, 41611, 49805, 33424, 49809, 33432, 49817, 41627, 66209, 41640, 25258, 58027, 25266, 33461, 33463, 41656, 41657, 58041, 25276, 33473, 33480, 25290, 25293, 25294, 25310, 49888, 49896, 33513, 25323, 49903, 58099, 41727, 49924, 25353, 41758, 41759, 41773, 33582, 49970, 33591, 41790, 41797, 41799, 49991, 49995, 66385, 50005, 50015, 41827, 25454, 25455, 50037, 41850, 50042, 50046, 66430, 25474, 50050, 33669, 41862, 41864, 41867, 41874, 41876, 66459, 25514, 25515, 25516, 41898, 41909, 50101, 41913, 50109, 25537, 25538, 58306, 25555, 25562, 25579, 41966, 58351, 25584, 41971, 50168, 41979, 50172, 41983, 50175, 58372, 41997, 66585, 42010, 25628, 25629, 25632, 50214, 33836, 33839, 33841, 66609, 25652, 66618, 42045, 50238, 42047, 42053, 42054, 33864, 66633, 42062, 33877, 42069, 42072, 58456, 42085, 42096, 33906, 50291, 33908, 42101, 42102, 50295, 33914, 50299, 50303, 33928, 50312, 33932, 33933, 25742, 42129, 50321, 66707, 33951, 33952, 50336, 42146, 50340, 42154, 33968, 66742, 42169, 42174, 50371, 34009, 34011, 66783, 34022, 34023, 34024, 66795, 50417, 25844, 66810, 25851, 34056, 50444, 25871, 25873, 25878, 42279, 42282, 50474, 42285, 50491, 50494, 50500, 34119, 50506, 50509, 66893, 25936, 50512, 50515, 66900, 34134, 50518, 34137, 42332, 50524, 50530, 50539, 66925, 50542, 66928, 50545, 25971, 50548, 25973, 25975, 50552, 50557, 50561, 25986, 50565, 34182, 42374, 50568, 42379, 34188, 50571, 34190, 42385, 58769, 50579, 50580, 42389, 50588, 50589, 42402, 50595, 26020, 42408, 34218, 34224, 50613, 34243, 42450, 26072, 34274, 34275, 26090, 58862, 42483, 26101, 34296, 42494, 67070, 67072, 42506, 50708, 67105, 42533, 42549, 67126, 42557, 34375, 50762, 26194, 26203, 50780, 42589, 58972, 42591, 42594, 34406, 50795, 42604, 58988, 42607, 42609, 34423, 34424, 34429, 50814, 50818, 50827, 26255, 26271, 67235, 26280, 26281, 34473, 59048, 34487, 50871, 50872, 34495, 42699, 50893, 42706, 42714, 26337, 26340, 34533, 34534, 34535, 59117, 67311, 42738, 67318, 50953, 34570, 26388, 67350, 34591, 26402, 67369, 50989, 34609, 34612, 42814, 59210, 34641, 42834, 51028, 51033, 67424, 42851, 42860, 26484, 34676, 51062, 42872, 59257, 34682, 34683, 42874, 59266, 34694, 34695, 59272, 59273, 59279, 26514, 59283, 26517, 34713, 51100, 42912, 34726, 42923, 26559, 34761, 42953, 51150, 51164, 67559, 34794, 34795, 34796, 67569, 59380, 67577, 67582, 26636, 34829, 51222, 43048, 51242, 67627, 26668, 43058, 67636, 67638, 26679, 67644, 26703, 34902, 34903, 26712, 34904, 51298, 59494, 59498, 26732, 34936, 26746, 51330, 43140, 59525, 51334, 34953, 51340, 43157, 43164, 43170, 43174, 26798, 34992, 34993, 35001, 67772, 67775, 67780, 51398, 35020, 43213, 43220, 59604, 67797, 59614, 51429, 26861, 26862, 51442, 26867, 26868, 43253, 51454, 26884, 59654, 35079, 67866, 43293, 51486, 43298, 51496, 26921, 26922, 67886, 51503, 43314, 51508, 51516, 43330, 26952, 67914, 43352, 43356, 26976, 35170, 59748, 67954, 43380, 67958, 51575, 51589, 27016, 27017, 43401, 51592, 51598, 35221, 35226, 51623, 51625, 68011, 43444, 68021, 35259, 68033, 27076, 51654, 51656, 43466, 43467, 51661, 51679, 27104, 51684, 68076, 51693, 51694, 68081, 35317, 68085, 68086, 51705, 43518, 35329, 35332, 51719, 51720, 68104, 51722, 43531, 51726, 27154, 51734, 43544, 51737, 51740, 68124, 51748, 27177, 27178, 43563, 43565, 51759, 59959, 35390, 51776, 51780, 35406, 43602, 43603, 43605, 51799, 59993, 51803, 35420, 51806, 43618, 27244, 68208, 43633, 35444, 43637, 51828, 68220, 27261, 27262, 51843, 51844, 60038, 51853, 35476, 60061, 35488, 43685, 51886, 68274, 51893, 68279, 51896, 60090, 51901, 51911, 51912, 51914, 27340, 35540, 27351, 51932, 27359, 27360, 51936, 51943, 43758, 51956, 35577, 51972, 51982, 35606, 43800, 51992, 51994, 68379, 52001, 27426, 52002, 60200, 43824, 52020, 52025, 68412, 52030, 68415, 52032, 68418, 52035, 27462, 35657, 27466, 52045, 43856, 52051, 52052, 52060, 52061, 52062, 43878, 35687, 35689, 35690, 52078, 68467, 68471, 52089, 52092, 52093, 35710, 35711, 27526, 52106, 68490, 27532, 68492, 60303, 68496, 27541, 35737, 35738, 68505, 52130, 60332, 60334, 60336, 27571, 60342, 43959, 52153, 35772, 52160, 52166, 60361, 43978, 35786, 27599, 52175, 43985, 60367, 60368, 60371, 60375, 35802, 68570, 68575, 52197, 52201, 35828, 35829, 52213, 27641, 27642, 35837, 44030, 44031, 52226, 27652, 35846, 44039, 44040, 60423, 52234, 52235, 52238, 27663, 52244, 44053, 52247, 52250, 52254, 35871, 52255, 44065, 27683, 52260, 35880, 44072, 52266, 52268, 27697, 35895, 44087, 44088, 52284, 52285, 52286, 35903, 44096, 52297, 35917, 52302, 35921, 35926, 35937, 27746, 27747, 52322, 27749, 52330, 52333, 35950, 35951, 52334, 52339, 60533, 52342, 44153, 44169, 52366, 35986, 27795, 44181, 52377, 27803, 52379, 52380, 52382, 60573, 44199, 52397, 36018, 36019, 44210, 36025, 36026, 52410, 52414, 52417, 52418, 36038, 36039, 44230, 52425, 52427, 52429, 36047, 52432, 44243, 52435, 52438, 44254, 52447, 52450, 36068, 52452, 52458, 44267, 44268, 52464, 52468, 36093, 36094, 36095, 27905, 52481, 52483, 52484, 27911, 52488, 27926, 52504, 36121, 36122, 52511, 27944, 36137, 36138, 36141, 44333, 52534, 44345, 52539, 44350, 44356, 44359, 52551, 52552, 52556, 52557, 36176, 36178, 44372, 44376, 52571, 27998, 36190, 36191, 28001, 36192, 52574, 52579, 36198, 52582, 60775, 44393, 44394, 44396, 52595, 36213, 36218, 36220, 52606, 60806, 52618, 28044, 52620, 60816, 52646, 52647, 28075, 28076, 52654, 28080, 44474, 52670, 28096, 44480, 52672, 28099, 52673, 52676, 52677, 44492, 52685, 44494, 52686, 52694, 52695, 44507, 52701, 52702, 36319, 52706, 28132, 52708, 52716, 36334, 52721, 36344, 36345, 44551, 52743, 52759, 52761, 44570, 28190, 36388, 36389, 36397, 36401, 52787, 52789, 60996, 44617, 44618, 28239, 52818, 52822, 28247, 52826, 28253, 36445, 36446, 52829, 52839, 36463, 52850, 52856, 44665, 52857, 52864, 44679, 36491, 52879, 36499, 28310, 52898, 52909, 28337, 36530, 44723, 61116, 36542, 28360, 28361, 28364, 28365, 28366, 28367, 52947, 52953, 52965, 52966, 52977, 44787, 52982, 52986, 44796, 44799, 36616, 53000, 28432, 53009, 53015, 53016, 53020, 44831, 44832, 53031, 53033, 53037, 44846, 36659, 44851, 44854, 53049, 28477, 61249, 53058, 28484, 53061, 36678, 53063, 61272, 36698, 53084, 53088, 53103, 53106, 44917, 53109, 53118, 53124, 53131, 53133, 44948, 44970, 53169, 53171, 28596, 53180, 36798, 53192, 28623, 53199, 53200, 45015, 53207, 53212, 45021, 53214, 53215, 28655, 53233, 53234, 53235, 53238, 36870, 45064, 53259, 45068, 45069, 61453, 45076, 36886, 45083, 45091, 53294, 53306, 36925, 28739, 45131, 36940, 45133, 53326, 53327, 28761, 53349, 45160, 36969, 53354, 53364, 53366, 53372, 37000, 45193, 53384, 28813, 53393, 28821, 53400, 45218, 45233, 53427, 28852, 61624, 37054, 37055, 37056, 28881, 37074, 37075, 53459, 37084, 37086, 37087, 37097, 45290, 28909, 45319, 61705, 28941, 53524, 28949, 53525, 37145, 28954, 28968, 45357, 37168, 45360, 37177, 53575, 45392, 37202, 37206, 53602, 45413, 61811, 37236, 53620, 53621, 53622, 53626, 61821, 53643, 53644, 61839, 29076, 53653, 53660, 45474, 37283, 45477, 45480, 53685, 45496, 29123, 29124, 45508, 53701, 37325, 37326, 45517, 61908, 61913, 45535, 29156, 29157, 61931, 29168, 37366, 45565, 61949, 29186, 45570, 45574, 29195, 37393, 37407, 29217, 53800, 29246, 37439, 29252, 62026, 53836, 45646, 62033, 53845, 45659, 29277, 45663, 37476, 62057, 37495, 37501, 45693, 37512, 37527, 62106, 37535, 45728, 45735, 53928, 37548, 29367, 53946, 29373, 37567, 37585, 45777, 37594, 37598, 37602, 62181, 45801, 53996, 45810, 45816, 54010, 37627, 45819, 45824, 37646, 45846, 45853, 29470, 37669, 62254, 37693, 54079, 54080, 62274, 37707, 37709, 37714, 62302, 37737, 45930, 37741, 45933, 62326, 45955, 62345, 29589, 54165, 54170, 62364, 37800, 37801, 29610, 37802, 29612, 45997, 46000, 62385, 46007, 37819, 37828, 37829, 62405, 54217, 54218, 29644, 29645, 29646, 29649, 29650, 62417, 29652, 62421, 54234, 46044, 54241, 29674, 29680, 62448, 37879, 29710, 54287, 29713, 37905, 62484, 29727, 37920, 54315, 37934, 29749, 46145, 54344, 37963, 29775, 46173, 29795, 29808, 29810, 29811, 46199, 62584, 29834, 38028, 62606, 62607, 38056, 29865, 62636, 38064, 54453, 46278, 46279, 38096, 62694, 54504, 38121, 38122, 62709, 62715, 54527, 46337, 29959, 38152, 38155, 29982, 29988, 38182, 54569, 46381, 62766, 38192, 54580, 46395, 46397, 46401, 46406, 30023, 54599, 54607, 46416, 38226, 30036, 30037, 46420, 46423, 62809, 46427, 46428, 62815, 54624, 62816, 46434, 46435, 54627, 30053, 46440, 46441, 30058, 46447, 46448, 46452, 46457, 46458, 54653, 38270, 46463, 38272, 46467, 46468, 46473, 46476, 46479, 46480, 46485, 46486, 46488, 30107, 46492, 46498, 46513, 38329, 46521, 46527, 46531, 62917, 46535, 46539, 46541, 62925, 62945, 30184, 54761, 30192, 30202, 54778, 38400, 30212, 46599, 30216, 38408, 46610, 38422, 38425, 38426, 30240, 38440, 38441, 46632, 46636, 54835, 46644, 38462, 54859, 46669, 46681, 54879, 30308, 46698, 46702, 30325, 46709, 38527, 46722, 46724, 46728, 46733, 38545, 46741, 30372, 38567, 38568, 38569, 30386, 46779, 63164, 38589, 30423, 38622, 30441, 55028, 38648, 46841, 55038, 38655, 63254, 22301, 55072, 46882, 55076, 22316, 22326, 38711, 22329, 46909, 46910, 22336, 38720, 22339, 63301, 38728, 63304, 63308, 22350, 55118, 63312, 22354, 22355, 55122, 63314, 22360, 46936, 38751, 46943, 38755, 30568, 22377, 30574, 22383, 30577, 63347, 38773, 38775, 22392, 38781, 22404, 46981, 22406, 22407, 30602, 63372, 22415, 22416, 63378, 22420, 22430, 47009, 22436, 22438, 22439, 30639, 22454, 47030, 22456, 55225, 38851, 47045, 22472, 22474, 22475, 22485, 22488, 22489, 22499, 47077, 30696, 30697, 47085, 30703, 38897, 38900, 47093, 22525, 22540, 38927, 30743, 55327, 22561, 55333, 38953, 47146, 22571, 38955, 22577, 22581, 22584, 63544, 63545, 30779, 63546, 47165, 63547, 63548, 30788, 22602, 22603, 22604, 22607, 22609, 30801, 63573, 63574, 30807, 22618, 22619, 22621, 39006, 22625, 22631, 22646, 22648, 22653, 47231, 22659, 22664, 30857, 22670, 22675, 30867, 30868, 22678, 39061, 22682, 22685, 22686, 22688, 55461, 22694, 22696, 63660, 22701, 30894, 63664, 39091, 30905, 47294, 39103, 22726, 30924, 22740, 47317, 63702, 47319, 39129, 22746, 30939, 30942, 22756, 22757, 47333, 22766, 22767, 22778, 30970, 39164, 22781, 22784, 22785, 47366, 30984, 30985, 30989, 55576, 22815, 47392, 22833, 22839, 39224, 47415, 63802, 47423, 47424, 63808, 22854, 22858, 22859, 31074, 47462, 22887, 22888, 22889, 39274, 63846, 39280, 31090, 22904, 22908, 47484, 22922, 22925, 22927, 55695, 22948, 31140, 22952, 22954, 55724, 31149, 31153, 39353, 39354, 55738, 31169, 22984, 63947, 22994, 31189, 23007, 55776, 55777, 23010, 55778, 55779, 55781, 23014, 23015, 23016, 39398, 39399, 55782, 55783, 55784, 23030, 63992, 31225, 63994, 23036, 23037, 23038, 23040, 23041, 23042, 23043, 23044, 47617, 47628, 23055, 23063, 23064, 64029, 64033, 47652, 23077, 64038, 64041, 64043, 47660, 39470, 39471, 64046, 23089, 64050, 64054, 23096, 39481, 64058, 55867, 64061, 39490, 39491, 64068, 23118, 55888, 31315, 31316, 31317, 47704, 23134, 47710, 23137, 23138, 47715, 23145, 31343, 47730, 39540, 23159, 23160, 31353, 64122, 31360, 64133, 23188, 39573, 55957, 39575, 23192, 55958, 23194, 47770, 55960, 55961, 23198, 55963, 55964, 23201, 23202, 55966, 23210, 23211, 23212, 55979, 55982, 64177, 31412, 31413, 47801, 23235, 56008, 64201, 31436, 31437, 23246, 23247, 47834, 23262, 31454, 39648, 23269, 31466, 39659, 64237, 39662, 23279, 23280, 39666, 47861, 23287, 47877, 23306, 31500, 23309, 56078, 23312, 64275, 39700, 56086, 39704, 23325, 56094, 23327, 23329, 31521, 31522, 23332, 47910, 64294, 39720, 64299, 64300, 39728, 64305, 39731, 56115, 31542, 31543, 23355, 23358, 47935, 31552, 23363, 39749, 23373, 23374, 47950, 39760, 64336, 31574, 23386, 39783, 31593, 39788, 23405, 39791, 23410, 47987, 39797, 23415, 23417, 31612, 23421, 31617, 23426, 48002, 31620, 64385, 23430, 31626, 39828, 23445, 39832, 64409, 23450, 31644, 31645, 23455, 64415, 31650, 31651, 48035, 56226, 23465, 23466, 23479, 31671, 31672, 31676, 56254, 23488, 23489, 48064, 39875, 39877, 23499, 23500, 64460, 39886, 23503, 23504, 39895, 31704, 31705, 23526, 31719, 48103, 31735, 23546, 31752, 48137, 23571, 39958, 48158, 56352, 48167, 64551, 23597, 23602, 31795, 31796, 39997, 40001, 23618, 23627, 56397, 23631, 23632, 64592, 31827, 31835, 40033, 23653, 40037, 64617, 64622, 64628, 23669, 56442, 56444, 40073, 56459, 23697, 23698, 23699, 40084, 23701, 64661, 40087, 64668, 40095, 48287, 31908, 31909, 40102, 48298, 56492, 31917, 40110, 48301, 64695, 31929, 40125, 23747, 23752, 23755, 64717, 48334, 31951, 23760, 31959, 64735, 23779, 23780, 40165, 40166, 56549, 48362, 56556, 31987, 56573, 56574, 56575, 32008, 23817, 40201, 32015, 32019, 40211, 40215, 32036, 32037, 40237, 64814, 32061, 32062, 40258, 64834, 48453, 64839, 23885, 64847, 32080, 32083, 23892, 23908, 48484, 23913, 23914, 32105, 40299, 56684, 23920, 56688, 56690, 48502, 23931, 64899, 32132, 23947, 64912, 64917, 23961, 48542, 56734, 40354, 64934, 23976, 40361, 64937, 64939, 64945, 40370, 40371, 64947, 32181, 40378, 48573, 40383, 40385, 24004, 48581, 24011, 48587, 64971, 24025, 32223, 64994, 40419, 32230, 48614, 65003, 32238, 32241, 32243, 32247, 48632, 32253, 32257, 40451, 32260, 24070, 32264, 40456, 32266, 48649, 32270, 56847, 32272, 32275, 32278, 56856, 32282, 24092, 32284, 24094, 24095, 56863, 65057, 24099, 65059, 40508, 56894, 48705, 65089, 32324, 24133, 56903, 32329, 56908, 65100, 32335, 65106, 40540, 56930, 24172, 24173, 32367, 56951, 40571, 56957, 48767, 65152, 65155, 48775, 56967, 56968, 40586, 65169, 24210, 48792, 24219, 24220, 24221, 32416, 65187, 65191, 24237, 24238, 40627, 24247, 24248, 65212, 65213, 24258, 57027, 24262, 40646, 24265, 48843, 24268, 24269, 24270, 24271, 32460, 32463, 24284, 24285, 57060, 65252, 32486, 32493, 32499, 24313, 24314, 32507, 40701, 57097, 32522, 48906, 24337, 24338, 32530, 24343, 24352, 24356, 65318, 65319, 57131, 57133, 24367, 32563, 32564, 57141, 24383, 32577, 24389, 65360, 24401, 65361, 65362, 65363, 32597, 48991, 24417, 32614, 32615, 65384, 65387, 24430, 32623, 57198, 24439, 24440, 57207, 65401, 65402, 24445, 24456, 65419, 49036, 40846, 40851, 40852, 24469, 24470, 57248, 57254, 65449, 24490, 32683, 57260, 24493, 24494, 57263, 24496, 57266, 57267, 57270, 24503, 24504, 57273, 65462, 65463, 65472, 24514, 24515, 49093, 65478, 65483, 65484, 24526, 49106, 49107, 49108, 65490, 32728, 40920, 57304, 57305, 32735, 49119, 40931, 40932, 40933, 57316, 57320, 24554, 57323, 24561, 57339)
AND TransactionDate BETWEEN '2026-08-01 00:00:00' AND '2026-08-31 00:00:00'
AND IsActive = 1
... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,341 - 12111 - src.utils.log - INFO - ✅ Fetched 7 rows - __SPLIT__
2026-08-03 17:02:54,341 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT InvoiceAutoGenerationId
FROM Billing.InvoiceAutoGeneration
WHERE TransactionAutoGenerationId IN (194354, 194355, 194356, 194357, 194358, 194359, 194360)
... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,373 - 12111 - src.utils.log - INFO - ✅ Fetched 7 rows - __SPLIT__
2026-08-03 17:02:54,373 - 12111 - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM Billing.InvoiceChargesAutoGeneration WHERE InvoiceAutoGenerationId IN (194354, 194355, 194356, 194357, 194358, 194359, 194360) (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,410 - 12111 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-08-03 17:02:54,410 - 12111 - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM Billing.InvoiceAutoGenerationAppliedDiscount WHERE InvoiceAutoGenerationId IN (194354, 194355, 194356, 194357, 194358, 194359, 194360) (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,442 - 12111 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-08-03 17:02:54,442 - 12111 - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM Billing.InvoiceAutoGeneration WHERE InvoiceAutoGenerationId IN (194354, 194355, 194356, 194357, 194358, 194359, 194360) (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,479 - 12111 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-08-03 17:02:54,479 - 12111 - src.utils.log - INFO - 🗑️ Deleting records: DELETE FROM Billing.TransactionAutoGeneration WHERE TransactionAutoGenerationId IN (194354, 194355, 194356, 194357, 194358, 194359, 194360) (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,513 - 12111 - src.utils.log - INFO - ✅ Records deleted successfully - __SPLIT__
2026-08-03 17:02:54,523 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT Inv.ServiceSetupId, MAX(Inv.InvoiceDate) AS InvoiceDate FROM Billing.Invoice Inv INNER JOIN
Billing.[Transaction] T ON Inv.TransactionId = T.TransactionId WHERE Inv.InvoiceDate BETWEEN
'2026-08-01 00:00:00' AND '2026-08-31 00:00:00' AND Inv.IsActive = 1
AND Inv.IsDelete = 0 AND T.IsActive = 1 AND T.IsDelete = 0 AND Inv.ServiceSetupId
IN (65538, 40964, 57350, 24583, 65543, 65546, 65549, 40976, 65552, 49170, 65554, 65557, 24599, 57367, 65560, 65563, 24604, 49180, 24606, 40990, 57376, 24609, 32811, 57387, 41006, 41007, 49203, 65589, 24644, 24645, 24654, 32851, 32855, 57442, 49261, 24689, 65653, 24694, 24695, 57464, 32889, 24705, 24713, 65673, 24715, 41100, 65677, 32913, 32917, 24731, 24732, 24733, 41119, 65696, 24759, 57528, 65720, 57531, 24781, 24782, 65742, 24785, 32978, 32980, 32984, 24793, 49369, 32999, 41191, 41192, 65769, 65770, 33004, 65771, 65772, 65773, 65774, 65775, 65776, 41203, 41204, 65777, 65778, 57591, 33028, 24848, 24849, 24853, 65815, 41243, 24869, 49446, 33072, 33075, 57658, 24891, 24903, 41295, 24913, 24917, 65880, 49504, 41314, 65893, 49511, 41320, 33152, 24964, 65929, 24971, 24972, 24973, 24975, 33172, 65942, 57752, 24986, 33178, 24988, 24993, 65960, 25002, 65963, 65967, 65969, 33203, 33204, 65972, 65977, 65980, 33216, 41410, 65989, 49606, 65993, 65995, 41423, 66002, 33239, 41435, 49630, 33253, 33254, 66024, 49641, 41450, 41459, 49655, 41464, 41468, 33280, 33281, 33282, 25091, 66049, 57863, 33290, 41484, 25104, 41489, 33298, 25115, 25116, 25117, 49691, 41507, 49699, 25126, 49704, 57897, 33323, 49707, 41519, 49712, 33329, 57910, 57911, 49720, 57912, 66102, 49731, 49735, 25166, 49744, 49752, 49753, 57952, 41569, 49763, 57955, 49767, 49775, 66159, 49779, 25205, 49783, 66169, 49787, 41596, 49791, 25219, 41604, 41611, 49805, 33424, 49809, 33432, 49817, 41627, 66209, 41640, 25258, 58027, 25266, 33461, 33463, 41656, 41657, 58041, 25276, 33473, 33480, 25290, 25293, 25294, 25310, 49888, 49896, 33513, 25323, 49903, 58099, 41727, 49924, 25353, 41758, 41759, 41773, 33582, 49970, 33591, 41790, 41797, 41799, 49991, 49995, 66385, 50005, 50015, 41827, 25454, 25455, 50037, 41850, 50042, 50046, 66430, 25474, 50050, 33669, 41862, 41864, 41867, 41874, 41876, 66459, 25514, 25515, 25516, 41898, 41909, 50101, 41913, 50109, 25537, 25538, 58306, 25555, 25562, 25579, 41966, 58351, 25584, 41971, 50168, 41979, 50172, 41983, 50175, 58372, 41997, 66585, 42010, 25628, 25629, 25632, 50214, 33836, 33839, 33841, 66609, 25652, 66618, 42045, 50238, 42047, 42053, 42054, 33864, 66633, 42062, 33877, 42069, 42072, 58456, 42085, 42096, 33906, 50291, 33908, 42101, 42102, 50295, 33914, 50299, 50303, 33928, 50312, 33932, 33933, 25742, 42129, 50321, 66707, 33951, 33952, 50336, 42146, 50340, 42154, 33968, 66742, 42169, 42174, 50371, 34009, 34011, 66783, 34022, 34023, 34024, 66795, 50417, 25844, 66810, 25851, 34056, 50444, 25871, 25873, 25878, 42279, 42282, 50474, 42285, 50491, 50494, 50500, 34119, 50506, 50509, 66893, 25936, 50512, 50515, 66900, 34134, 50518, 34137, 42332, 50524, 50530, 50539, 66925, 50542, 66928, 50545, 25971, 50548, 25973, 25975, 50552, 50557, 50561, 25986, 50565, 34182, 42374, 50568, 42379, 34188, 50571, 34190, 42385, 58769, 50579, 50580, 42389, 50588, 50589, 42402, 50595, 26020, 42408, 34218, 34224, 50613, 34243, 42450, 26072, 34274, 34275, 26090, 58862, 42483, 26101, 34296, 42494, 67070, 67072, 42506, 50708, 67105, 42533, 42549, 67126, 42557, 34375, 50762, 26194, 26203, 50780, 42589, 58972, 42591, 42594, 34406, 50795, 42604, 58988, 42607, 42609, 34423, 34424, 34429, 50814, 50818, 50827, 26255, 26271, 67235, 26280, 26281, 34473, 59048, 34487, 50871, 50872, 34495, 42699, 50893, 42706, 42714, 26337, 26340, 34533, 34534, 34535, 59117, 67311, 42738, 67318, 50953, 34570, 26388, 67350, 34591, 26402, 67369, 50989, 34609, 34612, 42814, 59210, 34641, 42834, 51028, 51033, 67424, 42851, 42860, 26484, 34676, 51062, 42872, 59257, 34682, 34683, 42874, 59266, 34694, 34695, 59272, 59273, 59279, 26514, 59283, 26517, 34713, 51100, 42912, 34726, 42923, 26559, 34761, 42953, 51150, 51164, 67559, 34794, 34795, 34796, 67569, 59380, 67577, 67582, 26636, 34829, 51222, 43048, 51242, 67627, 26668, 43058, 67636, 67638, 26679, 67644, 26703, 34902, 34903, 26712, 34904, 51298, 59494, 59498, 26732, 34936, 26746, 51330, 43140, 59525, 51334, 34953, 51340, 43157, 43164, 43170, 43174, 26798, 34992, 34993, 35001, 67772, 67775, 67780, 51398, 35020, 43213, 43220, 59604, 67797, 59614, 51429, 26861, 26862, 51442, 26867, 26868, 43253, 51454, 26884, 59654, 35079, 67866, 43293, 51486, 43298, 51496, 26921, 26922, 67886, 51503, 43314, 51508, 51516, 43330, 26952, 67914, 43352, 43356, 26976, 35170, 59748, 67954, 43380, 67958, 51575, 51589, 27016, 27017, 43401, 51592, 51598, 35221, 35226, 51623, 51625, 68011, 43444, 68021, 35259, 68033, 27076, 51654, 51656, 43466, 43467, 51661, 51679, 27104, 51684, 68076, 51693, 51694, 68081, 35317, 68085, 68086, 51705, 43518, 35329, 35332, 51719, 51720, 68104, 51722, 43531, 51726, 27154, 51734, 43544, 51737, 51740, 68124, 51748, 27177, 27178, 43563, 43565, 51759, 59959, 35390, 51776, 51780, 35406, 43602, 43603, 43605, 51799, 59993, 51803, 35420, 51806, 43618, 27244, 68208, 43633, 35444, 43637, 51828, 68220, 27261, 27262, 51843, 51844, 60038, 51853, 35476, 60061, 35488, 43685, 51886, 68274, 51893, 68279, 51896, 60090, 51901, 51911, 51912, 51914, 27340, 35540, 27351, 51932, 27359, 27360, 51936, 51943, 43758, 51956, 35577, 51972, 51982, 35606, 43800, 51992, 51994, 68379, 52001, 27426, 52002, 60200, 43824, 52020, 52025, 68412, 52030, 68415, 52032, 68418, 52035, 27462, 35657, 27466, 52045, 43856, 52051, 52052, 52060, 52061, 52062, 43878, 35687, 35689, 35690, 52078, 68467, 68471, 52089, 52092, 52093, 35710, 35711, 27526, 52106, 68490, 27532, 68492, 60303, 68496, 27541, 35737, 35738, 68505, 52130, 60332, 60334, 60336, 27571, 60342, 43959, 52153, 35772, 52160, 52166, 60361, 43978, 35786, 27599, 52175, 43985, 60367, 60368, 60371, 60375, 35802, 68570, 68575, 52197, 52201, 35828, 35829, 52213, 27641, 27642, 35837, 44030, 44031, 52226, 27652, 35846, 44039, 44040, 60423, 52234, 52235, 52238, 27663, 52244, 44053, 52247, 52250, 52254, 35871, 52255, 44065, 27683, 52260, 35880, 44072, 52266, 52268, 27697, 35895, 44087, 44088, 52284, 52285, 52286, 35903, 44096, 52297, 35917, 52302, 35921, 35926, 35937, 27746, 27747, 52322, 27749, 52330, 52333, 35950, 35951, 52334, 52339, 60533, 52342, 44153, 44169, 52366, 35986, 27795, 44181, 52377, 27803, 52379, 52380, 52382, 60573, 44199, 52397, 36018, 36019, 44210, 36025, 36026, 52410, 52414, 52417, 52418, 36038, 36039, 44230, 52425, 52427, 52429, 36047, 52432, 44243, 52435, 52438, 44254, 52447, 52450, 36068, 52452, 52458, 44267, 44268, 52464, 52468, 36093, 36094, 36095, 27905, 52481, 52483, 52484, 27911, 52488, 27926, 52504, 36121, 36122, 52511, 27944, 36137, 36138, 36141, 44333, 52534, 44345, 52539, 44350, 44356, 44359, 52551, 52552, 52556, 52557, 36176, 36178, 44372, 44376, 52571, 27998, 36190, 36191, 28001, 36192, 52574, 52579, 36198, 52582, 60775, 44393, 44394, 44396, 52595, 36213, 36218, 36220, 52606, 60806, 52618, 28044, 52620, 60816, 52646, 52647, 28075, 28076, 52654, 28080, 44474, 52670, 28096, 44480, 52672, 28099, 52673, 52676, 52677, 44492, 52685, 44494, 52686, 52694, 52695, 44507, 52701, 52702, 36319, 52706, 28132, 52708, 52716, 36334, 52721, 36344, 36345, 44551, 52743, 52759, 52761, 44570, 28190, 36388, 36389, 36397, 36401, 52787, 52789, 60996, 44617, 44618, 28239, 52818, 52822, 28247, 52826, 28253, 36445, 36446, 52829, 52839, 36463, 52850, 52856, 44665, 52857, 52864, 44679, 36491, 52879, 36499, 28310, 52898, 52909, 28337, 36530, 44723, 61116, 36542, 28360, 28361, 28364, 28365, 28366, 28367, 52947, 52953, 52965, 52966, 52977, 44787, 52982, 52986, 44796, 44799, 36616, 53000, 28432, 53009, 53015, 53016, 53020, 44831, 44832, 53031, 53033, 53037, 44846, 36659, 44851, 44854, 53049, 28477, 61249, 53058, 28484, 53061, 36678, 53063, 61272, 36698, 53084, 53088, 53103, 53106, 44917, 53109, 53118, 53124, 53131, 53133, 44948, 44970, 53169, 53171, 28596, 53180, 36798, 53192, 28623, 53199, 53200, 45015, 53207, 53212, 45021, 53214, 53215, 28655, 53233, 53234, 53235, 53238, 36870, 45064, 53259, 45068, 45069, 61453, 45076, 36886, 45083, 45091, 53294, 53306, 36925, 28739, 45131, 36940, 45133, 53326, 53327, 28761, 53349, 45160, 36969, 53354, 53364, 53366, 53372, 37000, 45193, 53384, 28813, 53393, 28821, 53400, 45218, 45233, 53427, 28852, 61624, 37054, 37055, 37056, 28881, 37074, 37075, 53459, 37084, 37086, 37087, 37097, 45290, 28909, 45319, 61705, 28941, 53524, 28949, 53525, 37145, 28954, 28968, 45357, 37168, 45360, 37177, 53575, 45392, 37202, 37206, 53602, 45413, 61811, 37236, 53620, 53621, 53622, 53626, 61821, 53643, 53644, 61839, 29076, 53653, 53660, 45474, 37283, 45477, 45480, 53685, 45496, 29123, 29124, 45508, 53701, 37325, 37326, 45517, 61908, 61913, 45535, 29156, 29157, 61931, 29168, 37366, 45565, 61949, 29186, 45570, 45574, 29195, 37393, 37407, 29217, 53800, 29246, 37439, 29252, 62026, 53836, 45646, 62033, 53845, 45659, 29277, 45663, 37476, 62057, 37495, 37501, 45693, 37512, 37527, 62106, 37535, 45728, 45735, 53928, 37548, 29367, 53946, 29373, 37567, 37585, 45777, 37594, 37598, 37602, 62181, 45801, 53996, 45810, 45816, 54010, 37627, 45819, 45824, 37646, 45846, 45853, 29470, 37669, 62254, 37693, 54079, 54080, 62274, 37707, 37709, 37714, 62302, 37737, 45930, 37741, 45933, 62326, 45955, 62345, 29589, 54165, 54170, 62364, 37800, 37801, 29610, 37802, 29612, 45997, 46000, 62385, 46007, 37819, 37828, 37829, 62405, 54217, 54218, 29644, 29645, 29646, 29649, 29650, 62417, 29652, 62421, 54234, 46044, 54241, 29674, 29680, 62448, 37879, 29710, 54287, 29713, 37905, 62484, 29727, 37920, 54315, 37934, 29749, 46145, 54344, 37963, 29775, 46173, 29795, 29808, 29810, 29811, 46199, 62584, 29834, 38028, 62606, 62607, 38056, 29865, 62636, 38064, 54453, 46278, 46279, 38096, 62694, 54504, 38121, 38122, 62709, 62715, 54527, 46337, 29959, 38152, 38155, 29982, 29988, 38182, 54569, 46381, 62766, 38192, 54580, 46395, 46397, 46401, 46406, 30023, 54599, 54607, 46416, 38226, 30036, 30037, 46420, 46423, 62809, 46427, 46428, 62815, 54624, 62816, 46434, 46435, 54627, 30053, 46440, 46441, 30058, 46447, 46448, 46452, 46457, 46458, 54653, 38270, 46463, 38272, 46467, 46468, 46473, 46476, 46479, 46480, 46485, 46486, 46488, 30107, 46492, 46498, 46513, 38329, 46521, 46527, 46531, 62917, 46535, 46539, 46541, 62925, 62945, 30184, 54761, 30192, 30202, 54778, 38400, 30212, 46599, 30216, 38408, 46610, 38422, 38425, 38426, 30240, 38440, 38441, 46632, 46636, 54835, 46644, 38462, 54859, 46669, 46681, 54879, 30308, 46698, 46702, 30325, 46709, 38527, 46722, 46724, 46728, 46733, 38545, 46741, 30372, 38567, 38568, 38569, 30386, 46779, 63164, 38589, 30423, 38622, 30441, 55028, 38648, 46841, 55038, 38655, 63254, 22301, 55072, 46882, 55076, 22316, 22326, 38711, 22329, 46909, 46910, 22336, 38720, 22339, 63301, 38728, 63304, 63308, 22350, 55118, 63312, 22354, 22355, 55122, 63314, 22360, 46936, 38751, 46943, 38755, 30568, 22377, 30574, 22383, 30577, 63347, 38773, 38775, 22392, 38781, 22404, 46981, 22406, 22407, 30602, 63372, 22415, 22416, 63378, 22420, 22430, 47009, 22436, 22438, 22439, 30639, 22454, 47030, 22456, 55225, 38851, 47045, 22472, 22474, 22475, 22485, 22488, 22489, 22499, 47077, 30696, 30697, 47085, 30703, 38897, 38900, 47093, 22525, 22540, 38927, 30743, 55327, 22561, 55333, 38953, 47146, 22571, 38955, 22577, 22581, 22584, 63544, 63545, 30779, 63546, 47165, 63547, 63548, 30788, 22602, 22603, 22604, 22607, 22609, 30801, 63573, 63574, 30807, 22618, 22619, 22621, 39006, 22625, 22631, 22646, 22648, 22653, 47231, 22659, 22664, 30857, 22670, 22675, 30867, 30868, 22678, 39061, 22682, 22685, 22686, 22688, 55461, 22694, 22696, 63660, 22701, 30894, 63664, 39091, 30905, 47294, 39103, 22726, 30924, 22740, 47317, 63702, 47319, 39129, 22746, 30939, 30942, 22756, 22757, 47333, 22766, 22767, 22778, 30970, 39164, 22781, 22784, 22785, 47366, 30984, 30985, 30989, 55576, 22815, 47392, 22833, 22839, 39224, 47415, 63802, 47423, 47424, 63808, 22854, 22858, 22859, 31074, 47462, 22887, 22888, 22889, 39274, 63846, 39280, 31090, 22904, 22908, 47484, 22922, 22925, 22927, 55695, 22948, 31140, 22952, 22954, 55724, 31149, 31153, 39353, 39354, 55738, 31169, 22984, 63947, 22994, 31189, 23007, 55776, 55777, 23010, 55778, 55779, 55781, 23014, 23015, 23016, 39398, 39399, 55782, 55783, 55784, 23030, 63992, 31225, 63994, 23036, 23037, 23038, 23040, 23041, 23042, 23043, 23044, 47617, 47628, 23055, 23063, 23064, 64029, 64033, 47652, 23077, 64038, 64041, 64043, 47660, 39470, 39471, 64046, 23089, 64050, 64054, 23096, 39481, 64058, 55867, 64061, 39490, 39491, 64068, 23118, 55888, 31315, 31316, 31317, 47704, 23134, 47710, 23137, 23138, 47715, 23145, 31343, 47730, 39540, 23159, 23160, 31353, 64122, 31360, 64133, 23188, 39573, 55957, 39575, 23192, 55958, 23194, 47770, 55960, 55961, 23198, 55963, 55964, 23201, 23202, 55966, 23210, 23211, 23212, 55979, 55982, 64177, 31412, 31413, 47801, 23235, 56008, 64201, 31436, 31437, 23246, 23247, 47834, 23262, 31454, 39648, 23269, 31466, 39659, 64237, 39662, 23279, 23280, 39666, 47861, 23287, 47877, 23306, 31500, 23309, 56078, 23312, 64275, 39700, 56086, 39704, 23325, 56094, 23327, 23329, 31521, 31522, 23332, 47910, 64294, 39720, 64299, 64300, 39728, 64305, 39731, 56115, 31542, 31543, 23355, 23358, 47935, 31552, 23363, 39749, 23373, 23374, 47950, 39760, 64336, 31574, 23386, 39783, 31593, 39788, 23405, 39791, 23410, 47987, 39797, 23415, 23417, 31612, 23421, 31617, 23426, 48002, 31620, 64385, 23430, 31626, 39828, 23445, 39832, 64409, 23450, 31644, 31645, 23455, 64415, 31650, 31651, 48035, 56226, 23465, 23466, 23479, 31671, 31672, 31676, 56254, 23488, 23489, 48064, 39875, 39877, 23499, 23500, 64460, 39886, 23503, 23504, 39895, 31704, 31705, 23526, 31719, 48103, 31735, 23546, 31752, 48137, 23571, 39958, 48158, 56352, 48167, 64551, 23597, 23602, 31795, 31796, 39997, 40001, 23618, 23627, 56397, 23631, 23632, 64592, 31827, 31835, 40033, 23653, 40037, 64617, 64622, 64628, 23669, 56442, 56444, 40073, 56459, 23697, 23698, 23699, 40084, 23701, 64661, 40087, 64668, 40095, 48287, 31908, 31909, 40102, 48298, 56492, 31917, 40110, 48301, 64695, 31929, 40125, 23747, 23752, 23755, 64717, 48334, 31951, 23760, 31959, 64735, 23779, 23780, 40165, 40166, 56549, 48362, 56556, 31987, 56573, 56574, 56575, 32008, 23817, 40201, 32015, 32019, 40211, 40215, 32036, 32037, 40237, 64814, 32061, 32062, 40258, 64834, 48453, 64839, 23885, 64847, 32080, 32083, 23892, 23908, 48484, 23913, 23914, 32105, 40299, 56684, 23920, 56688, 56690, 48502, 23931, 64899, 32132, 23947, 64912, 64917, 23961, 48542, 56734, 40354, 64934, 23976, 40361, 64937, 64939, 64945, 40370, 40371, 64947, 32181, 40378, 48573, 40383, 40385, 24004, 48581, 24011, 48587, 64971, 24025, 32223, 64994, 40419, 32230, 48614, 65003, 32238, 32241, 32243, 32247, 48632, 32253, 32257, 40451, 32260, 24070, 32264, 40456, 32266, 48649, 32270, 56847, 32272, 32275, 32278, 56856, 32282, 24092, 32284, 24094, 24095, 56863, 65057, 24099, 65059, 40508, 56894, 48705, 65089, 32324, 24133, 56903, 32329, 56908, 65100, 32335, 65106, 40540, 56930, 24172, 24173, 32367, 56951, 40571, 56957, 48767, 65152, 65155, 48775, 56967, 56968, 40586, 65169, 24210, 48792, 24219, 24220, 24221, 32416, 65187, 65191, 24237, 24238, 40627, 24247, 24248, 65212, 65213, 24258, 57027, 24262, 40646, 24265, 48843, 24268, 24269, 24270, 24271, 32460, 32463, 24284, 24285, 57060, 65252, 32486, 32493, 32499, 24313, 24314, 32507, 40701, 57097, 32522, 48906, 24337, 24338, 32530, 24343, 24352, 24356, 65318, 65319, 57131, 57133, 24367, 32563, 32564, 57141, 24383, 32577, 24389, 65360, 24401, 65361, 65362, 65363, 32597, 48991, 24417, 32614, 32615, 65384, 65387, 24430, 32623, 57198, 24439, 24440, 57207, 65401, 65402, 24445, 24456, 65419, 49036, 40846, 40851, 40852, 24469, 24470, 57248, 57254, 65449, 24490, 32683, 57260, 24493, 24494, 57263, 24496, 57266, 57267, 57270, 24503, 24504, 57273, 65462, 65463, 65472, 24514, 24515, 49093, 65478, 65483, 65484, 24526, 49106, 49107, 49108, 65490, 32728, 40920, 57304, 57305, 32735, 49119, 40931, 40932, 40933, 57316, 57320, 24554, 57323, 24561, 57339) GROUP BY Inv.ServiceSetupId;... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,790 - 12111 - src.utils.log - INFO - ✅ Fetched 2038 rows - __SPLIT__
2026-08-03 17:02:54,808 - 12111 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-08-03 17:02:54,808 - 12111 - src.utils.log - INFO - 📥 Inserting into Billing.TransactionAutoGeneration: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:54,885 - 12111 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into Billing.TransactionAutoGeneration - __SPLIT__
2026-08-03 17:02:55,012 - 12111 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into Billing.TransactionAutoGeneration in 1 batches - __SPLIT__
2026-08-03 17:02:55,013 - 12111 - src.utils.log - INFO -
- __SPLIT__
2026-08-03 17:02:55,013 - 12111 - src.utils.log - INFO - Total invoice generated: 9
- __SPLIT__
2026-08-03 17:02:55,013 - 12111 - src.utils.log - INFO - 🔍 Fetching data: Select TOP 9 TransactionAutoGenerationId, ServiceSetupId,
TransactionDate as InvoiceDate From Billing.TransactionAutoGeneration WHERE CreatedDate = '2026-08-01 06:31:16.923'
and ServiceSetupId in (65538, 40964, 57350, 24583, 65543, 65546, 65549, 40976, 65552, 49170, 65554, 65557, 24599, 57367, 65560, 65563, 24604, 49180, 24606, 40990, 57376, 24609, 32811, 57387, 41006, 41007, 49203, 65589, 24644, 24645, 24654, 32851, 32855, 57442, 49261, 24689, 65653, 24694, 24695, 57464, 32889, 24705, 24713, 65673, 24715, 41100, 65677, 32913, 32917, 24731, 24732, 24733, 41119, 65696, 24759, 57528, 65720, 57531, 24781, 24782, 65742, 24785, 32978, 32980, 32984, 24793, 49369, 32999, 41191, 41192, 65769, 65770, 33004, 65771, 65772, 65773, 65774, 65775, 65776, 41203, 41204, 65777, 65778, 57591, 33028, 24848, 24849, 24853, 65815, 41243, 24869, 49446, 33072, 33075, 57658, 24891, 24903, 41295, 24913, 24917, 65880, 49504, 41314, 65893, 49511, 41320, 33152, 24964, 65929, 24971, 24972, 24973, 24975, 33172, 65942, 57752, 24986, 33178, 24988, 24993, 65960, 25002, 65963, 65967, 65969, 33203, 33204, 65972, 65977, 65980, 33216, 41410, 65989, 49606, 65993, 65995, 41423, 66002, 33239, 41435, 49630, 33253, 33254, 66024, 49641, 41450, 41459, 49655, 41464, 41468, 33280, 33281, 33282, 25091, 66049, 57863, 33290, 41484, 25104, 41489, 33298, 25115, 25116, 25117, 49691, 41507, 49699, 25126, 49704, 57897, 33323, 49707, 41519, 49712, 33329, 57910, 57911, 49720, 57912, 66102, 49731, 49735, 25166, 49744, 49752, 49753, 57952, 41569, 49763, 57955, 49767, 49775, 66159, 49779, 25205, 49783, 66169, 49787, 41596, 49791, 25219, 41604, 41611, 49805, 33424, 49809, 33432, 49817, 41627, 66209, 41640, 25258, 58027, 25266, 33461, 33463, 41656, 41657, 58041, 25276, 33473, 33480, 25290, 25293, 25294, 25310, 49888, 49896, 33513, 25323, 49903, 58099, 41727, 49924, 25353, 41758, 41759, 41773, 33582, 49970, 33591, 41790, 41797, 41799, 49991, 49995, 66385, 50005, 50015, 41827, 25454, 25455, 50037, 41850, 50042, 50046, 66430, 25474, 50050, 33669, 41862, 41864, 41867, 41874, 41876, 66459, 25514, 25515, 25516, 41898, 41909, 50101, 41913, 50109, 25537, 25538, 58306, 25555, 25562, 25579, 41966, 58351, 25584, 41971, 50168, 41979, 50172, 41983, 50175, 58372, 41997, 66585, 42010, 25628, 25629, 25632, 50214, 33836, 33839, 33841, 66609, 25652, 66618, 42045, 50238, 42047, 42053, 42054, 33864, 66633, 42062, 33877, 42069, 42072, 58456, 42085, 42096, 33906, 50291, 33908, 42101, 42102, 50295, 33914, 50299, 50303, 33928, 50312, 33932, 33933, 25742, 42129, 50321, 66707, 33951, 33952, 50336, 42146, 50340, 42154, 33968, 66742, 42169, 42174, 50371, 34009, 34011, 66783, 34022, 34023, 34024, 66795, 50417, 25844, 66810, 25851, 34056, 50444, 25871, 25873, 25878, 42279, 42282, 50474, 42285, 50491, 50494, 50500, 34119, 50506, 50509, 66893, 25936, 50512, 50515, 66900, 34134, 50518, 34137, 42332, 50524, 50530, 50539, 66925, 50542, 66928, 50545, 25971, 50548, 25973, 25975, 50552, 50557, 50561, 25986, 50565, 34182, 42374, 50568, 42379, 34188, 50571, 34190, 42385, 58769, 50579, 50580, 42389, 50588, 50589, 42402, 50595, 26020, 42408, 34218, 34224, 50613, 34243, 42450, 26072, 34274, 34275, 26090, 58862, 42483, 26101, 34296, 42494, 67070, 67072, 42506, 50708, 67105, 42533, 42549, 67126, 42557, 34375, 50762, 26194, 26203, 50780, 42589, 58972, 42591, 42594, 34406, 50795, 42604, 58988, 42607, 42609, 34423, 34424, 34429, 50814, 50818, 50827, 26255, 26271, 67235, 26280, 26281, 34473, 59048, 34487, 50871, 50872, 34495, 42699, 50893, 42706, 42714, 26337, 26340, 34533, 34534, 34535, 59117, 67311, 42738, 67318, 50953, 34570, 26388, 67350, 34591, 26402, 67369, 50989, 34609, 34612, 42814, 59210, 34641, 42834, 51028, 51033, 67424, 42851, 42860, 26484, 34676, 51062, 42872, 59257, 34682, 34683, 42874, 59266, 34694, 34695, 59272, 59273, 59279, 26514, 59283, 26517, 34713, 51100, 42912, 34726, 42923, 26559, 34761, 42953, 51150, 51164, 67559, 34794, 34795, 34796, 67569, 59380, 67577, 67582, 26636, 34829, 51222, 43048, 51242, 67627, 26668, 43058, 67636, 67638, 26679, 67644, 26703, 34902, 34903, 26712, 34904, 51298, 59494, 59498, 26732, 34936, 26746, 51330, 43140, 59525, 51334, 34953, 51340, 43157, 43164, 43170, 43174, 26798, 34992, 34993, 35001, 67772, 67775, 67780, 51398, 35020, 43213, 43220, 59604, 67797, 59614, 51429, 26861, 26862, 51442, 26867, 26868, 43253, 51454, 26884, 59654, 35079, 67866, 43293, 51486, 43298, 51496, 26921, 26922, 67886, 51503, 43314, 51508, 51516, 43330, 26952, 67914, 43352, 43356, 26976, 35170, 59748, 67954, 43380, 67958, 51575, 51589, 27016, 27017, 43401, 51592, 51598, 35221, 35226, 51623, 51625, 68011, 43444, 68021, 35259, 68033, 27076, 51654, 51656, 43466, 43467, 51661, 51679, 27104, 51684, 68076, 51693, 51694, 68081, 35317, 68085, 68086, 51705, 43518, 35329, 35332, 51719, 51720, 68104, 51722, 43531, 51726, 27154, 51734, 43544, 51737, 51740, 68124, 51748, 27177, 27178, 43563, 43565, 51759, 59959, 35390, 51776, 51780, 35406, 43602, 43603, 43605, 51799, 59993, 51803, 35420, 51806, 43618, 27244, 68208, 43633, 35444, 43637, 51828, 68220, 27261, 27262, 51843, 51844, 60038, 51853, 35476, 60061, 35488, 43685, 51886, 68274, 51893, 68279, 51896, 60090, 51901, 51911, 51912, 51914, 27340, 35540, 27351, 51932, 27359, 27360, 51936, 51943, 43758, 51956, 35577, 51972, 51982, 35606, 43800, 51992, 51994, 68379, 52001, 27426, 52002, 60200, 43824, 52020, 52025, 68412, 52030, 68415, 52032, 68418, 52035, 27462, 35657, 27466, 52045, 43856, 52051, 52052, 52060, 52061, 52062, 43878, 35687, 35689, 35690, 52078, 68467, 68471, 52089, 52092, 52093, 35710, 35711, 27526, 52106, 68490, 27532, 68492, 60303, 68496, 27541, 35737, 35738, 68505, 52130, 60332, 60334, 60336, 27571, 60342, 43959, 52153, 35772, 52160, 52166, 60361, 43978, 35786, 27599, 52175, 43985, 60367, 60368, 60371, 60375, 35802, 68570, 68575, 52197, 52201, 35828, 35829, 52213, 27641, 27642, 35837, 44030, 44031, 52226, 27652, 35846, 44039, 44040, 60423, 52234, 52235, 52238, 27663, 52244, 44053, 52247, 52250, 52254, 35871, 52255, 44065, 27683, 52260, 35880, 44072, 52266, 52268, 27697, 35895, 44087, 44088, 52284, 52285, 52286, 35903, 44096, 52297, 35917, 52302, 35921, 35926, 35937, 27746, 27747, 52322, 27749, 52330, 52333, 35950, 35951, 52334, 52339, 60533, 52342, 44153, 44169, 52366, 35986, 27795, 44181, 52377, 27803, 52379, 52380, 52382, 60573, 44199, 52397, 36018, 36019, 44210, 36025, 36026, 52410, 52414, 52417, 52418, 36038, 36039, 44230, 52425, 52427, 52429, 36047, 52432, 44243, 52435, 52438, 44254, 52447, 52450, 36068, 52452, 52458, 44267, 44268, 52464, 52468, 36093, 36094, 36095, 27905, 52481, 52483, 52484, 27911, 52488, 27926, 52504, 36121, 36122, 52511, 27944, 36137, 36138, 36141, 44333, 52534, 44345, 52539, 44350, 44356, 44359, 52551, 52552, 52556, 52557, 36176, 36178, 44372, 44376, 52571, 27998, 36190, 36191, 28001, 36192, 52574, 52579, 36198, 52582, 60775, 44393, 44394, 44396, 52595, 36213, 36218, 36220, 52606, 60806, 52618, 28044, 52620, 60816, 52646, 52647, 28075, 28076, 52654, 28080, 44474, 52670, 28096, 44480, 52672, 28099, 52673, 52676, 52677, 44492, 52685, 44494, 52686, 52694, 52695, 44507, 52701, 52702, 36319, 52706, 28132, 52708, 52716, 36334, 52721, 36344, 36345, 44551, 52743, 52759, 52761, 44570, 28190, 36388, 36389, 36397, 36401, 52787, 52789, 60996, 44617, 44618, 28239, 52818, 52822, 28247, 52826, 28253, 36445, 36446, 52829, 52839, 36463, 52850, 52856, 44665, 52857, 52864, 44679, 36491, 52879, 36499, 28310, 52898, 52909, 28337, 36530, 44723, 61116, 36542, 28360, 28361, 28364, 28365, 28366, 28367, 52947, 52953, 52965, 52966, 52977, 44787, 52982, 52986, 44796, 44799, 36616, 53000, 28432, 53009, 53015, 53016, 53020, 44831, 44832, 53031, 53033, 53037, 44846, 36659, 44851, 44854, 53049, 28477, 61249, 53058, 28484, 53061, 36678, 53063, 61272, 36698, 53084, 53088, 53103, 53106, 44917, 53109, 53118, 53124, 53131, 53133, 44948, 44970, 53169, 53171, 28596, 53180, 36798, 53192, 28623, 53199, 53200, 45015, 53207, 53212, 45021, 53214, 53215, 28655, 53233, 53234, 53235, 53238, 36870, 45064, 53259, 45068, 45069, 61453, 45076, 36886, 45083, 45091, 53294, 53306, 36925, 28739, 45131, 36940, 45133, 53326, 53327, 28761, 53349, 45160, 36969, 53354, 53364, 53366, 53372, 37000, 45193, 53384, 28813, 53393, 28821, 53400, 45218, 45233, 53427, 28852, 61624, 37054, 37055, 37056, 28881, 37074, 37075, 53459, 37084, 37086, 37087, 37097, 45290, 28909, 45319, 61705, 28941, 53524, 28949, 53525, 37145, 28954, 28968, 45357, 37168, 45360, 37177, 53575, 45392, 37202, 37206, 53602, 45413, 61811, 37236, 53620, 53621, 53622, 53626, 61821, 53643, 53644, 61839, 29076, 53653, 53660, 45474, 37283, 45477, 45480, 53685, 45496, 29123, 29124, 45508, 53701, 37325, 37326, 45517, 61908, 61913, 45535, 29156, 29157, 61931, 29168, 37366, 45565, 61949, 29186, 45570, 45574, 29195, 37393, 37407, 29217, 53800, 29246, 37439, 29252, 62026, 53836, 45646, 62033, 53845, 45659, 29277, 45663, 37476, 62057, 37495, 37501, 45693, 37512, 37527, 62106, 37535, 45728, 45735, 53928, 37548, 29367, 53946, 29373, 37567, 37585, 45777, 37594, 37598, 37602, 62181, 45801, 53996, 45810, 45816, 54010, 37627, 45819, 45824, 37646, 45846, 45853, 29470, 37669, 62254, 37693, 54079, 54080, 62274, 37707, 37709, 37714, 62302, 37737, 45930, 37741, 45933, 62326, 45955, 62345, 29589, 54165, 54170, 62364, 37800, 37801, 29610, 37802, 29612, 45997, 46000, 62385, 46007, 37819, 37828, 37829, 62405, 54217, 54218, 29644, 29645, 29646, 29649, 29650, 62417, 29652, 62421, 54234, 46044, 54241, 29674, 29680, 62448, 37879, 29710, 54287, 29713, 37905, 62484, 29727, 37920, 54315, 37934, 29749, 46145, 54344, 37963, 29775, 46173, 29795, 29808, 29810, 29811, 46199, 62584, 29834, 38028, 62606, 62607, 38056, 29865, 62636, 38064, 54453, 46278, 46279, 38096, 62694, 54504, 38121, 38122, 62709, 62715, 54527, 46337, 29959, 38152, 38155, 29982, 29988, 38182, 54569, 46381, 62766, 38192, 54580, 46395, 46397, 46401, 46406, 30023, 54599, 54607, 46416, 38226, 30036, 30037, 46420, 46423, 62809, 46427, 46428, 62815, 54624, 62816, 46434, 46435, 54627, 30053, 46440, 46441, 30058, 46447, 46448, 46452, 46457, 46458, 54653, 38270, 46463, 38272, 46467, 46468, 46473, 46476, 46479, 46480, 46485, 46486, 46488, 30107, 46492, 46498, 46513, 38329, 46521, 46527, 46531, 62917, 46535, 46539, 46541, 62925, 62945, 30184, 54761, 30192, 30202, 54778, 38400, 30212, 46599, 30216, 38408, 46610, 38422, 38425, 38426, 30240, 38440, 38441, 46632, 46636, 54835, 46644, 38462, 54859, 46669, 46681, 54879, 30308, 46698, 46702, 30325, 46709, 38527, 46722, 46724, 46728, 46733, 38545, 46741, 30372, 38567, 38568, 38569, 30386, 46779, 63164, 38589, 30423, 38622, 30441, 55028, 38648, 46841, 55038, 38655, 63254, 22301, 55072, 46882, 55076, 22316, 22326, 38711, 22329, 46909, 46910, 22336, 38720, 22339, 63301, 38728, 63304, 63308, 22350, 55118, 63312, 22354, 22355, 55122, 63314, 22360, 46936, 38751, 46943, 38755, 30568, 22377, 30574, 22383, 30577, 63347, 38773, 38775, 22392, 38781, 22404, 46981, 22406, 22407, 30602, 63372, 22415, 22416, 63378, 22420, 22430, 47009, 22436, 22438, 22439, 30639, 22454, 47030, 22456, 55225, 38851, 47045, 22472, 22474, 22475, 22485, 22488, 22489, 22499, 47077, 30696, 30697, 47085, 30703, 38897, 38900, 47093, 22525, 22540, 38927, 30743, 55327, 22561, 55333, 38953, 47146, 22571, 38955, 22577, 22581, 22584, 63544, 63545, 30779, 63546, 47165, 63547, 63548, 30788, 22602, 22603, 22604, 22607, 22609, 30801, 63573, 63574, 30807, 22618, 22619, 22621, 39006, 22625, 22631, 22646, 22648, 22653, 47231, 22659, 22664, 30857, 22670, 22675, 30867, 30868, 22678, 39061, 22682, 22685, 22686, 22688, 55461, 22694, 22696, 63660, 22701, 30894, 63664, 39091, 30905, 47294, 39103, 22726, 30924, 22740, 47317, 63702, 47319, 39129, 22746, 30939, 30942, 22756, 22757, 47333, 22766, 22767, 22778, 30970, 39164, 22781, 22784, 22785, 47366, 30984, 30985, 30989, 55576, 22815, 47392, 22833, 22839, 39224, 47415, 63802, 47423, 47424, 63808, 22854, 22858, 22859, 31074, 47462, 22887, 22888, 22889, 39274, 63846, 39280, 31090, 22904, 22908, 47484, 22922, 22925, 22927, 55695, 22948, 31140, 22952, 22954, 55724, 31149, 31153, 39353, 39354, 55738, 31169, 22984, 63947, 22994, 31189, 23007, 55776, 55777, 23010, 55778, 55779, 55781, 23014, 23015, 23016, 39398, 39399, 55782, 55783, 55784, 23030, 63992, 31225, 63994, 23036, 23037, 23038, 23040, 23041, 23042, 23043, 23044, 47617, 47628, 23055, 23063, 23064, 64029, 64033, 47652, 23077, 64038, 64041, 64043, 47660, 39470, 39471, 64046, 23089, 64050, 64054, 23096, 39481, 64058, 55867, 64061, 39490, 39491, 64068, 23118, 55888, 31315, 31316, 31317, 47704, 23134, 47710, 23137, 23138, 47715, 23145, 31343, 47730, 39540, 23159, 23160, 31353, 64122, 31360, 64133, 23188, 39573, 55957, 39575, 23192, 55958, 23194, 47770, 55960, 55961, 23198, 55963, 55964, 23201, 23202, 55966, 23210, 23211, 23212, 55979, 55982, 64177, 31412, 31413, 47801, 23235, 56008, 64201, 31436, 31437, 23246, 23247, 47834, 23262, 31454, 39648, 23269, 31466, 39659, 64237, 39662, 23279, 23280, 39666, 47861, 23287, 47877, 23306, 31500, 23309, 56078, 23312, 64275, 39700, 56086, 39704, 23325, 56094, 23327, 23329, 31521, 31522, 23332, 47910, 64294, 39720, 64299, 64300, 39728, 64305, 39731, 56115, 31542, 31543, 23355, 23358, 47935, 31552, 23363, 39749, 23373, 23374, 47950, 39760, 64336, 31574, 23386, 39783, 31593, 39788, 23405, 39791, 23410, 47987, 39797, 23415, 23417, 31612, 23421, 31617, 23426, 48002, 31620, 64385, 23430, 31626, 39828, 23445, 39832, 64409, 23450, 31644, 31645, 23455, 64415, 31650, 31651, 48035, 56226, 23465, 23466, 23479, 31671, 31672, 31676, 56254, 23488, 23489, 48064, 39875, 39877, 23499, 23500, 64460, 39886, 23503, 23504, 39895, 31704, 31705, 23526, 31719, 48103, 31735, 23546, 31752, 48137, 23571, 39958, 48158, 56352, 48167, 64551, 23597, 23602, 31795, 31796, 39997, 40001, 23618, 23627, 56397, 23631, 23632, 64592, 31827, 31835, 40033, 23653, 40037, 64617, 64622, 64628, 23669, 56442, 56444, 40073, 56459, 23697, 23698, 23699, 40084, 23701, 64661, 40087, 64668, 40095, 48287, 31908, 31909, 40102, 48298, 56492, 31917, 40110, 48301, 64695, 31929, 40125, 23747, 23752, 23755, 64717, 48334, 31951, 23760, 31959, 64735, 23779, 23780, 40165, 40166, 56549, 48362, 56556, 31987, 56573, 56574, 56575, 32008, 23817, 40201, 32015, 32019, 40211, 40215, 32036, 32037, 40237, 64814, 32061, 32062, 40258, 64834, 48453, 64839, 23885, 64847, 32080, 32083, 23892, 23908, 48484, 23913, 23914, 32105, 40299, 56684, 23920, 56688, 56690, 48502, 23931, 64899, 32132, 23947, 64912, 64917, 23961, 48542, 56734, 40354, 64934, 23976, 40361, 64937, 64939, 64945, 40370, 40371, 64947, 32181, 40378, 48573, 40383, 40385, 24004, 48581, 24011, 48587, 64971, 24025, 32223, 64994, 40419, 32230, 48614, 65003, 32238, 32241, 32243, 32247, 48632, 32253, 32257, 40451, 32260, 24070, 32264, 40456, 32266, 48649, 32270, 56847, 32272, 32275, 32278, 56856, 32282, 24092, 32284, 24094, 24095, 56863, 65057, 24099, 65059, 40508, 56894, 48705, 65089, 32324, 24133, 56903, 32329, 56908, 65100, 32335, 65106, 40540, 56930, 24172, 24173, 32367, 56951, 40571, 56957, 48767, 65152, 65155, 48775, 56967, 56968, 40586, 65169, 24210, 48792, 24219, 24220, 24221, 32416, 65187, 65191, 24237, 24238, 40627, 24247, 24248, 65212, 65213, 24258, 57027, 24262, 40646, 24265, 48843, 24268, 24269, 24270, 24271, 32460, 32463, 24284, 24285, 57060, 65252, 32486, 32493, 32499, 24313, 24314, 32507, 40701, 57097, 32522, 48906, 24337, 24338, 32530, 24343, 24352, 24356, 65318, 65319, 57131, 57133, 24367, 32563, 32564, 57141, 24383, 32577, 24389, 65360, 24401, 65361, 65362, 65363, 32597, 48991, 24417, 32614, 32615, 65384, 65387, 24430, 32623, 57198, 24439, 24440, 57207, 65401, 65402, 24445, 24456, 65419, 49036, 40846, 40851, 40852, 24469, 24470, 57248, 57254, 65449, 24490, 32683, 57260, 24493, 24494, 57263, 24496, 57266, 57267, 57270, 24503, 24504, 57273, 65462, 65463, 65472, 24514, 24515, 49093, 65478, 65483, 65484, 24526, 49106, 49107, 49108, 65490, 32728, 40920, 57304, 57305, 32735, 49119, 40931, 40932, 40933, 57316, 57320, 24554, 57323, 24561, 57339) and GenerateWorkOrderHistoryId = 12111;... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,165 - 12111 - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-08-03 17:02:55,173 - 12111 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-08-03 17:02:55,173 - 12111 - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceAutoGeneration: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,223 - 12111 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into Billing.InvoiceAutoGeneration - __SPLIT__
2026-08-03 17:02:55,337 - 12111 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into Billing.InvoiceAutoGeneration in 1 batches - __SPLIT__
2026-08-03 17:02:55,338 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT I.InvoiceAutoGenerationId, T.ServiceSetupId FROM Billing.InvoiceAutoGeneration I
JOIN Billing.TransactionAutoGeneration T ON I.TransactionAutoGenerationId = T.TransactionAutoGenerationId where
T.TransactionAutoGenerationId in (194368, 194369, 194361, 194362, 194363, 194364, 194365, 194366, 194367);... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,369 - 12111 - src.utils.log - INFO - ✅ Fetched 9 rows - __SPLIT__
2026-08-03 17:02:55,370 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyRoundingLevel ,CompanyRoundingMethod
FROM common.CompanyConfiguration cc WHERE CompanyId = 133... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,401 - 12111 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-08-03 17:02:55,402 - 12111 - 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 (65538, 40964, 57350, 24583, 65543, 65546, 65549, 40976, 65552, 49170, 65554, 65557, 24599, 57367, 65560, 65563, 24604, 49180, 24606, 40990, 57376, 24609, 32811, 57387, 41006, 41007, 49203, 65589, 24644, 24645, 24654, 32851, 32855, 57442, 49261, 24689, 65653, 24694, 24695, 57464, 32889, 24705, 24713, 65673, 24715, 41100, 65677, 32913, 32917, 24731, 24732, 24733, 41119, 65696, 24759, 57528, 65720, 57531, 24781, 24782, 65742, 24785, 32978, 32980, 32984, 24793, 49369, 32999, 41191, 41192, 65769, 65770, 33004, 65771, 65772, 65773, 65774, 65775, 65776, 41203, 41204, 65777, 65778, 57591, 33028, 24848, 24849, 24853, 65815, 41243, 24869, 49446, 33072, 33075, 57658, 24891, 24903, 41295, 24913, 24917, 65880, 49504, 41314, 65893, 49511, 41320, 33152, 24964, 65929, 24971, 24972, 24973, 24975, 33172, 65942, 57752, 24986, 33178, 24988, 24993, 65960, 25002, 65963, 65967, 65969, 33203, 33204, 65972, 65977, 65980, 33216, 41410, 65989, 49606, 65993, 65995, 41423, 66002, 33239, 41435, 49630, 33253, 33254, 66024, 49641, 41450, 41459, 49655, 41464, 41468, 33280, 33281, 33282, 25091, 66049, 57863, 33290, 41484, 25104, 41489, 33298, 25115, 25116, 25117, 49691, 41507, 49699, 25126, 49704, 57897, 33323, 49707, 41519, 49712, 33329, 57910, 57911, 49720, 57912, 66102, 49731, 49735, 25166, 49744, 49752, 49753, 57952, 41569, 49763, 57955, 49767, 49775, 66159, 49779, 25205, 49783, 66169, 49787, 41596, 49791, 25219, 41604, 41611, 49805, 33424, 49809, 33432, 49817, 41627, 66209, 41640, 25258, 58027, 25266, 33461, 33463, 41656, 41657, 58041, 25276, 33473, 33480, 25290, 25293, 25294, 25310, 49888, 49896, 33513, 25323, 49903, 58099, 41727, 49924, 25353, 41758, 41759, 41773, 33582, 49970, 33591, 41790, 41797, 41799, 49991, 49995, 66385, 50005, 50015, 41827, 25454, 25455, 50037, 41850, 50042, 50046, 66430, 25474, 50050, 33669, 41862, 41864, 41867, 41874, 41876, 66459, 25514, 25515, 25516, 41898, 41909, 50101, 41913, 50109, 25537, 25538, 58306, 25555, 25562, 25579, 41966, 58351, 25584, 41971, 50168, 41979, 50172, 41983, 50175, 58372, 41997, 66585, 42010, 25628, 25629, 25632, 50214, 33836, 33839, 33841, 66609, 25652, 66618, 42045, 50238, 42047, 42053, 42054, 33864, 66633, 42062, 33877, 42069, 42072, 58456, 42085, 42096, 33906, 50291, 33908, 42101, 42102, 50295, 33914, 50299, 50303, 33928, 50312, 33932, 33933, 25742, 42129, 50321, 66707, 33951, 33952, 50336, 42146, 50340, 42154, 33968, 66742, 42169, 42174, 50371, 34009, 34011, 66783, 34022, 34023, 34024, 66795, 50417, 25844, 66810, 25851, 34056, 50444, 25871, 25873, 25878, 42279, 42282, 50474, 42285, 50491, 50494, 50500, 34119, 50506, 50509, 66893, 25936, 50512, 50515, 66900, 34134, 50518, 34137, 42332, 50524, 50530, 50539, 66925, 50542, 66928, 50545, 25971, 50548, 25973, 25975, 50552, 50557, 50561, 25986, 50565, 34182, 42374, 50568, 42379, 34188, 50571, 34190, 42385, 58769, 50579, 50580, 42389, 50588, 50589, 42402, 50595, 26020, 42408, 34218, 34224, 50613, 34243, 42450, 26072, 34274, 34275, 26090, 58862, 42483, 26101, 34296, 42494, 67070, 67072, 42506, 50708, 67105, 42533, 42549, 67126, 42557, 34375, 50762, 26194, 26203, 50780, 42589, 58972, 42591, 42594, 34406, 50795, 42604, 58988, 42607, 42609, 34423, 34424, 34429, 50814, 50818, 50827, 26255, 26271, 67235, 26280, 26281, 34473, 59048, 34487, 50871, 50872, 34495, 42699, 50893, 42706, 42714, 26337, 26340, 34533, 34534, 34535, 59117, 67311, 42738, 67318, 50953, 34570, 26388, 67350, 34591, 26402, 67369, 50989, 34609, 34612, 42814, 59210, 34641, 42834, 51028, 51033, 67424, 42851, 42860, 26484, 34676, 51062, 42872, 59257, 34682, 34683, 42874, 59266, 34694, 34695, 59272, 59273, 59279, 26514, 59283, 26517, 34713, 51100, 42912, 34726, 42923, 26559, 34761, 42953, 51150, 51164, 67559, 34794, 34795, 34796, 67569, 59380, 67577, 67582, 26636, 34829, 51222, 43048, 51242, 67627, 26668, 43058, 67636, 67638, 26679, 67644, 26703, 34902, 34903, 26712, 34904, 51298, 59494, 59498, 26732, 34936, 26746, 51330, 43140, 59525, 51334, 34953, 51340, 43157, 43164, 43170, 43174, 26798, 34992, 34993, 35001, 67772, 67775, 67780, 51398, 35020, 43213, 43220, 59604, 67797, 59614, 51429, 26861, 26862, 51442, 26867, 26868, 43253, 51454, 26884, 59654, 35079, 67866, 43293, 51486, 43298, 51496, 26921, 26922, 67886, 51503, 43314, 51508, 51516, 43330, 26952, 67914, 43352, 43356, 26976, 35170, 59748, 67954, 43380, 67958, 51575, 51589, 27016, 27017, 43401, 51592, 51598, 35221, 35226, 51623, 51625, 68011, 43444, 68021, 35259, 68033, 27076, 51654, 51656, 43466, 43467, 51661, 51679, 27104, 51684, 68076, 51693, 51694, 68081, 35317, 68085, 68086, 51705, 43518, 35329, 35332, 51719, 51720, 68104, 51722, 43531, 51726, 27154, 51734, 43544, 51737, 51740, 68124, 51748, 27177, 27178, 43563, 43565, 51759, 59959, 35390, 51776, 51780, 35406, 43602, 43603, 43605, 51799, 59993, 51803, 35420, 51806, 43618, 27244, 68208, 43633, 35444, 43637, 51828, 68220, 27261, 27262, 51843, 51844, 60038, 51853, 35476, 60061, 35488, 43685, 51886, 68274, 51893, 68279, 51896, 60090, 51901, 51911, 51912, 51914, 27340, 35540, 27351, 51932, 27359, 27360, 51936, 51943, 43758, 51956, 35577, 51972, 51982, 35606, 43800, 51992, 51994, 68379, 52001, 27426, 52002, 60200, 43824, 52020, 52025, 68412, 52030, 68415, 52032, 68418, 52035, 27462, 35657, 27466, 52045, 43856, 52051, 52052, 52060, 52061, 52062, 43878, 35687, 35689, 35690, 52078, 68467, 68471, 52089, 52092, 52093, 35710, 35711, 27526, 52106, 68490, 27532, 68492, 60303, 68496, 27541, 35737, 35738, 68505, 52130, 60332, 60334, 60336, 27571, 60342, 43959, 52153, 35772, 52160, 52166, 60361, 43978, 35786, 27599, 52175, 43985, 60367, 60368, 60371, 60375, 35802, 68570, 68575, 52197, 52201, 35828, 35829, 52213, 27641, 27642, 35837, 44030, 44031, 52226, 27652, 35846, 44039, 44040, 60423, 52234, 52235, 52238, 27663, 52244, 44053, 52247, 52250, 52254, 35871, 52255, 44065, 27683, 52260, 35880, 44072, 52266, 52268, 27697, 35895, 44087, 44088, 52284, 52285, 52286, 35903, 44096, 52297, 35917, 52302, 35921, 35926, 35937, 27746, 27747, 52322, 27749, 52330, 52333, 35950, 35951, 52334, 52339, 60533, 52342, 44153, 44169, 52366, 35986, 27795, 44181, 52377, 27803, 52379, 52380, 52382, 60573, 44199, 52397, 36018, 36019, 44210, 36025, 36026, 52410, 52414, 52417, 52418, 36038, 36039, 44230, 52425, 52427, 52429, 36047, 52432, 44243, 52435, 52438, 44254, 52447, 52450, 36068, 52452, 52458, 44267, 44268, 52464, 52468, 36093, 36094, 36095, 27905, 52481, 52483, 52484, 27911, 52488, 27926, 52504, 36121, 36122, 52511, 27944, 36137, 36138, 36141, 44333, 52534, 44345, 52539, 44350, 44356, 44359, 52551, 52552, 52556, 52557, 36176, 36178, 44372, 44376, 52571, 27998, 36190, 36191, 28001, 36192, 52574, 52579, 36198, 52582, 60775, 44393, 44394, 44396, 52595, 36213, 36218, 36220, 52606, 60806, 52618, 28044, 52620, 60816, 52646, 52647, 28075, 28076, 52654, 28080, 44474, 52670, 28096, 44480, 52672, 28099, 52673, 52676, 52677, 44492, 52685, 44494, 52686, 52694, 52695, 44507, 52701, 52702, 36319, 52706, 28132, 52708, 52716, 36334, 52721, 36344, 36345, 44551, 52743, 52759, 52761, 44570, 28190, 36388, 36389, 36397, 36401, 52787, 52789, 60996, 44617, 44618, 28239, 52818, 52822, 28247, 52826, 28253, 36445, 36446, 52829, 52839, 36463, 52850, 52856, 44665, 52857, 52864, 44679, 36491, 52879, 36499, 28310, 52898, 52909, 28337, 36530, 44723, 61116, 36542, 28360, 28361, 28364, 28365, 28366, 28367, 52947, 52953, 52965, 52966, 52977, 44787, 52982, 52986, 44796, 44799, 36616, 53000, 28432, 53009, 53015, 53016, 53020, 44831, 44832, 53031, 53033, 53037, 44846, 36659, 44851, 44854, 53049, 28477, 61249, 53058, 28484, 53061, 36678, 53063, 61272, 36698, 53084, 53088, 53103, 53106, 44917, 53109, 53118, 53124, 53131, 53133, 44948, 44970, 53169, 53171, 28596, 53180, 36798, 53192, 28623, 53199, 53200, 45015, 53207, 53212, 45021, 53214, 53215, 28655, 53233, 53234, 53235, 53238, 36870, 45064, 53259, 45068, 45069, 61453, 45076, 36886, 45083, 45091, 53294, 53306, 36925, 28739, 45131, 36940, 45133, 53326, 53327, 28761, 53349, 45160, 36969, 53354, 53364, 53366, 53372, 37000, 45193, 53384, 28813, 53393, 28821, 53400, 45218, 45233, 53427, 28852, 61624, 37054, 37055, 37056, 28881, 37074, 37075, 53459, 37084, 37086, 37087, 37097, 45290, 28909, 45319, 61705, 28941, 53524, 28949, 53525, 37145, 28954, 28968, 45357, 37168, 45360, 37177, 53575, 45392, 37202, 37206, 53602, 45413, 61811, 37236, 53620, 53621, 53622, 53626, 61821, 53643, 53644, 61839, 29076, 53653, 53660, 45474, 37283, 45477, 45480, 53685, 45496, 29123, 29124, 45508, 53701, 37325, 37326, 45517, 61908, 61913, 45535, 29156, 29157, 61931, 29168, 37366, 45565, 61949, 29186, 45570, 45574, 29195, 37393, 37407, 29217, 53800, 29246, 37439, 29252, 62026, 53836, 45646, 62033, 53845, 45659, 29277, 45663, 37476, 62057, 37495, 37501, 45693, 37512, 37527, 62106, 37535, 45728, 45735, 53928, 37548, 29367, 53946, 29373, 37567, 37585, 45777, 37594, 37598, 37602, 62181, 45801, 53996, 45810, 45816, 54010, 37627, 45819, 45824, 37646, 45846, 45853, 29470, 37669, 62254, 37693, 54079, 54080, 62274, 37707, 37709, 37714, 62302, 37737, 45930, 37741, 45933, 62326, 45955, 62345, 29589, 54165, 54170, 62364, 37800, 37801, 29610, 37802, 29612, 45997, 46000, 62385, 46007, 37819, 37828, 37829, 62405, 54217, 54218, 29644, 29645, 29646, 29649, 29650, 62417, 29652, 62421, 54234, 46044, 54241, 29674, 29680, 62448, 37879, 29710, 54287, 29713, 37905, 62484, 29727, 37920, 54315, 37934, 29749, 46145, 54344, 37963, 29775, 46173, 29795, 29808, 29810, 29811, 46199, 62584, 29834, 38028, 62606, 62607, 38056, 29865, 62636, 38064, 54453, 46278, 46279, 38096, 62694, 54504, 38121, 38122, 62709, 62715, 54527, 46337, 29959, 38152, 38155, 29982, 29988, 38182, 54569, 46381, 62766, 38192, 54580, 46395, 46397, 46401, 46406, 30023, 54599, 54607, 46416, 38226, 30036, 30037, 46420, 46423, 62809, 46427, 46428, 62815, 54624, 62816, 46434, 46435, 54627, 30053, 46440, 46441, 30058, 46447, 46448, 46452, 46457, 46458, 54653, 38270, 46463, 38272, 46467, 46468, 46473, 46476, 46479, 46480, 46485, 46486, 46488, 30107, 46492, 46498, 46513, 38329, 46521, 46527, 46531, 62917, 46535, 46539, 46541, 62925, 62945, 30184, 54761, 30192, 30202, 54778, 38400, 30212, 46599, 30216, 38408, 46610, 38422, 38425, 38426, 30240, 38440, 38441, 46632, 46636, 54835, 46644, 38462, 54859, 46669, 46681, 54879, 30308, 46698, 46702, 30325, 46709, 38527, 46722, 46724, 46728, 46733, 38545, 46741, 30372, 38567, 38568, 38569, 30386, 46779, 63164, 38589, 30423, 38622, 30441, 55028, 38648, 46841, 55038, 38655, 63254, 22301, 55072, 46882, 55076, 22316, 22326, 38711, 22329, 46909, 46910, 22336, 38720, 22339, 63301, 38728, 63304, 63308, 22350, 55118, 63312, 22354, 22355, 55122, 63314, 22360, 46936, 38751, 46943, 38755, 30568, 22377, 30574, 22383, 30577, 63347, 38773, 38775, 22392, 38781, 22404, 46981, 22406, 22407, 30602, 63372, 22415, 22416, 63378, 22420, 22430, 47009, 22436, 22438, 22439, 30639, 22454, 47030, 22456, 55225, 38851, 47045, 22472, 22474, 22475, 22485, 22488, 22489, 22499, 47077, 30696, 30697, 47085, 30703, 38897, 38900, 47093, 22525, 22540, 38927, 30743, 55327, 22561, 55333, 38953, 47146, 22571, 38955, 22577, 22581, 22584, 63544, 63545, 30779, 63546, 47165, 63547, 63548, 30788, 22602, 22603, 22604, 22607, 22609, 30801, 63573, 63574, 30807, 22618, 22619, 22621, 39006, 22625, 22631, 22646, 22648, 22653, 47231, 22659, 22664, 30857, 22670, 22675, 30867, 30868, 22678, 39061, 22682, 22685, 22686, 22688, 55461, 22694, 22696, 63660, 22701, 30894, 63664, 39091, 30905, 47294, 39103, 22726, 30924, 22740, 47317, 63702, 47319, 39129, 22746, 30939, 30942, 22756, 22757, 47333, 22766, 22767, 22778, 30970, 39164, 22781, 22784, 22785, 47366, 30984, 30985, 30989, 55576, 22815, 47392, 22833, 22839, 39224, 47415, 63802, 47423, 47424, 63808, 22854, 22858, 22859, 31074, 47462, 22887, 22888, 22889, 39274, 63846, 39280, 31090, 22904, 22908, 47484, 22922, 22925, 22927, 55695, 22948, 31140, 22952, 22954, 55724, 31149, 31153, 39353, 39354, 55738, 31169, 22984, 63947, 22994, 31189, 23007, 55776, 55777, 23010, 55778, 55779, 55781, 23014, 23015, 23016, 39398, 39399, 55782, 55783, 55784, 23030, 63992, 31225, 63994, 23036, 23037, 23038, 23040, 23041, 23042, 23043, 23044, 47617, 47628, 23055, 23063, 23064, 64029, 64033, 47652, 23077, 64038, 64041, 64043, 47660, 39470, 39471, 64046, 23089, 64050, 64054, 23096, 39481, 64058, 55867, 64061, 39490, 39491, 64068, 23118, 55888, 31315, 31316, 31317, 47704, 23134, 47710, 23137, 23138, 47715, 23145, 31343, 47730, 39540, 23159, 23160, 31353, 64122, 31360, 64133, 23188, 39573, 55957, 39575, 23192, 55958, 23194, 47770, 55960, 55961, 23198, 55963, 55964, 23201, 23202, 55966, 23210, 23211, 23212, 55979, 55982, 64177, 31412, 31413, 47801, 23235, 56008, 64201, 31436, 31437, 23246, 23247, 47834, 23262, 31454, 39648, 23269, 31466, 39659, 64237, 39662, 23279, 23280, 39666, 47861, 23287, 47877, 23306, 31500, 23309, 56078, 23312, 64275, 39700, 56086, 39704, 23325, 56094, 23327, 23329, 31521, 31522, 23332, 47910, 64294, 39720, 64299, 64300, 39728, 64305, 39731, 56115, 31542, 31543, 23355, 23358, 47935, 31552, 23363, 39749, 23373, 23374, 47950, 39760, 64336, 31574, 23386, 39783, 31593, 39788, 23405, 39791, 23410, 47987, 39797, 23415, 23417, 31612, 23421, 31617, 23426, 48002, 31620, 64385, 23430, 31626, 39828, 23445, 39832, 64409, 23450, 31644, 31645, 23455, 64415, 31650, 31651, 48035, 56226, 23465, 23466, 23479, 31671, 31672, 31676, 56254, 23488, 23489, 48064, 39875, 39877, 23499, 23500, 64460, 39886, 23503, 23504, 39895, 31704, 31705, 23526, 31719, 48103, 31735, 23546, 31752, 48137, 23571, 39958, 48158, 56352, 48167, 64551, 23597, 23602, 31795, 31796, 39997, 40001, 23618, 23627, 56397, 23631, 23632, 64592, 31827, 31835, 40033, 23653, 40037, 64617, 64622, 64628, 23669, 56442, 56444, 40073, 56459, 23697, 23698, 23699, 40084, 23701, 64661, 40087, 64668, 40095, 48287, 31908, 31909, 40102, 48298, 56492, 31917, 40110, 48301, 64695, 31929, 40125, 23747, 23752, 23755, 64717, 48334, 31951, 23760, 31959, 64735, 23779, 23780, 40165, 40166, 56549, 48362, 56556, 31987, 56573, 56574, 56575, 32008, 23817, 40201, 32015, 32019, 40211, 40215, 32036, 32037, 40237, 64814, 32061, 32062, 40258, 64834, 48453, 64839, 23885, 64847, 32080, 32083, 23892, 23908, 48484, 23913, 23914, 32105, 40299, 56684, 23920, 56688, 56690, 48502, 23931, 64899, 32132, 23947, 64912, 64917, 23961, 48542, 56734, 40354, 64934, 23976, 40361, 64937, 64939, 64945, 40370, 40371, 64947, 32181, 40378, 48573, 40383, 40385, 24004, 48581, 24011, 48587, 64971, 24025, 32223, 64994, 40419, 32230, 48614, 65003, 32238, 32241, 32243, 32247, 48632, 32253, 32257, 40451, 32260, 24070, 32264, 40456, 32266, 48649, 32270, 56847, 32272, 32275, 32278, 56856, 32282, 24092, 32284, 24094, 24095, 56863, 65057, 24099, 65059, 40508, 56894, 48705, 65089, 32324, 24133, 56903, 32329, 56908, 65100, 32335, 65106, 40540, 56930, 24172, 24173, 32367, 56951, 40571, 56957, 48767, 65152, 65155, 48775, 56967, 56968, 40586, 65169, 24210, 48792, 24219, 24220, 24221, 32416, 65187, 65191, 24237, 24238, 40627, 24247, 24248, 65212, 65213, 24258, 57027, 24262, 40646, 24265, 48843, 24268, 24269, 24270, 24271, 32460, 32463, 24284, 24285, 57060, 65252, 32486, 32493, 32499, 24313, 24314, 32507, 40701, 57097, 32522, 48906, 24337, 24338, 32530, 24343, 24352, 24356, 65318, 65319, 57131, 57133, 24367, 32563, 32564, 57141, 24383, 32577, 24389, 65360, 24401, 65361, 65362, 65363, 32597, 48991, 24417, 32614, 32615, 65384, 65387, 24430, 32623, 57198, 24439, 24440, 57207, 65401, 65402, 24445, 24456, 65419, 49036, 40846, 40851, 40852, 24469, 24470, 57248, 57254, 65449, 24490, 32683, 57260, 24493, 24494, 57263, 24496, 57266, 57267, 57270, 24503, 24504, 57273, 65462, 65463, 65472, 24514, 24515, 49093, 65478, 65483, 65484, 24526, 49106, 49107, 49108, 65490, 32728, 40920, 57304, 57305, 32735, 49119, 40931, 40932, 40933, 57316, 57320, 24554, 57323, 24561, 57339) and sss.IsDeleted =0;... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,712 - 12111 - src.utils.log - INFO - ✅ Fetched 4492 rows - __SPLIT__
2026-08-03 17:02:55,720 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT fm.YearlyOccurrence, fs.FrequencyScheduleId From ServiceCore.FrequencySchedule fs join
ServiceCore.FrequencyMaster fm on fs.FrequencyId = fm.FrequencyId where
fs.FrequencyScheduleId in (14448, 14451, 14452, 14453, 14454, 14459, 14460, 14461, 14462, 14466, 14467, 14468, 14469, 14472, 14473, 14474, 14475, 14476, 14479, 14480, 14481, 14482, 14483, 14486, 14487, 14488, 13982, 14495, 14496, 14497, 14494, 13987, 14500, 14501, 14502, 13985, 14505, 14532, 14533, 14534, 14535, 14536, 14537, 14538, 14539, 14540, 14542, 14543, 14544, 14545, 14546, 14548, 14549, 14550, 14551, 14552, 14553, 14554, 14556, 14557, 14558, 14559, 14560, 14561, 14562, 14563, 14564, 14565, 14566, 14567, 14568, 14570, 14571, 14572, 14573, 14574, 14576, 14577, 14578, 14579, 14580, 14581, 14582, 14584, 14585, 14586, 14587, 14588, 14589, 14590, 14591, 14592, 14593, 14594, 14595, 14597, 14598, 14599, 14600, 14601, 14602, 14604, 14605, 14606, 14607, 14608, 14609, 14611, 14612, 14613, 14614, 14627, 14632, 14633, 14634, 14635, 14636, 14637, 14638, 14641, 14642, 14643, 14644, 14645, 14646, 14647, 14648, 14649, 14650, 14653, 14654, 14655, 14656, 14657, 14660, 14661, 14662, 14663, 14664, 14667, 14668, 14669, 14670, 14671, 14674, 14682, 14685, 14197, 14208, 14728, 14729, 14733, 14734, 14735, 14736, 14249, 14252, 14272, 14819, 14832, 14329);... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,760 - 12111 - src.utils.log - INFO - ✅ Fetched 161 rows - __SPLIT__
2026-08-03 17:02:55,761 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT fm.YearlyOccurrence, fs.FrequencyScheduleId From ServiceCore.FrequencySchedule fs join
ServiceCore.FrequencyMaster fm on fs.FrequencyId = fm.FrequencyId where
fs.FrequencyScheduleId in (14342, 13962, 13966, 13978, 14622, 14623, 14624, 14625, 14503, 14504, 14506, 14507, 14508, 14509, 14510, 14511, 14512, 14513, 14514, 14515, 14516, 14517, 14518, 14519, 14520, 14521, 14522, 14523, 14524, 14525, 14526, 14527, 14528, 14529, 14530, 14531, 14806, 14807, 14808, 14809, 14810, 14811, 14812, 14813, 14814, 14815, 14816, 14817, 14683, 14693, 14827, 14828, 14829, 14830);... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,794 - 12111 - src.utils.log - INFO - ✅ Fetched 54 rows - __SPLIT__
2026-08-03 17:02:55,799 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT CompanyRoundingLevel ,CompanyRoundingMethod
FROM common.CompanyConfiguration cc WHERE CompanyId = 133... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:55,827 - 12111 - src.utils.log - INFO - ✅ Fetched 1 rows - __SPLIT__
2026-08-03 17:02:55,869 - 12111 - src.utils.log - INFO - 🔍 Fetching data: SELECT ServiceSetupId, DiscountSetupId,DiscountType,DiscountCode,DiscountAmount,DiscountDescription,DiscountName,
DiscountPercent, IsDiscountPercent,AppliedDiscountAmt,ApplyOnPartPrice,ApplyOnLaborPrice from
ServiceCore.ServiceSetupAppliedDiscount ssad WHERE IsInitialSetupDiscount = 0 AND ssad.ServiceSetupId in (65538, 40964, 57350, 24583, 65543, 65546, 65549, 40976, 65552, 49170, 65554, 65557, 24599, 57367, 65560, 65563, 24604, 49180, 24606, 40990, 57376, 24609, 32811, 57387, 41006, 41007, 49203, 65589, 24644, 24645, 24654, 32851, 32855, 57442, 49261, 24689, 65653, 24694, 24695, 57464, 32889, 24705, 24713, 65673, 24715, 41100, 65677, 32913, 32917, 24731, 24732, 24733, 41119, 65696, 24759, 57528, 65720, 57531, 24781, 24782, 65742, 24785, 32978, 32980, 32984, 24793, 49369, 32999, 41191, 41192, 65769, 65770, 33004, 65771, 65772, 65773, 65774, 65775, 65776, 41203, 41204, 65777, 65778, 57591, 33028, 24848, 24849, 24853, 65815, 41243, 24869, 49446, 33072, 33075, 57658, 24891, 24903, 41295, 24913, 24917, 65880, 49504, 41314, 65893, 49511, 41320, 33152, 24964, 65929, 24971, 24972, 24973, 24975, 33172, 65942, 57752, 24986, 33178, 24988, 24993, 65960, 25002, 65963, 65967, 65969, 33203, 33204, 65972, 65977, 65980, 33216, 41410, 65989, 49606, 65993, 65995, 41423, 66002, 33239, 41435, 49630, 33253, 33254, 66024, 49641, 41450, 41459, 49655, 41464, 41468, 33280, 33281, 33282, 25091, 66049, 57863, 33290, 41484, 25104, 41489, 33298, 25115, 25116, 25117, 49691, 41507, 49699, 25126, 49704, 57897, 33323, 49707, 41519, 49712, 33329, 57910, 57911, 49720, 57912, 66102, 49731, 49735, 25166, 49744, 49752, 49753, 57952, 41569, 49763, 57955, 49767, 49775, 66159, 49779, 25205, 49783, 66169, 49787, 41596, 49791, 25219, 41604, 41611, 49805, 33424, 49809, 33432, 49817, 41627, 66209, 41640, 25258, 58027, 25266, 33461, 33463, 41656, 41657, 58041, 25276, 33473, 33480, 25290, 25293, 25294, 25310, 49888, 49896, 33513, 25323, 49903, 58099, 41727, 49924, 25353, 41758, 41759, 41773, 33582, 49970, 33591, 41790, 41797, 41799, 49991, 49995, 66385, 50005, 50015, 41827, 25454, 25455, 50037, 41850, 50042, 50046, 66430, 25474, 50050, 33669, 41862, 41864, 41867, 41874, 41876, 66459, 25514, 25515, 25516, 41898, 41909, 50101, 41913, 50109, 25537, 25538, 58306, 25555, 25562, 25579, 41966, 58351, 25584, 41971, 50168, 41979, 50172, 41983, 50175, 58372, 41997, 66585, 42010, 25628, 25629, 25632, 50214, 33836, 33839, 33841, 66609, 25652, 66618, 42045, 50238, 42047, 42053, 42054, 33864, 66633, 42062, 33877, 42069, 42072, 58456, 42085, 42096, 33906, 50291, 33908, 42101, 42102, 50295, 33914, 50299, 50303, 33928, 50312, 33932, 33933, 25742, 42129, 50321, 66707, 33951, 33952, 50336, 42146, 50340, 42154, 33968, 66742, 42169, 42174, 50371, 34009, 34011, 66783, 34022, 34023, 34024, 66795, 50417, 25844, 66810, 25851, 34056, 50444, 25871, 25873, 25878, 42279, 42282, 50474, 42285, 50491, 50494, 50500, 34119, 50506, 50509, 66893, 25936, 50512, 50515, 66900, 34134, 50518, 34137, 42332, 50524, 50530, 50539, 66925, 50542, 66928, 50545, 25971, 50548, 25973, 25975, 50552, 50557, 50561, 25986, 50565, 34182, 42374, 50568, 42379, 34188, 50571, 34190, 42385, 58769, 50579, 50580, 42389, 50588, 50589, 42402, 50595, 26020, 42408, 34218, 34224, 50613, 34243, 42450, 26072, 34274, 34275, 26090, 58862, 42483, 26101, 34296, 42494, 67070, 67072, 42506, 50708, 67105, 42533, 42549, 67126, 42557, 34375, 50762, 26194, 26203, 50780, 42589, 58972, 42591, 42594, 34406, 50795, 42604, 58988, 42607, 42609, 34423, 34424, 34429, 50814, 50818, 50827, 26255, 26271, 67235, 26280, 26281, 34473, 59048, 34487, 50871, 50872, 34495, 42699, 50893, 42706, 42714, 26337, 26340, 34533, 34534, 34535, 59117, 67311, 42738, 67318, 50953, 34570, 26388, 67350, 34591, 26402, 67369, 50989, 34609, 34612, 42814, 59210, 34641, 42834, 51028, 51033, 67424, 42851, 42860, 26484, 34676, 51062, 42872, 59257, 34682, 34683, 42874, 59266, 34694, 34695, 59272, 59273, 59279, 26514, 59283, 26517, 34713, 51100, 42912, 34726, 42923, 26559, 34761, 42953, 51150, 51164, 67559, 34794, 34795, 34796, 67569, 59380, 67577, 67582, 26636, 34829, 51222, 43048, 51242, 67627, 26668, 43058, 67636, 67638, 26679, 67644, 26703, 34902, 34903, 26712, 34904, 51298, 59494, 59498, 26732, 34936, 26746, 51330, 43140, 59525, 51334, 34953, 51340, 43157, 43164, 43170, 43174, 26798, 34992, 34993, 35001, 67772, 67775, 67780, 51398, 35020, 43213, 43220, 59604, 67797, 59614, 51429, 26861, 26862, 51442, 26867, 26868, 43253, 51454, 26884, 59654, 35079, 67866, 43293, 51486, 43298, 51496, 26921, 26922, 67886, 51503, 43314, 51508, 51516, 43330, 26952, 67914, 43352, 43356, 26976, 35170, 59748, 67954, 43380, 67958, 51575, 51589, 27016, 27017, 43401, 51592, 51598, 35221, 35226, 51623, 51625, 68011, 43444, 68021, 35259, 68033, 27076, 51654, 51656, 43466, 43467, 51661, 51679, 27104, 51684, 68076, 51693, 51694, 68081, 35317, 68085, 68086, 51705, 43518, 35329, 35332, 51719, 51720, 68104, 51722, 43531, 51726, 27154, 51734, 43544, 51737, 51740, 68124, 51748, 27177, 27178, 43563, 43565, 51759, 59959, 35390, 51776, 51780, 35406, 43602, 43603, 43605, 51799, 59993, 51803, 35420, 51806, 43618, 27244, 68208, 43633, 35444, 43637, 51828, 68220, 27261, 27262, 51843, 51844, 60038, 51853, 35476, 60061, 35488, 43685, 51886, 68274, 51893, 68279, 51896, 60090, 51901, 51911, 51912, 51914, 27340, 35540, 27351, 51932, 27359, 27360, 51936, 51943, 43758, 51956, 35577, 51972, 51982, 35606, 43800, 51992, 51994, 68379, 52001, 27426, 52002, 60200, 43824, 52020, 52025, 68412, 52030, 68415, 52032, 68418, 52035, 27462, 35657, 27466, 52045, 43856, 52051, 52052, 52060, 52061, 52062, 43878, 35687, 35689, 35690, 52078, 68467, 68471, 52089, 52092, 52093, 35710, 35711, 27526, 52106, 68490, 27532, 68492, 60303, 68496, 27541, 35737, 35738, 68505, 52130, 60332, 60334, 60336, 27571, 60342, 43959, 52153, 35772, 52160, 52166, 60361, 43978, 35786, 27599, 52175, 43985, 60367, 60368, 60371, 60375, 35802, 68570, 68575, 52197, 52201, 35828, 35829, 52213, 27641, 27642, 35837, 44030, 44031, 52226, 27652, 35846, 44039, 44040, 60423, 52234, 52235, 52238, 27663, 52244, 44053, 52247, 52250, 52254, 35871, 52255, 44065, 27683, 52260, 35880, 44072, 52266, 52268, 27697, 35895, 44087, 44088, 52284, 52285, 52286, 35903, 44096, 52297, 35917, 52302, 35921, 35926, 35937, 27746, 27747, 52322, 27749, 52330, 52333, 35950, 35951, 52334, 52339, 60533, 52342, 44153, 44169, 52366, 35986, 27795, 44181, 52377, 27803, 52379, 52380, 52382, 60573, 44199, 52397, 36018, 36019, 44210, 36025, 36026, 52410, 52414, 52417, 52418, 36038, 36039, 44230, 52425, 52427, 52429, 36047, 52432, 44243, 52435, 52438, 44254, 52447, 52450, 36068, 52452, 52458, 44267, 44268, 52464, 52468, 36093, 36094, 36095, 27905, 52481, 52483, 52484, 27911, 52488, 27926, 52504, 36121, 36122, 52511, 27944, 36137, 36138, 36141, 44333, 52534, 44345, 52539, 44350, 44356, 44359, 52551, 52552, 52556, 52557, 36176, 36178, 44372, 44376, 52571, 27998, 36190, 36191, 28001, 36192, 52574, 52579, 36198, 52582, 60775, 44393, 44394, 44396, 52595, 36213, 36218, 36220, 52606, 60806, 52618, 28044, 52620, 60816, 52646, 52647, 28075, 28076, 52654, 28080, 44474, 52670, 28096, 44480, 52672, 28099, 52673, 52676, 52677, 44492, 52685, 44494, 52686, 52694, 52695, 44507, 52701, 52702, 36319, 52706, 28132, 52708, 52716, 36334, 52721, 36344, 36345, 44551, 52743, 52759, 52761, 44570, 28190, 36388, 36389, 36397, 36401, 52787, 52789, 60996, 44617, 44618, 28239, 52818, 52822, 28247, 52826, 28253, 36445, 36446, 52829, 52839, 36463, 52850, 52856, 44665, 52857, 52864, 44679, 36491, 52879, 36499, 28310, 52898, 52909, 28337, 36530, 44723, 61116, 36542, 28360, 28361, 28364, 28365, 28366, 28367, 52947, 52953, 52965, 52966, 52977, 44787, 52982, 52986, 44796, 44799, 36616, 53000, 28432, 53009, 53015, 53016, 53020, 44831, 44832, 53031, 53033, 53037, 44846, 36659, 44851, 44854, 53049, 28477, 61249, 53058, 28484, 53061, 36678, 53063, 61272, 36698, 53084, 53088, 53103, 53106, 44917, 53109, 53118, 53124, 53131, 53133, 44948, 44970, 53169, 53171, 28596, 53180, 36798, 53192, 28623, 53199, 53200, 45015, 53207, 53212, 45021, 53214, 53215, 28655, 53233, 53234, 53235, 53238, 36870, 45064, 53259, 45068, 45069, 61453, 45076, 36886, 45083, 45091, 53294, 53306, 36925, 28739, 45131, 36940, 45133, 53326, 53327, 28761, 53349, 45160, 36969, 53354, 53364, 53366, 53372, 37000, 45193, 53384, 28813, 53393, 28821, 53400, 45218, 45233, 53427, 28852, 61624, 37054, 37055, 37056, 28881, 37074, 37075, 53459, 37084, 37086, 37087, 37097, 45290, 28909, 45319, 61705, 28941, 53524, 28949, 53525, 37145, 28954, 28968, 45357, 37168, 45360, 37177, 53575, 45392, 37202, 37206, 53602, 45413, 61811, 37236, 53620, 53621, 53622, 53626, 61821, 53643, 53644, 61839, 29076, 53653, 53660, 45474, 37283, 45477, 45480, 53685, 45496, 29123, 29124, 45508, 53701, 37325, 37326, 45517, 61908, 61913, 45535, 29156, 29157, 61931, 29168, 37366, 45565, 61949, 29186, 45570, 45574, 29195, 37393, 37407, 29217, 53800, 29246, 37439, 29252, 62026, 53836, 45646, 62033, 53845, 45659, 29277, 45663, 37476, 62057, 37495, 37501, 45693, 37512, 37527, 62106, 37535, 45728, 45735, 53928, 37548, 29367, 53946, 29373, 37567, 37585, 45777, 37594, 37598, 37602, 62181, 45801, 53996, 45810, 45816, 54010, 37627, 45819, 45824, 37646, 45846, 45853, 29470, 37669, 62254, 37693, 54079, 54080, 62274, 37707, 37709, 37714, 62302, 37737, 45930, 37741, 45933, 62326, 45955, 62345, 29589, 54165, 54170, 62364, 37800, 37801, 29610, 37802, 29612, 45997, 46000, 62385, 46007, 37819, 37828, 37829, 62405, 54217, 54218, 29644, 29645, 29646, 29649, 29650, 62417, 29652, 62421, 54234, 46044, 54241, 29674, 29680, 62448, 37879, 29710, 54287, 29713, 37905, 62484, 29727, 37920, 54315, 37934, 29749, 46145, 54344, 37963, 29775, 46173, 29795, 29808, 29810, 29811, 46199, 62584, 29834, 38028, 62606, 62607, 38056, 29865, 62636, 38064, 54453, 46278, 46279, 38096, 62694, 54504, 38121, 38122, 62709, 62715, 54527, 46337, 29959, 38152, 38155, 29982, 29988, 38182, 54569, 46381, 62766, 38192, 54580, 46395, 46397, 46401, 46406, 30023, 54599, 54607, 46416, 38226, 30036, 30037, 46420, 46423, 62809, 46427, 46428, 62815, 54624, 62816, 46434, 46435, 54627, 30053, 46440, 46441, 30058, 46447, 46448, 46452, 46457, 46458, 54653, 38270, 46463, 38272, 46467, 46468, 46473, 46476, 46479, 46480, 46485, 46486, 46488, 30107, 46492, 46498, 46513, 38329, 46521, 46527, 46531, 62917, 46535, 46539, 46541, 62925, 62945, 30184, 54761, 30192, 30202, 54778, 38400, 30212, 46599, 30216, 38408, 46610, 38422, 38425, 38426, 30240, 38440, 38441, 46632, 46636, 54835, 46644, 38462, 54859, 46669, 46681, 54879, 30308, 46698, 46702, 30325, 46709, 38527, 46722, 46724, 46728, 46733, 38545, 46741, 30372, 38567, 38568, 38569, 30386, 46779, 63164, 38589, 30423, 38622, 30441, 55028, 38648, 46841, 55038, 38655, 63254, 22301, 55072, 46882, 55076, 22316, 22326, 38711, 22329, 46909, 46910, 22336, 38720, 22339, 63301, 38728, 63304, 63308, 22350, 55118, 63312, 22354, 22355, 55122, 63314, 22360, 46936, 38751, 46943, 38755, 30568, 22377, 30574, 22383, 30577, 63347, 38773, 38775, 22392, 38781, 22404, 46981, 22406, 22407, 30602, 63372, 22415, 22416, 63378, 22420, 22430, 47009, 22436, 22438, 22439, 30639, 22454, 47030, 22456, 55225, 38851, 47045, 22472, 22474, 22475, 22485, 22488, 22489, 22499, 47077, 30696, 30697, 47085, 30703, 38897, 38900, 47093, 22525, 22540, 38927, 30743, 55327, 22561, 55333, 38953, 47146, 22571, 38955, 22577, 22581, 22584, 63544, 63545, 30779, 63546, 47165, 63547, 63548, 30788, 22602, 22603, 22604, 22607, 22609, 30801, 63573, 63574, 30807, 22618, 22619, 22621, 39006, 22625, 22631, 22646, 22648, 22653, 47231, 22659, 22664, 30857, 22670, 22675, 30867, 30868, 22678, 39061, 22682, 22685, 22686, 22688, 55461, 22694, 22696, 63660, 22701, 30894, 63664, 39091, 30905, 47294, 39103, 22726, 30924, 22740, 47317, 63702, 47319, 39129, 22746, 30939, 30942, 22756, 22757, 47333, 22766, 22767, 22778, 30970, 39164, 22781, 22784, 22785, 47366, 30984, 30985, 30989, 55576, 22815, 47392, 22833, 22839, 39224, 47415, 63802, 47423, 47424, 63808, 22854, 22858, 22859, 31074, 47462, 22887, 22888, 22889, 39274, 63846, 39280, 31090, 22904, 22908, 47484, 22922, 22925, 22927, 55695, 22948, 31140, 22952, 22954, 55724, 31149, 31153, 39353, 39354, 55738, 31169, 22984, 63947, 22994, 31189, 23007, 55776, 55777, 23010, 55778, 55779, 55781, 23014, 23015, 23016, 39398, 39399, 55782, 55783, 55784, 23030, 63992, 31225, 63994, 23036, 23037, 23038, 23040, 23041, 23042, 23043, 23044, 47617, 47628, 23055, 23063, 23064, 64029, 64033, 47652, 23077, 64038, 64041, 64043, 47660, 39470, 39471, 64046, 23089, 64050, 64054, 23096, 39481, 64058, 55867, 64061, 39490, 39491, 64068, 23118, 55888, 31315, 31316, 31317, 47704, 23134, 47710, 23137, 23138, 47715, 23145, 31343, 47730, 39540, 23159, 23160, 31353, 64122, 31360, 64133, 23188, 39573, 55957, 39575, 23192, 55958, 23194, 47770, 55960, 55961, 23198, 55963, 55964, 23201, 23202, 55966, 23210, 23211, 23212, 55979, 55982, 64177, 31412, 31413, 47801, 23235, 56008, 64201, 31436, 31437, 23246, 23247, 47834, 23262, 31454, 39648, 23269, 31466, 39659, 64237, 39662, 23279, 23280, 39666, 47861, 23287, 47877, 23306, 31500, 23309, 56078, 23312, 64275, 39700, 56086, 39704, 23325, 56094, 23327, 23329, 31521, 31522, 23332, 47910, 64294, 39720, 64299, 64300, 39728, 64305, 39731, 56115, 31542, 31543, 23355, 23358, 47935, 31552, 23363, 39749, 23373, 23374, 47950, 39760, 64336, 31574, 23386, 39783, 31593, 39788, 23405, 39791, 23410, 47987, 39797, 23415, 23417, 31612, 23421, 31617, 23426, 48002, 31620, 64385, 23430, 31626, 39828, 23445, 39832, 64409, 23450, 31644, 31645, 23455, 64415, 31650, 31651, 48035, 56226, 23465, 23466, 23479, 31671, 31672, 31676, 56254, 23488, 23489, 48064, 39875, 39877, 23499, 23500, 64460, 39886, 23503, 23504, 39895, 31704, 31705, 23526, 31719, 48103, 31735, 23546, 31752, 48137, 23571, 39958, 48158, 56352, 48167, 64551, 23597, 23602, 31795, 31796, 39997, 40001, 23618, 23627, 56397, 23631, 23632, 64592, 31827, 31835, 40033, 23653, 40037, 64617, 64622, 64628, 23669, 56442, 56444, 40073, 56459, 23697, 23698, 23699, 40084, 23701, 64661, 40087, 64668, 40095, 48287, 31908, 31909, 40102, 48298, 56492, 31917, 40110, 48301, 64695, 31929, 40125, 23747, 23752, 23755, 64717, 48334, 31951, 23760, 31959, 64735, 23779, 23780, 40165, 40166, 56549, 48362, 56556, 31987, 56573, 56574, 56575, 32008, 23817, 40201, 32015, 32019, 40211, 40215, 32036, 32037, 40237, 64814, 32061, 32062, 40258, 64834, 48453, 64839, 23885, 64847, 32080, 32083, 23892, 23908, 48484, 23913, 23914, 32105, 40299, 56684, 23920, 56688, 56690, 48502, 23931, 64899, 32132, 23947, 64912, 64917, 23961, 48542, 56734, 40354, 64934, 23976, 40361, 64937, 64939, 64945, 40370, 40371, 64947, 32181, 40378, 48573, 40383, 40385, 24004, 48581, 24011, 48587, 64971, 24025, 32223, 64994, 40419, 32230, 48614, 65003, 32238, 32241, 32243, 32247, 48632, 32253, 32257, 40451, 32260, 24070, 32264, 40456, 32266, 48649, 32270, 56847, 32272, 32275, 32278, 56856, 32282, 24092, 32284, 24094, 24095, 56863, 65057, 24099, 65059, 40508, 56894, 48705, 65089, 32324, 24133, 56903, 32329, 56908, 65100, 32335, 65106, 40540, 56930, 24172, 24173, 32367, 56951, 40571, 56957, 48767, 65152, 65155, 48775, 56967, 56968, 40586, 65169, 24210, 48792, 24219, 24220, 24221, 32416, 65187, 65191, 24237, 24238, 40627, 24247, 24248, 65212, 65213, 24258, 57027, 24262, 40646, 24265, 48843, 24268, 24269, 24270, 24271, 32460, 32463, 24284, 24285, 57060, 65252, 32486, 32493, 32499, 24313, 24314, 32507, 40701, 57097, 32522, 48906, 24337, 24338, 32530, 24343, 24352, 24356, 65318, 65319, 57131, 57133, 24367, 32563, 32564, 57141, 24383, 32577, 24389, 65360, 24401, 65361, 65362, 65363, 32597, 48991, 24417, 32614, 32615, 65384, 65387, 24430, 32623, 57198, 24439, 24440, 57207, 65401, 65402, 24445, 24456, 65419, 49036, 40846, 40851, 40852, 24469, 24470, 57248, 57254, 65449, 24490, 32683, 57260, 24493, 24494, 57263, 24496, 57266, 57267, 57270, 24503, 24504, 57273, 65462, 65463, 65472, 24514, 24515, 49093, 65478, 65483, 65484, 24526, 49106, 49107, 49108, 65490, 32728, 40920, 57304, 57305, 32735, 49119, 40931, 40932, 40933, 57316, 57320, 24554, 57323, 24561, 57339);... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:56,047 - 12111 - src.utils.log - INFO - ✅ Fetched 1245 rows - __SPLIT__
2026-08-03 17:02:56,054 - 12111 - src.utils.log - INFO - 📥 Empty dataframe of Billing.InvoiceAutoGenerationAppliedDiscount: - __SPLIT__
2026-08-03 17:02:56,054 - 12111 - src.utils.log - INFO - Checking if all rows exist in parent table or not - __SPLIT__
2026-08-03 17:02:56,054 - 12111 - src.utils.log - INFO - 📥 Inserting into Billing.InvoiceChargesAutoGeneration: 9 rows in batches of 25000 (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:56,105 - 12111 - src.utils.log - INFO - 📤 Inserting batch 1/1 (0 to 9) into Billing.InvoiceChargesAutoGeneration - __SPLIT__
2026-08-03 17:02:56,235 - 12111 - src.utils.log - INFO - ✅ All 9 rows inserted successfully into Billing.InvoiceChargesAutoGeneration in 1 batches - __SPLIT__
2026-08-03 17:02:56,236 - 12111 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
SET Status = 'Completed' WHERE GenerateInvoiceHistoryId = 12111;... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:56,310 - 12111 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-08-03 17:02:56,310 - 12111 - src.utils.log - INFO - 📝 Executing: UPDATE ServiceCore.GenerateInvoiceHistory
SET InvoiceStatusDateTime = '2026-08-03 13:02:56.310' WHERE GenerateInvoiceHistoryId = 12111;... (Thread: AnyIO worker thread) - __SPLIT__
2026-08-03 17:02:56,384 - 12111 - src.utils.log - INFO - ✅ Command executed successfully - __SPLIT__
2026-08-03 17:02:56,385 - 12111 - src.utils.log - INFO - 🔒 Connection pool closed - __SPLIT__
2026-08-03 17:02:56,385 - 12111 - src.utils.log - INFO - Sequential Invoice Gen Complete Successfully ProjectId:12111 - Time took: 16.02 - __SPLIT__