How to fix Error "A truncation error was encountered trying to shrink VARCHAR"?

[Deleted User]

Hi,

I ran into "A truncation error was encountered trying to shrink VARCHAR" error when I try to create XES file. Here is the full message.

2011-12-02 17:15:36: (PROGRESS) Starting step 21 of 22: Extracting Event: Unsatisfiable Dep.

2011-12-02 17:15:36: (DEBUG) We are about to run the following query to detect the traceID type: SELECT change_id FROM change_messages WHERE change_id LIKE '123456ABCDEFG'

2011-12-02 17:15:36: (DEBUG) We are about to run the following query to extract the items for Event: Unsatisfiable Dep:

SELECT change_id AS traceID, written_on AS orderAttribute, 'Merge Error' AS concept_name, 'Complete' AS lifecycle_transition, 'Automatic process' AS org_group, 'Gerrit' AS org_resource, 'Verifier' AS org_role, change_messages.written_on AS time_timestamp, change_messages.message AS message FROM change_messages WHERE message LIKE '%merged due to unsatisfiable dependencies%' AND (change_id IN (20439, 22529, 23658, 20436, 22528, 20435, 23659, 22527, 22526, 20438, 20437, 22525, 22524, 23654, 20432, 25797, 23655, 25798, 22523, 20431, 20434, 23656, 22522, 25795, 23657, 25796, 20433, 22521, 23650, 22520, 23651, 20430, 25799, 23652, 23653, 25790, 25794, 25793, 25792, 25791, 22519, 22518, 23649, 22515, 20449, 20448, 22514, 20447, 23647, 22517, 22516, 23648, 20446, 22511, 20445, 25784, 23645, 23646, 20444, 22510, 25785, 22513, 23643, 25786, 20443, 20442, 25787, 22512, 23644, 20441, 23641, 25788, 25789, 23642, 20440, 23640, 25781, 25780, 25783, 25782, 23636, 22506, 20458, 22505, 23637, 20457, 22504, 23638, 23639, 22503, 20459, 22509, 22508, 22507, 20450, 25779, 23630, 25777, 20452, 20451, 25778, 23631, 23632, 22502, 25775, 20454, 25776, 22501, 20453, 23633, 25773, 22500, 23634, 20456, 20455, 23635, 25774, 25772, 25771, 25770, 23627, 23628, 20469, 23625, 23626, 20468, 23629, 20463, 25766, 20462, 25767, 23620, 20461, 25768, 20460, 25769, 23623, 25762, 20467, 20466, 23624, 25763, 25764, 23621, 20465, 23622, 20464, 25765, 25761, 25760, 23699, 23698, 23695, 23694, 23697, 23696, 23690, 23691, 23692, 23693, 20400, 20401, 23689, 23688, 23687, 23686, 23685, 23684, 23683, 20408, 20409, 20406, 20407, 20404, 20405, 20402, 20403, 23681, 23682, 23680, 23673, 23672, 23675, 23674, 23677, 23676, 20410, 23679, 20411, 20412, 23678, 20413, 20414, 20415, 20416, 20417, 20418, 20419, 23670, 23671, 23664, 23663, 23662, 23661, 23668, 20422, 20423, 23667, 20420, 23666, 20421, 23665, 20426, 20427, 20424, 23669, 20425, 20428, 20429, 23660, 21073, 21072, 21075, 21074, 21071, 21070, 21968, 21969, 21964, 21965, 21966, 21967, 21960, 21961, 21962, 21963, 21076, 21077, 21078, 21079, 21064, 22592, 22593, 21063, 21062, 22590, 21061, 22591, 21060, 21979, 21977, 21978, 21975, 21976, 21973, 21974) OR change_id IN (22599, 21069, 21971, 21972, 22598, 21067, 22597, 21970, 21068, 22596, 21065, 22595, 21066, 22594, 25089, 25088, 25087, 25086, 21051, 25085, 21050, 22580, 21053, 22581, 25084, 25083, 21052, 22582, 25082, 25081, 25080, 21986, 21987, 21988, 21989, 22584, 21054, 22583, 21055, 21056, 21980, 22586, 21981, 21057, 22585, 21058, 21982, 22588, 21059, 22587, 21983, 21984, 21985, 22589, 25099, 25098, 25095, 22570, 21042, 25094, 22571, 21041, 25097, 21040, 25096, 25091, 25090, 25093, 25092, 21999, 21997, 21998, 21991, 21045, 22575, 22574, 21992, 21046, 22573, 21043, 21990, 22572, 21044, 22579, 21995, 21049, 21996, 22578, 22577, 21993, 21047, 21048, 21994, 22576, 20470, 22560, 20477, 23613, 22565, 22566, 23612, 20478, 20475, 22567, 23611, 22568, 20476, 23610, 22561, 20473, 22562, 20474, 20471, 22563, 20472, 22564, 23619, 23618, 23617, 22569, 23616, 20479, 23615, 23614, 24690, 20481, 20480, 24692, 24691, 24694, 24693, 24695, 20486, 23600, 22556, 20487, 22557, 24696, 22554, 24697, 20488, 23602, 24698, 23601, 20489, 22555, 24699, 22552, 20482, 20483, 22553, 20484, 22550, 20485, 22551, 23608, 23607, 23609, 23604, 23603, 23606, 22558, 22559, 23605, 21090, 24683, 24682, 21091, 24681, 21092, 24680, 21093, 21094, 20492, 20491, 21095, 20490, 21096, 21097, 20495, 21099, 22540, 20496, 21098, 22541, 24688, 20493, 20494, 22542, 24689, 22543, 24686, 20499, 22544, 24687, 22545, 20497, 24684, 20498, 22546, 24685, 22547, 22548, 22549, 24670, 21081, 21082, 24672, 21080, 24671, 21085, 21086, 21083, 21084, 24677, 22530, 24678, 22531, 21089, 21088, 24679, 21087, 24673, 22534, 22535, 24674, 24675, 22532, 22533, 24676, 22538, 22539, 22536, 22537, 21106, 21107, 21108, 21109, 24779, 24778, 21100, 24777, 24776, 21101, 25038, 24775, 21102, 21103, 24774, 25039, 24773, 25036, 21104, 24772, 21105, 25037) OR change_id IN (25035, 24770, 25034, 24771, 25033, 25032, 25031, 25030, 21119, 21117, 21118, 21111, 25029, 24788, 24787, 21112, 24789, 21110, 21115, 25025, 24784, 24783, 25026, 21116, 25027, 21113, 24786, 21114, 24785, 25028, 25022, 24780, 25021, 25024, 24781, 24782, 25023, 25020, 21913, 21914, 24759, 21915, 24758, 21916, 21910, 21911, 21912, 25016, 24753, 24752, 25017, 25014, 24751, 24750, 25015, 24757, 24756, 24755, 25018, 25019, 24754, 25013, 25012, 25011, 25010, 21907, 21906, 21909, 21908, 21904, 21905, 24769, 21902, 21903, 21900, 21901, 24762, 25003, 24761, 25004, 25005, 24764, 24763, 25006, 25007, 24766, 24765, 25008, 25009, 24768, 24767, 25000, 25002, 25001, 24760, 24734, 21143, 24735, 21142, 24732, 21145, 24733, 21144, 21147, 24730, 24731, 21146, 21930, 21149, 21148, 21932, 21931, 21934, 21933, 21936, 24738, 24739, 21935, 24736, 21938, 24737, 21937, 25070, 21928, 25071, 21929, 25078, 25079, 25076, 25077, 25074, 25075, 25072, 21140, 21141, 25073, 24743, 21156, 21155, 24744, 24745, 21154, 21153, 24746, 25069, 21159, 24740, 24741, 21158, 24742, 21157, 21923, 21922, 21921, 21920, 24747, 21927, 24748, 21926, 24749, 21925, 21924, 21919, 21917, 21918, 25060, 25065, 25066, 25067, 25068, 21151, 25061, 25062, 21152, 25063, 25064, 21150, 22499, 21950, 21125, 21124, 25059, 21952, 21127, 21126, 21951, 25058, 24712, 22495, 21121, 24713, 22496, 21120, 21123, 24710, 22497, 24711, 22498, 21122, 21958, 24716, 21957, 24717, 24714, 21959, 24715, 21954, 21129, 21128, 21953, 24718, 21956, 21955, 24719, 22492, 25052, 25053, 22491, 25050, 22494, 22493, 25051, 25056, 25057, 22490, 25054, 25055, 21138, 25048, 21941, 25047, 21940, 21137, 21136, 25049, 21135, 24720, 21134, 24721, 24722, 21133, 24723, 21132, 21131, 24724, 24725, 21949, 21948, 24726, 21947, 24727, 21946, 24728, 24729, 21945, 21944) OR change_id IN (21943, 21942, 21139, 21939, 25040, 21130, 25041, 25042, 25043, 25044, 25045, 25046, 25829, 25827, 25828, 25825, 25826, 25823, 25824, 25821, 25822, 25820, 24709, 24708, 24707, 24706, 25836, 25837, 24705, 24704, 25838, 25839, 24703, 24702, 25832, 25833, 24701, 25834, 24700, 25835, 25830, 25831, 23581, 23580, 23583, 23582, 25805, 25806, 25803, 25804, 25809, 25807, 25808, 23588, 23589, 25801, 23584, 25802, 23585, 23586, 25800, 23587, 23594, 23593, 23592, 23591, 23590, 25814, 25815, 25816, 25817, 25818, 25819, 23599, 25810, 23597, 23598, 25811, 23595, 25812, 25813, 23596, 25860, 25868, 25867, 25866, 25865, 25864, 25863, 25862, 25861, 25869, 25870, 25871, 25877, 25876, 25879, 25878, 25873, 25872, 25875, 25874, 25842, 25841, 25840, 25846, 25845, 25844, 25843, 25849, 25848, 25847, 25851, 25850, 25853, 25852, 25855, 25854, 25857, 25856, 25859, 25858, 20571, 25658, 25659, 24079, 20570, 25656, 20573, 20572, 23510, 25657, 23511, 25654, 20575, 25655, 20574, 23512, 25652, 23513, 20577, 20576, 25653, 23514, 23515, 20579, 20578, 23516, 23517, 23518, 23519, 24070, 25651, 24071, 24072, 25650, 24073, 24074, 24075, 24076, 24077, 24078, 20584, 25645, 20583, 25646, 25647, 20582, 25648, 20581, 23502, 25641, 20588, 25642, 20587, 23503, 25643, 20586, 23500, 23501, 20585, 25644, 23506, 23507, 23504, 20589, 23505, 25649, 23508, 23509, 24080, 24081, 24084, 24085, 24082, 25640, 24083, 24088, 24089, 20580, 24086, 24087, 25676, 20553, 23533, 22403, 25677, 22402, 20552, 23534, 20555, 23535, 25674, 22401, 23536, 25675, 22400, 20554, 23530, 23531, 20551, 25678, 20550, 23532, 25679, 22409, 22408, 23537, 22407, 20557, 23538, 22406, 20556, 22405, 20559, 23539, 22404, 20558, 24090, 24091, 24092, 24097, 24098, 24099, 24093, 25673, 25672, 24094, 24095, 25671, 25670, 24096, 25663, 20566, 23524, 23525) OR change_id IN (20565, 25664, 25665, 23522, 20564, 23523, 20563, 25666, 25667, 23520, 20562, 25668, 20561, 23521, 25669, 20560, 23528, 20569, 23529, 20568, 23526, 23527, 20567, 25660, 25662, 25661, 20534, 23559, 20535, 20536, 20537, 20538, 20539, 23552, 24035, 24036, 23551, 24037, 23554, 24038, 23553, 24039, 20530, 23556, 25699, 25698, 23555, 20531, 23558, 20532, 25697, 20533, 25696, 23557, 25694, 25695, 24030, 25692, 25693, 24032, 25690, 24031, 25691, 24034, 24033, 23550, 20547, 20548, 23549, 20545, 23548, 20546, 20549, 24048, 23543, 24049, 25689, 20540, 23542, 23541, 24046, 23540, 24047, 20543, 23547, 25686, 25685, 20544, 23546, 25688, 23545, 20541, 23544, 25687, 20542, 24041, 25681, 25682, 24040, 25683, 25684, 24045, 24044, 24043, 25680, 24042, 20516, 20517, 20518, 20519, 20512, 20513, 20514, 20515, 23578, 23577, 20510, 23579, 20511, 23574, 24057, 23573, 24058, 23576, 24059, 23575, 24054, 24053, 23570, 24056, 23571, 24055, 23572, 24050, 24052, 24051, 20509, 20529, 20527, 20528, 20525, 20526, 20523, 20524, 23569, 20521, 23568, 20522, 23567, 23566, 20520, 23565, 23564, 24068, 23563, 24069, 23562, 24067, 23560, 24066, 23561, 24065, 24064, 24063, 24062, 24061, 24060, 21170, 21172, 21171, 21174, 22460, 22461, 21173, 21175, 22463, 22462, 21176, 22465, 21177, 21178, 22464, 21179, 22467, 22466, 22469, 22468, 24592, 24593, 24594, 24595, 21163, 21162, 22450, 21161, 24590, 24000, 24001, 24591, 21160, 21166, 22454, 24003, 24002, 22453, 21167, 21164, 22452, 24005, 21165, 22451, 24004, 24007, 22458, 24597, 22457, 24596, 24006, 21168, 24599, 22456, 24009, 24598, 22455, 21169, 24008, 22459, 24011, 21194, 22480, 21193, 22481, 24012, 22482, 21196, 22483, 24010, 21195, 21190, 21192, 21191, 22489, 24019, 22488, 24018, 24017, 24016, 22485, 21197, 24015, 22484, 21198, 21199, 24014, 22487, 24013) OR change_id IN (22486, 22471, 21185, 24020, 22472, 24021, 21184, 21183, 24022, 21182, 24023, 22470, 21181, 21180, 24029, 22479, 24028, 22478, 22477, 22476, 21188, 24025, 21189, 24024, 22475, 22474, 21186, 24027, 24026, 21187, 22473, 24562, 24561, 24560, 22426, 22427, 22428, 22429, 24569, 22420, 24567, 24568, 22421, 24565, 22422, 22423, 24566, 22424, 24563, 24564, 22425, 24551, 24550, 22417, 22418, 22415, 22416, 22419, 24556, 24557, 22410, 24558, 24559, 24552, 22413, 22414, 24553, 24554, 22411, 24555, 22412, 20591, 24580, 20590, 24584, 24583, 24582, 24581, 22448, 22449, 22444, 24587, 20598, 20599, 24588, 22445, 20596, 24585, 22446, 22447, 20597, 24586, 22440, 20594, 20595, 22441, 20592, 24589, 22442, 20593, 22443, 24571, 24570, 24573, 24572, 22439, 22437, 22438, 22435, 24574, 22436, 24575, 24576, 22433, 24577, 22434, 22431, 24578, 22432, 24579, 22430, 21201, 25137, 24632, 24631, 25138, 21202, 21203, 25135, 24630, 25136, 21204, 24636, 24635, 25139, 24634, 24633, 21200, 21209, 24639, 24638, 24637, 21205, 21206, 21207, 21208, 25130, 25134, 25133, 25132, 25131, 25124, 24641, 21214, 21215, 24640, 25125, 24643, 21212, 25126, 24642, 21213, 25127, 21210, 25128, 24645, 24644, 25129, 21211, 24647, 24646, 24649, 24648, 21218, 21219, 21216, 21217, 25121, 25120, 25123, 25122, 24658, 24657, 21220, 24656, 21221, 21222, 24655, 24654, 21223, 25159, 24653, 21224, 25157, 24652, 21225, 24651, 25158, 21226, 21227, 21228, 21229, 24659, 25156, 25155, 24650, 25154, 25153, 25152, 25151, 25150, 24667, 21232, 24666, 21233, 24669, 21230, 24668, 21231, 21236, 25146, 24663, 25147, 21237, 24662, 21234, 24665, 25148, 25149, 24664, 21235, 21238, 21239, 25143, 25142, 25145, 24660, 25144, 24661, 25141, 25140, 21249, 22378, 21246, 22379, 21245, 21248, 21247, 25179, 21242, 22374, 21241, 22375, 22376, 21244, 22377) OR change_id IN (21243, 25173, 22371, 22370, 25174, 25171, 22373, 25172, 21240, 22372, 25177, 25178, 25175, 25176, 25170, 24604, 24605, 24606, 24607, 24608, 24609, 21259, 25169, 21258, 25168, 21257, 22389, 21256, 24600, 21255, 22387, 21254, 24601, 22388, 24602, 21253, 22385, 22386, 21252, 24603, 21250, 25160, 22384, 22383, 25161, 21251, 22382, 25162, 25163, 22381, 25164, 22380, 25165, 25166, 25167, 24619, 24617, 24618, 24615, 24616, 22396, 24613, 21264, 21263, 22397, 24614, 21266, 24611, 22398, 22399, 21265, 24612, 21268, 21267, 24610, 21269, 25199, 22391, 25197, 25198, 22390, 25195, 22393, 21260, 25196, 22392, 25193, 21261, 22395, 22394, 25194, 21262, 25191, 25192, 25190, 24626, 24627, 24628, 24629, 21277, 24622, 21276, 24623, 21275, 24624, 21274, 24625, 24620, 21279, 21278, 24621, 25186, 25187, 25188, 25189, 25182, 21272, 25183, 21273, 25184, 21270, 25185, 21271, 25180, 25181, 23460, 23462, 23461, 23467, 23468, 23469, 20500, 23463, 23464, 23465, 23466, 20506, 20505, 20508, 20507, 20502, 20501, 20504, 20503, 23473, 23472, 23471, 23470, 23478, 23479, 23476, 23477, 23474, 23475, 23480, 23482, 23481, 23484, 23483, 25702, 23485, 23486, 25703, 25700, 23487, 23488, 25701, 23489, 25708, 25709, 25706, 25707, 25704, 25705, 23491, 23490, 23495, 23494, 23493, 23492, 25711, 23498, 23499, 25712, 23496, 25713, 25714, 23497, 25710, 25719, 25715, 25716, 25717, 25718, 25729, 25728, 25727, 25726, 25721, 25720, 25725, 25724, 25723, 25722, 25738, 25737, 25739, 25730, 25732, 25731, 25734, 25733, 25736, 25735, 25110, 25111, 25112, 25749, 25748, 25747, 25118, 25117, 25746, 25745, 25119, 25744, 25743, 25114, 25742, 25113, 25741, 25116, 25740, 25115, 25100, 25101, 25750, 25759, 25756, 25109, 25108, 25755, 25107, 25758, 25757, 25106, 25752, 25105, 25751, 25104, 25754, 25103, 25102, 25753, 24175, 24174) OR change_id IN (24177, 24176, 24171, 24170, 24173, 24172, 20630, 20631, 20632, 24178, 24179, 20637, 20638, 20639, 20633, 20634, 20635, 20636, 24180, 24188, 24187, 24186, 24185, 24184, 24183, 24182, 24181, 20642, 20643, 20640, 20641, 24189, 20648, 20649, 20646, 20647, 20644, 20645, 24151, 24150, 24153, 24152, 24155, 24154, 24156, 24157, 24158, 20650, 24159, 20651, 20652, 20653, 20654, 20655, 20656, 20657, 20658, 20659, 24162, 24161, 24160, 24166, 24165, 24164, 24163, 20660, 24169, 20661, 24167, 24168, 20664, 20665, 20662, 20663, 20668, 20669, 20666, 20667, 23891, 23890, 20678, 20677, 20679, 23896, 20674, 23897, 20673, 23898, 20676, 20675, 23899, 23892, 20670, 23893, 23894, 20672, 23895, 20671, 23880, 23889, 20689, 20688, 20687, 23887, 20686, 23888, 20685, 23885, 20684, 23886, 23883, 20683, 23884, 20682, 23881, 20681, 23882, 20680, 24192, 24193, 24194, 24195, 24196, 24197, 24198, 24199, 20690, 24190, 24191, 23878, 20699, 23879, 23870, 20692, 20691, 23871, 23872, 20694, 20693, 23873, 23874, 20696, 20695, 23875, 23876, 20698, 23877, 20697, 23869, 23867, 23868, 23861, 23862, 23860, 23865, 23866, 23863, 23864, 21763, 24466, 23855, 22323, 22324, 21762, 24467, 23854, 22325, 23853, 24464, 21765, 23852, 21764, 24465, 22326, 23851, 23850, 22320, 21761, 22321, 24468, 21760, 22322, 24469, 23859, 22327, 21767, 23858, 22328, 21766, 23857, 22329, 21769, 21768, 23856, 24463, 24462, 24461, 24460, 24453, 21776, 22314, 24105, 23842, 24106, 21775, 24454, 23841, 22315, 24107, 21774, 24455, 22312, 23844, 24108, 21773, 24456, 22313, 23843, 24101, 24457, 22310, 21772, 24102, 22311, 21771, 24458, 23840, 21770, 24459, 24103, 24104, 23849, 24109, 23846, 22318, 23845, 21779, 22319, 23848, 22316, 21778, 22317, 23847, 21777, 24100, 24450, 24452, 24451, 21781, 24448, 21780, 24449, 21783, 24446, 24447, 21782) OR change_id IN (22300, 22301, 23833, 21785, 24444, 21784, 24445, 22302, 23832, 22303, 21787, 23831, 24442, 22304, 21786, 23830, 24443, 21789, 22305, 23837, 22306, 21788, 23836, 22307, 23835, 22308, 23834, 22309, 23839, 23838, 24441, 24440, 24435, 21794, 24436, 21793, 21792, 24437, 21791, 24438, 24431, 21798, 23820, 21797, 24432, 23822, 24433, 21796, 21795, 24434, 23821, 23824, 23823, 23826, 23825, 21799, 23828, 24439, 23827, 23829, 24430, 21790, 23818, 21726, 21727, 23819, 23816, 21728, 23817, 21729, 23814, 21722, 21723, 23815, 21724, 23812, 23813, 21725, 22368, 23810, 22367, 23811, 24139, 21720, 24138, 22369, 21721, 22364, 24137, 22363, 24136, 22366, 24135, 24134, 22365, 24132, 24133, 22360, 24130, 22361, 22362, 24131, 21719, 23809, 21739, 23805, 23806, 21737, 23807, 23808, 21738, 21735, 23801, 21736, 23802, 21733, 23803, 23804, 21734, 22359, 21731, 24498, 22358, 24497, 21732, 24149, 22357, 24499, 21730, 22356, 23800, 22355, 24146, 22354, 24145, 24148, 22353, 24147, 22352, 24141, 22350, 22351, 24490, 24142, 24143, 24491, 24492, 24144, 24493, 24494, 24495, 24140, 24496, 21744, 22349, 21745, 21746, 21747, 21748, 21749, 22342, 24115, 24114, 22341, 24113, 22344, 24112, 22343, 24489, 21740, 22346, 24119, 22345, 24488, 21741, 24118, 22348, 24487, 21742, 24117, 24486, 24116, 22347, 21743, 24484, 24485, 24482, 24483, 24480, 24110, 24481, 24111, 22340, 21757, 21758, 22339, 21755, 22338, 21756, 21759, 24124, 22333, 24123, 22332, 21750, 24479, 24126, 22331, 24125, 22330, 21753, 24128, 24476, 22337, 22336, 24475, 24127, 21754, 22335, 21751, 24478, 21752, 24129, 24477, 22334, 24471, 24472, 24473, 24474, 24120, 24121, 24470, 24122, 22270, 22272, 22271, 22274, 22273, 22275, 22276, 22277, 22278, 22279, 22281, 22280, 22285, 22284, 22283, 22282, 22288, 24501, 24502, 22289, 22286, 24503, 24504) OR change_id IN (22287, 24500, 24509, 24505, 24506, 24507, 24508, 21708, 21709, 22250, 22252, 22251, 22257, 22258, 22259, 21710, 22253, 22254, 22255, 22256, 21716, 21715, 21718, 21717, 21712, 21711, 21714, 21713, 22263, 22262, 22261, 22260, 22268, 22269, 22266, 22267, 22264, 22265, 21707, 21706, 21705, 21704, 21703, 21702, 21701, 21700, 24539, 24538, 24537, 24536, 24535, 24534, 24533, 24532, 24531, 24530, 24540, 24549, 24546, 24545, 24548, 24547, 24542, 24541, 24544, 24543, 22293, 22294, 22295, 22296, 22290, 22291, 22292, 24519, 24518, 24517, 24516, 24511, 24510, 24515, 22298, 24514, 22297, 24513, 24512, 22299, 24528, 24527, 24529, 24520, 24522, 24521, 24524, 24523, 24526, 24525, 20601, 20600, 20603, 20602, 20605, 20604, 20607, 20606, 20627, 20626, 20629, 20628, 20623, 20622, 20625, 20624, 20621, 20620, 20619, 20618, 20617, 20616, 20615, 20614, 20613, 20612, 20611, 20610, 20608, 20609, 24270, 24272, 24271, 24274, 24273, 23790, 24276, 23791, 24275, 23792, 20776, 20777, 20778, 20779, 24277, 23794, 23793, 24278, 23796, 24279, 20770, 23795, 20771, 20772, 23798, 20773, 23797, 20774, 20775, 23799, 24397, 24283, 24282, 24396, 24395, 24281, 24394, 24280, 23780, 24393, 24287, 24286, 24392, 23781, 24285, 24391, 24390, 24284, 20789, 20787, 20788, 23785, 20781, 23784, 20782, 23783, 24288, 20780, 23782, 24289, 20785, 23789, 20786, 23788, 24398, 20783, 23787, 23786, 24399, 20784, 24296, 24295, 24298, 24297, 24292, 24291, 24294, 24293, 24290, 20758, 20759, 20754, 20755, 20756, 20757, 20750, 20751, 20752, 20753, 24299, 20769, 20767, 20768, 20765, 20766, 20763, 20764, 20761, 20762, 20760, 25893, 25892, 25891, 25890, 23750, 23751, 25898, 23752, 23753, 25896, 23754, 25897, 23755, 25894, 23756, 25895, 23757, 23758, 23759, 25880, 25882, 25881, 25887, 23740, 23741, 25888, 25889, 23744, 25883, 25884) OR change_id IN (23745, 25885, 23742, 25886, 23743, 23748, 23749, 23746, 23747, 23770, 20795, 23775, 23776, 20794, 23777, 20797, 20796, 23778, 20791, 23771, 23772, 20790, 23773, 20793, 20792, 23774, 23779, 20799, 20798, 23766, 23767, 23764, 23765, 23762, 23763, 23760, 23761, 23768, 23769, 23716, 23715, 23714, 23713, 23719, 23718, 24329, 23717, 24327, 24328, 24325, 24326, 24323, 23712, 23711, 24324, 24321, 23710, 24322, 24320, 23703, 24208, 23702, 24209, 23705, 23704, 23707, 24318, 23706, 24319, 23709, 23708, 24200, 24314, 24315, 24201, 24202, 24316, 24317, 24203, 24204, 24310, 24205, 24311, 23701, 24312, 24206, 23700, 24313, 24207, 23739, 23738, 22206, 21888, 21887, 23737, 22207, 24219, 23736, 22208, 22209, 23735, 21889, 23734, 24217, 22202, 21884, 24345, 22203, 23733, 21883, 24218, 24346, 22204, 21886, 24343, 24215, 23732, 24216, 23731, 24344, 22205, 21885, 24213, 23730, 21880, 24349, 24214, 22200, 21882, 24211, 24347, 22201, 24212, 24348, 21881, 24210, 24342, 24341, 24340, 23729, 23728, 23725, 23724, 21899, 23727, 21898, 23726, 24332, 24226, 23721, 21897, 21896, 24333, 24227, 23720, 21895, 24228, 24334, 23723, 24335, 23722, 24229, 21894, 21893, 24222, 24336, 24337, 24223, 21892, 21891, 24338, 24224, 21890, 24339, 24225, 24221, 24220, 24331, 24330, 22221, 24236, 24235, 22220, 22223, 24234, 21860, 24369, 22222, 24233, 21861, 22225, 24368, 24367, 24239, 21862, 22224, 24238, 21863, 24366, 22227, 21864, 24365, 24237, 22226, 22229, 21865, 22228, 21866, 21867, 21868, 21869, 24363, 24364, 24361, 24362, 24231, 24360, 24232, 24230, 24245, 24359, 22212, 21870, 24358, 22211, 24244, 21871, 24247, 22210, 24246, 21874, 24355, 22216, 24249, 21875, 22215, 24354, 24248, 24357, 22214, 21872, 24356, 22213, 21873, 21878, 22219, 21879, 21876, 22218, 21877, 22217, 24350, 24351, 24352, 24353, 24240) OR change_id IN (24241, 24242, 24243, 22247, 21840, 24389, 22246, 24388, 21841, 22249, 24259, 24387, 22248, 21842, 22243, 24258, 22242, 24257, 24256, 22245, 22244, 24255, 21847, 21848, 21849, 21843, 21844, 21845, 21846, 24381, 24253, 24254, 24382, 22240, 24251, 22241, 24380, 24252, 24385, 24386, 24250, 24383, 24384, 22238, 21852, 24377, 22237, 21853, 24376, 21850, 22236, 24379, 24378, 22235, 21851, 22234, 24267, 24266, 22233, 24269, 22232, 22231, 24268, 21858, 21859, 21856, 21857, 21854, 22239, 21855, 24262, 22230, 24263, 24264, 24370, 24265, 24371, 24372, 24373, 24374, 24260, 24375, 24261, 22131, 22130, 21829, 21837, 21836, 21839, 21838, 21008, 21833, 21007, 21832, 21835, 21009, 21834, 21004, 22136, 22137, 21003, 22138, 21831, 21006, 21005, 21830, 22139, 21000, 22132, 22133, 22134, 21002, 21001, 22135, 22142, 22141, 22140, 21818, 21819, 21828, 21827, 21826, 21825, 21824, 21823, 21019, 21822, 21821, 21018, 21820, 22149, 21017, 21016, 22147, 21015, 22148, 21014, 21013, 22145, 22146, 21012, 21011, 22143, 22144, 21010, 22151, 22150, 22153, 22152, 21020, 21807, 21808, 21809, 21811, 21029, 21810, 21813, 21812, 21815, 21814, 21817, 21816, 22154, 21022, 22155, 21021, 21024, 22156, 22157, 21023, 22158, 21026, 21025, 22159, 21028, 21027, 22160, 22164, 21030, 22163, 21031, 22162, 22161, 21802, 21801, 21800, 21806, 21805, 21804, 21803, 22167, 21035, 22168, 21034, 21033, 22165, 21032, 22166, 21039, 21038, 21037, 22169, 21036, 22172, 22173, 22174, 22175, 22170, 22171, 22177, 22176, 22179, 22178, 22185, 22186, 22183, 22184, 22181, 22182, 22180, 24401, 24400, 24403, 24402, 22189, 24405, 22188, 22187, 24404, 24407, 24406, 24409, 24408, 22190, 22191, 22192, 22193, 22194, 22195, 22196, 22197, 24416, 22199, 24302, 24301, 22198, 24415, 24300, 24414, 24413, 24306, 24412, 24305, 24411, 24410, 24304) OR change_id IN (24303, 24309, 24308, 24307, 24419, 24418, 24417, 24425, 24424, 24427, 24426, 24421, 24420, 24423, 24422, 24429, 24428, 20703, 20704, 20705, 20706, 20700, 20701, 20702, 20740, 20742, 20741, 20748, 20747, 20749, 20744, 20743, 20746, 20745, 20731, 20730, 20739, 20738, 20737, 20736, 20735, 20734, 20733, 20732, 20729, 20720, 20722, 20721, 20724, 20723, 20726, 20725, 20728, 20727, 20718, 20719, 20713, 20712, 20711, 20710, 20717, 20716, 20715, 20714, 20709, 20707, 20708, 20909, 20905, 20906, 20907, 20908, 20913, 22905, 22906, 20912, 20915, 22903, 20914, 22904, 22901, 22902, 20911, 22118, 22119, 22900, 20910, 22116, 22117, 22114, 22115, 22112, 22113, 22110, 22111, 22120, 20918, 20919, 20916, 20917, 20926, 20925, 20924, 20923, 22129, 20922, 20921, 20920, 22125, 22126, 22127, 22128, 22121, 22122, 22123, 22124, 20927, 20928, 20929, 22919, 22918, 20931, 22923, 21516, 20930, 22924, 21515, 20933, 21514, 22921, 22922, 21513, 20932, 22927, 20935, 20934, 22928, 21519, 21518, 22925, 20937, 22926, 20936, 21517, 21512, 21511, 22920, 21510, 22908, 22907, 20938, 20939, 22909, 22107, 22910, 20944, 21503, 22911, 22108, 21502, 20943, 22912, 21505, 22109, 20942, 21504, 20941, 22913, 21507, 22914, 20948, 20947, 22915, 21506, 22916, 21509, 20946, 20945, 22917, 21508, 22100, 22101, 22102, 22103, 20940, 22104, 21501, 22105, 21500, 22106, 20949, 21533, 21534, 21531, 20950, 20951, 21532, 21530, 20956, 20957, 20958, 21539, 20959, 21537, 20952, 21538, 20953, 21535, 20954, 20955, 21536, 20961, 21520, 20962, 21521, 21522, 20960, 21523, 20969, 21528, 21529, 20967, 20968, 21524, 20965, 20966, 21525, 21526, 20963, 20964, 21527, 21551, 21552, 21550, 20970, 21555, 21556, 20971, 21553, 20972, 20973, 21554, 20974, 21559, 20975, 20976, 21557, 20977, 21558, 20978, 20979, 20980, 21540, 21541, 20983, 21542) OR change_id IN (21543, 20984, 21544, 20981, 21545, 20982, 21546, 20987, 20988, 21547, 21548, 20985, 20986, 21549, 20989, 21579, 21576, 21575, 21578, 21577, 21572, 21571, 21574, 21573, 21570, 21569, 21568, 21567, 21566, 21565, 21564, 21563, 21562, 21561, 21560, 21594, 21593, 21596, 21595, 21598, 21597, 21599, 21590, 21591, 21592, 21585, 21584, 21583, 21582, 21589, 21588, 21587, 21586, 21580, 21581, 23205, 25511, 25512, 23206, 23203, 23204, 25510, 23201, 25515, 23202, 25516, 25513, 25514, 23200, 25519, 25517, 25518, 23209, 23207, 23208, 23214, 23215, 23216, 25500, 23217, 25501, 25502, 23210, 25503, 23211, 25504, 23212, 25505, 23213, 25506, 25507, 25508, 25509, 23218, 23219, 20900, 20901, 20902, 20903, 20904, 25420, 23131, 23132, 23130, 25429, 25428, 23136, 25427, 23135, 25426, 23134, 25425, 23133, 25424, 25423, 23139, 23138, 25422, 23137, 25421, 25430, 25431, 23120, 23121, 23123, 25437, 23122, 25436, 23125, 25439, 23124, 25438, 25433, 23127, 23126, 25432, 25435, 23129, 25434, 23128, 23110, 25409, 25408, 25407, 23119, 25402, 23118, 25401, 23117, 25400, 23116, 23115, 23114, 25406, 23113, 25405, 25404, 23112, 23111, 25403, 25419, 25418, 23109, 23108, 25411, 23105, 23104, 25410, 23107, 25413, 25412, 23106, 25415, 23101, 23100, 25414, 25417, 23103, 25416, 23102, 25464, 23172, 23171, 25463, 25462, 23170, 25461, 23176, 25460, 23175, 23174, 23173, 23179, 23177, 25469, 23178, 25467, 25468, 25465, 25466, 25473, 25472, 23161, 25475, 23160, 25474, 23163, 23162, 23165, 25471, 25470, 23164, 23166, 23167, 23168, 23169, 25476, 25477, 25478, 25479, 23154, 23153, 23152, 23151, 23150, 25442, 25441, 25440, 25445, 25446, 25443, 23159, 25444, 23157, 25449, 23158, 23155, 25447, 25448, 23156, 22090, 23141, 22097, 22098, 23140, 23143, 22095, 23142, 22096, 25451, 22093, 22094, 25450, 22091, 25453, 25452) OR change_id IN (22092, 25454, 23148, 25455, 23149, 25456, 25457, 25458, 23144, 23145, 25459, 23146, 23147, 22099, 22978, 22979, 22976, 22977, 22970, 22971, 22088, 22089, 22974, 22975, 22972, 22973, 22083, 22082, 22081, 22080, 22087, 22086, 22085, 22084, 22987, 20999, 22988, 20998, 20997, 22989, 20996, 22077, 20991, 20990, 22078, 22980, 22981, 22079, 22982, 22983, 20995, 20994, 22984, 20993, 22985, 20992, 22986, 22070, 22072, 22071, 22074, 22073, 22076, 22075, 22998, 22999, 22996, 25488, 25487, 22997, 22994, 22995, 25489, 22992, 22068, 22993, 23199, 22069, 22066, 22990, 22067, 22991, 22065, 23195, 22064, 25480, 23196, 23197, 25481, 22063, 25482, 23198, 22062, 25483, 23191, 22061, 22060, 25484, 23192, 25485, 23193, 23194, 25486, 23190, 22059, 25499, 25498, 22055, 22056, 22057, 23189, 23188, 22058, 25492, 22052, 23186, 25493, 22051, 23187, 22054, 23184, 25490, 23185, 22053, 25491, 25496, 23182, 25497, 23183, 25494, 22050, 23180, 25495, 23181, 22047, 22046, 22045, 22044, 22931, 22930, 22049, 22048, 22935, 22934, 22933, 22932, 22939, 22938, 22937, 22936, 22929, 22042, 22043, 22040, 22041, 22034, 22033, 22036, 22035, 22940, 22038, 22037, 22942, 22039, 22941, 22944, 22943, 22946, 22945, 22948, 22947, 22949, 22030, 22031, 22032, 22953, 22029, 22952, 22028, 22027, 22951, 22026, 22950, 22025, 22024, 22023, 22022, 22959, 22958, 22957, 22956, 22955, 22954, 22020, 22021, 22016, 22962, 22015, 22961, 22018, 22964, 22017, 22963, 22012, 22011, 22960, 22014, 22013, 22969, 22966, 22019, 22965, 22968, 22967, 22010, 20806, 20807, 20808, 20809, 20180, 20182, 20181, 20184, 20183, 20185, 20186, 20187, 20188, 20189, 21633, 21632, 21631, 21630, 20810, 22802, 21637, 22803, 21636, 22800, 21635, 20812, 22801, 20811, 21634, 20814, 22806, 20813, 22807, 20816, 21639, 22804, 21638, 20815, 22805, 20819, 20817) OR change_id IN (20818, 20173, 20172, 20171, 20170, 20176, 20177, 20174, 20175, 21620, 21622, 20178, 20179, 21621, 20823, 21624, 20822, 21623, 21626, 20821, 21625, 20820, 21628, 20827, 20826, 21627, 20825, 21629, 20824, 21609, 20160, 20162, 20161, 21611, 20167, 21610, 20168, 20169, 20163, 20164, 20165, 20166, 21619, 21618, 21617, 21616, 21615, 21614, 21613, 21612, 20151, 20150, 20158, 22004, 22005, 20159, 20156, 22006, 21600, 22007, 20157, 20154, 22000, 20155, 22001, 20152, 22002, 22003, 20153, 20805, 21606, 21605, 20804, 21608, 20803, 20802, 21607, 21602, 22008, 20801, 22009, 21601, 20800, 21604, 21603, 20140, 20853, 20854, 20149, 21678, 20855, 20856, 21679, 20857, 20858, 20859, 21672, 20142, 20141, 21673, 21670, 20144, 20143, 21671, 21676, 20146, 20850, 21677, 20145, 21674, 20851, 20148, 21675, 20147, 20852, 21667, 20866, 21668, 20867, 20139, 21669, 20864, 20865, 20138, 20868, 20869, 20133, 20132, 21660, 20131, 21661, 21662, 20130, 20137, 21663, 20862, 21664, 20863, 20136, 21665, 20135, 20860, 20134, 21666, 20861, 20829, 20828, 20835, 20836, 20837, 20838, 20831, 21658, 20128, 20832, 20127, 21659, 20833, 21656, 21657, 20834, 20129, 20124, 21654, 21655, 20123, 21652, 20126, 20125, 20830, 21653, 21650, 20120, 21651, 20122, 20121, 20839, 21649, 20848, 20849, 20846, 20847, 20119, 20844, 21645, 21646, 20845, 20118, 20117, 21647, 20842, 21648, 20116, 20843, 21641, 20115, 20840, 21642, 20841, 20114, 21643, 20113, 21644, 20112, 20111, 20110, 21640, 20107, 20108, 20109, 21697, 21696, 21699, 21698, 21693, 21692, 21695, 21694, 21690, 21691, 21688, 21687, 21686, 21685, 21684, 21683, 21682, 21681, 21689, 21680, 25618, 25619, 25616, 25617, 25614, 25615, 25612, 25613, 25610, 25611, 25609, 25605, 25606, 25607, 25608, 25601, 25602, 25603, 25604, 25600, 25638, 25639, 25632, 25633, 25630, 25631) OR change_id IN (25636, 25637, 25634, 25635, 25627, 25628, 25629, 25620, 25621, 25622, 25623, 25624, 25625, 25626, 23919, 25523, 23921, 23920, 25522, 25521, 25520, 25527, 25526, 25525, 25524, 23929, 23928, 25529, 23927, 25528, 23926, 23925, 23924, 23923, 23922, 25530, 25532, 23930, 25531, 23932, 25534, 23931, 25533, 25536, 25535, 25538, 25537, 23938, 25539, 23937, 23939, 23934, 23933, 23936, 23935, 25540, 25541, 23010, 23011, 23015, 25549, 25548, 23014, 23013, 25547, 25546, 23012, 23019, 25545, 23018, 25544, 25543, 23017, 25542, 23016, 23903, 23902, 23901, 23900, 23907, 23906, 23905, 23904, 23908, 23909, 25550, 25551, 25552, 23000, 23002, 25558, 25557, 23001, 23004, 25559, 23003, 23006, 25554, 23005, 25553, 23910, 23008, 25556, 23007, 25555, 23912, 23911, 23009, 23914, 23913, 23916, 23915, 23918, 23917, 23033, 23032, 23031, 23030, 25563, 25562, 25561, 25560, 23968, 23969, 23966, 23967, 23964, 25566, 25567, 23965, 23962, 25564, 23038, 23039, 23963, 25565, 23960, 23036, 23961, 23037, 23034, 25568, 23035, 25569, 23020, 25570, 23022, 23021, 25572, 25571, 25574, 25573, 23977, 23978, 23979, 25575, 23973, 23027, 25576, 23974, 23028, 23029, 25577, 23975, 23976, 25578, 25579, 23023, 23024, 23970, 23971, 23025, 23026, 23972, 23051, 25585, 23050, 25584, 25583, 25582, 25581, 23055, 25580, 23054, 23053, 23052, 22890, 23946, 23947, 22899, 23944, 23945, 23948, 23949, 22892, 23058, 22891, 23059, 22894, 23056, 23057, 22893, 25588, 22896, 23942, 22895, 25589, 23943, 25586, 22898, 23940, 25587, 23941, 22897, 25594, 25593, 23040, 25596, 25595, 23042, 25590, 23041, 23044, 25592, 25591, 23043, 23955, 23956, 23957, 23958, 23959, 23045, 23046, 23047, 23950, 23048, 25597, 23049, 23951, 23952, 25598, 25599, 23953, 23954, 22875, 22876, 22873, 22874, 23079, 22871, 22872, 23078, 22870, 22879, 22877, 22878) OR change_id IN (23074, 23075, 23076, 23077, 23070, 23071, 23072, 23073, 22884, 20896, 22885, 20895, 22886, 20894, 22887, 20893, 22880, 20892, 20891, 22881, 23069, 23068, 20890, 22882, 22883, 23067, 22888, 22889, 20899, 20898, 20897, 23065, 23066, 23063, 23064, 23061, 23062, 23060, 23981, 22850, 23980, 23983, 20881, 23982, 20880, 20883, 23985, 22853, 20882, 23984, 22854, 22851, 20885, 23987, 23986, 22852, 20884, 20887, 22857, 23989, 22858, 23988, 20886, 22855, 20889, 22856, 20888, 22859, 23090, 23091, 23092, 23093, 23094, 23095, 23096, 23097, 23098, 23099, 23994, 20870, 23993, 22860, 23992, 22861, 23991, 23089, 20874, 23998, 22862, 20873, 22863, 23997, 23996, 22864, 20872, 23995, 22865, 20871, 22866, 20878, 22867, 20877, 20876, 22868, 20875, 22869, 23999, 20879, 23080, 23083, 23084, 23081, 23082, 23087, 23990, 23088, 23085, 23086, 22839, 22838, 22837, 22836, 22835, 22834, 22833, 22832, 22831, 22830, 22849, 22848, 22845, 22844, 22847, 22846, 22841, 22840, 22843, 22842, 22814, 22813, 22812, 22811, 22818, 22817, 22816, 22815, 22810, 22808, 22809, 22823, 22822, 22825, 22824, 22827, 22826, 22829, 22828, 22821, 22820, 22819, 20245, 20244, 20247, 20246, 20241, 20240, 20243, 20242, 20249, 20248, 20236, 20235, 20234, 20233, 20232, 20231, 20230, 20239, 20238, 20237, 20263, 21310, 20262, 20265, 20264, 20267, 21313, 21314, 20266, 21311, 20269, 20268, 21312, 21317, 21318, 21315, 21316, 21319, 20260, 20261, 20254, 20253, 20252, 20251, 20258, 21300, 21301, 20257, 21302, 20256, 21303, 20255, 21304, 21305, 21306, 20259, 21307, 21308, 21309, 20250, 20288, 20289, 20284, 20285, 20286, 20287, 20281, 20280, 20283, 20282, 20279, 20277, 20278, 20275, 20276, 20273, 20274, 20272, 20271, 20270, 20297, 20298, 20295, 20296, 20299, 20290, 20294, 20293, 20292, 20291, 21370, 23440, 21372, 21371, 23447, 21377) OR change_id IN (21378, 23448, 21379, 23445, 23446, 21373, 23443, 23444, 21374, 21375, 23441, 21376, 23442, 23449, 21361, 21360, 23451, 23450, 23456, 21368, 21369, 23457, 23458, 21366, 23459, 21367, 23452, 21364, 21365, 23453, 23454, 21362, 21363, 23455, 21390, 21392, 21391, 21394, 21393, 23421, 21395, 23422, 21396, 21397, 23420, 21398, 21399, 23425, 23426, 23423, 23424, 23429, 23427, 23428, 21383, 21382, 21381, 21380, 21386, 23430, 21387, 23431, 23432, 21384, 21385, 23433, 23434, 23435, 23436, 21388, 23437, 21389, 23438, 23439, 20208, 20209, 23409, 20206, 23408, 21338, 23407, 20207, 21337, 23406, 20204, 21339, 20205, 23405, 20202, 23404, 21334, 20203, 21333, 23403, 23402, 21336, 20200, 21335, 23401, 20201, 23400, 21330, 21332, 21331, 21329, 23417, 23416, 21328, 21327, 23419, 21326, 23418, 23413, 21325, 23412, 21324, 23415, 21323, 23414, 21322, 21321, 21320, 23411, 23410, 21350, 20228, 20229, 21359, 20226, 20227, 21352, 20220, 21351, 20221, 21354, 21353, 21356, 20224, 20225, 21355, 20222, 21358, 20223, 21357, 20215, 20216, 21349, 20217, 20218, 21348, 20219, 21343, 21342, 21341, 21340, 20210, 20211, 21347, 20212, 21346, 20213, 21345, 21344, 20214, 25229, 22771, 24900, 22770, 22773, 25227, 22772, 25228, 25225, 22775, 25226, 22774, 22777, 25223, 22776, 25224, 24908, 22779, 24907, 22778, 24906, 24905, 24904, 24903, 24902, 24901, 25222, 25221, 25220, 25238, 22784, 25239, 22783, 22782, 22781, 25234, 22788, 25235, 22787, 22786, 25236, 22785, 25237, 22789, 25231, 25230, 25233, 25232, 22780, 25203, 22797, 22796, 25204, 25201, 22799, 22798, 25202, 22793, 25207, 23399, 22792, 25208, 22795, 25205, 23397, 22794, 23398, 25206, 25209, 23396, 23395, 23394, 22790, 23393, 22791, 25200, 23392, 23391, 23390, 25212, 25213, 25214, 25215, 23386, 25216, 25217, 23387, 25218, 23388, 25219, 23389, 23383) OR change_id IN (23382, 23385, 23384, 23381, 25211, 25210, 23380, 24949, 24947, 24948, 24945, 24946, 24943, 23378, 21286, 24944, 21285, 23377, 23376, 21288, 24941, 24942, 23375, 21287, 21289, 24940, 23379, 23370, 21280, 21281, 23373, 23374, 21282, 21283, 23371, 23372, 21284, 24938, 24939, 24934, 24935, 24936, 24937, 21299, 23365, 24930, 24931, 21298, 23364, 21297, 24932, 23367, 21296, 23366, 24933, 23369, 23368, 21290, 21291, 23360, 21294, 23361, 21295, 21292, 23362, 23363, 21293, 24925, 24926, 24923, 24924, 24929, 24927, 24928, 23359, 23358, 23357, 24921, 23356, 23355, 24922, 23354, 24920, 23353, 23351, 23352, 23350, 24912, 24913, 24914, 24915, 24916, 24917, 24918, 24919, 23347, 23346, 23349, 23348, 23343, 23342, 23345, 24910, 24911, 23344, 23340, 23341, 24909, 20190, 20191, 24980, 20192, 20193, 20194, 20195, 24986, 20197, 20196, 24985, 20199, 24988, 24987, 20198, 24982, 24981, 24984, 24983, 24989, 24977, 24976, 24975, 24974, 24973, 24972, 22700, 24971, 24970, 22702, 22701, 22704, 22703, 22706, 22705, 24979, 22708, 22707, 24978, 22709, 25280, 25282, 25281, 25284, 25283, 25286, 25285, 25288, 25287, 22711, 25289, 24960, 22710, 24962, 24961, 24964, 24963, 24966, 24965, 22719, 24968, 24967, 22718, 22717, 22716, 24969, 22715, 22714, 22713, 22712, 25291, 25290, 25295, 25294, 25293, 25292, 25299, 25298, 25297, 25296, 24951, 22720, 24950, 22722, 22721, 24955, 24954, 24953, 24952, 24959, 22728, 22727, 24958, 24957, 24956, 22729, 22724, 22723, 22726, 22725, 25263, 25264, 25265, 25266, 25260, 25261, 25262, 22736, 22737, 22734, 22735, 22738, 22739, 22732, 25268, 25267, 22733, 22730, 25269, 22731, 25276, 25277, 25274, 25275, 25272, 25273, 25270, 25271, 22745, 22746, 22747, 22748, 22749, 22740, 22741, 22742, 22743, 25279, 22744, 25278, 25240, 25241, 25242, 25243, 25244, 22758, 22759, 22756) OR change_id IN (22757, 25246, 22754, 25245, 22755, 25248, 22752, 25247, 22753, 22750, 25249, 22751, 25250, 25251, 24991, 25254, 25255, 24990, 25252, 25253, 22767, 22768, 22769, 25259, 22763, 24994, 24995, 22764, 25258, 25257, 24992, 22765, 22766, 25256, 24993, 24998, 24999, 22760, 24996, 22761, 24997, 22762, 21438, 21439, 21436, 21437, 24799, 20384, 21430, 21431, 24798, 20383, 20386, 20385, 24795, 21434, 20388, 20387, 24794, 21435, 21432, 24797, 20389, 21433, 24796, 24790, 24791, 24792, 24793, 20380, 20381, 20382, 21425, 21426, 21427, 21428, 21429, 20375, 20374, 20373, 20372, 21420, 21421, 20379, 21422, 20378, 20377, 21423, 20376, 21424, 20370, 20371, 21418, 21419, 21416, 21417, 20369, 21414, 21415, 20366, 21412, 21413, 20365, 20368, 21410, 21411, 20367, 20362, 20361, 20364, 20363, 20360, 21407, 21408, 21409, 21403, 21404, 21405, 20359, 20358, 21406, 20357, 20356, 21400, 21401, 20355, 20354, 21402, 20353, 20352, 20351, 20350, 20398, 20399, 20396, 20397, 20394, 20395, 20393, 20392, 20391, 20390, 20306, 23308, 23309, 20305, 23306, 20304, 23307, 20303, 20309, 20308, 20307, 23300, 23301, 20302, 23304, 23305, 20301, 20300, 23302, 23303, 23317, 23318, 23319, 23310, 23311, 23312, 23313, 23314, 23315, 23316, 21491, 21490, 21493, 21492, 23328, 23329, 21498, 23326, 23327, 21499, 23324, 23325, 21494, 23322, 23323, 21495, 21496, 23320, 23321, 21497, 21482, 21481, 23330, 21480, 23339, 21489, 23335, 23336, 21487, 23337, 21488, 23338, 23331, 21485, 21486, 23332, 23333, 21483, 23334, 21484, 21470, 21471, 21473, 20341, 21472, 20342, 21475, 20340, 21474, 20345, 21477, 21476, 20346, 21479, 20343, 20344, 21478, 20349, 20347, 20348, 21460, 21464, 21463, 20330, 21462, 20331, 21461, 21468, 20332, 21467, 20333, 21466, 20334, 20335, 21465, 20336, 20337, 20338, 20339, 21469, 21455, 20323, 21454, 20324) OR change_id IN (21457, 20321, 21456, 20322, 21451, 21450, 20320, 21453, 21452, 20329, 20327, 21459, 20328, 21458, 20325, 20326, 20310, 21446, 21445, 20311, 21444, 20312, 21443, 20313, 21442, 21441, 21440, 20318, 20319, 20314, 20315, 21449, 21448, 20316, 20317, 21447, 22679, 25324, 22676, 22675, 25325, 22678, 25322, 22677, 25323, 23278, 25328, 22672, 22671, 25329, 23279, 23276, 22674, 25326, 25327, 23277, 22673, 23275, 23274, 23273, 23272, 22670, 25321, 23271, 23270, 25320, 22689, 25333, 23269, 22688, 25334, 22687, 25335, 22686, 25336, 22685, 25337, 23265, 23266, 22684, 25338, 23267, 22683, 25339, 22682, 23268, 23262, 22680, 23261, 22681, 23264, 23263, 25330, 23260, 25332, 25331, 22658, 22657, 22659, 22650, 22652, 25348, 23298, 22651, 23299, 25349, 25346, 22654, 25347, 22653, 25344, 22656, 25345, 22655, 23293, 25343, 23292, 25342, 23291, 25341, 23290, 25340, 23297, 23296, 23295, 23294, 22669, 22668, 23287, 22663, 25359, 23288, 22662, 22661, 23289, 22660, 22667, 25355, 22666, 25356, 22665, 25357, 25358, 22664, 25352, 23280, 25351, 23282, 25354, 23281, 25353, 23284, 23283, 23286, 25350, 23285, 23239, 23238, 23237, 23236, 24800, 23235, 24801, 23234, 23233, 23232, 24804, 24805, 24802, 24803, 24808, 24809, 24806, 24807, 23230, 23231, 23226, 23225, 23228, 23227, 23222, 23221, 23224, 23223, 23229, 23220, 25307, 22693, 24822, 23257, 23256, 22694, 24823, 25306, 24820, 22695, 23255, 25305, 25304, 22696, 24821, 23254, 25303, 22697, 22698, 25302, 22699, 23259, 25301, 23258, 25300, 24828, 24829, 24826, 24827, 24824, 25309, 25308, 24825, 22690, 23252, 23253, 22692, 23250, 23251, 22691, 23244, 25316, 25315, 23243, 24810, 23246, 24811, 25318, 24812, 23245, 25317, 25312, 23248, 23247, 25311, 25314, 25313, 23249, 24817, 24818, 24819, 24813, 25319, 24814, 24815, 24816, 25310, 23240, 23241, 23242) OR change_id IN (24847, 24846, 24849, 24848, 24841, 24840, 24843, 24842, 24845, 24844, 22607, 24838, 24837, 22606, 22609, 24836, 22608, 24835, 22603, 22602, 22605, 22604, 24839, 24830, 22601, 22600, 24834, 24833, 24832, 24831, 24869, 24868, 24865, 24864, 24867, 24866, 24861, 24860, 24863, 24862, 24859, 24858, 24857, 24856, 24855, 24854, 24853, 24852, 24851, 24850, 25360, 25361, 25362, 25363, 24881, 25364, 24880, 25365, 25367, 22633, 24882, 25366, 24883, 22634, 24884, 22631, 25369, 25368, 22632, 24885, 24886, 22630, 24887, 24888, 24889, 22639, 22637, 22638, 22635, 22636, 25371, 25372, 25370, 24870, 25375, 25376, 25373, 25374, 24873, 22642, 25379, 22643, 24874, 25378, 22644, 24871, 25377, 22645, 24872, 24877, 24878, 22640, 24875, 24876, 22641, 24879, 22646, 22647, 22648, 22649, 25384, 25385, 25386, 25387, 25380, 25381, 25382, 25383, 22611, 25389, 25388, 22612, 22610, 22615, 22616, 22613, 22614, 22619, 22617, 22618, 25390, 24892, 25397, 25398, 24891, 25395, 24890, 25396, 25393, 25394, 25391, 25392, 24899, 24897, 24898, 24895, 22620, 22621, 24896, 24893, 22622, 25399, 22623, 24894, 22624, 22625, 22626, 22627, 22628, 22629))

2011-12-02 17:15:36: (ERROR) There is an error in the query to add an attribute in our cache DB, this is the error we got: A truncation error was encountered trying to shrink VARCHAR 'Change cannot be merged due to unsatisfiable dependencies.

&' to length 16384.

2011-12-02 17:15:36: (ERROR) There is an error in the query to add an attribute in our cache DB for the item Event: Unsatisfiable Dep, this is the error we got: A truncation error was encountered trying to shrink VARCHAR 'Change cannot be merged due to unsatisfiable dependencies.

&' to length 16384.

2011-12-02 17:15:36: (ERROR) There was an internal error when trying to cycle through the data results of the data source.

2011-12-02 17:15:36: (ERROR) A truncation error was encountered trying to shrink VARCHAR 'Change cannot be merged due to unsatisfiable dependencies.

&' to length 16384.

I am not sure how to fix this problem. The query that cause the problem seems to have the same length as the other events.

Thanks,

Deen

JBuijs

Hi Deen,



(I posted an answer yesterday I believe but something must have gone wrong...)

In short, XESame sets a limit of 16384 characters as the value of an attribute. Your error indicates that at least one message from your source database is longer than this limit.

If you really need to include the messages in your eventlog then I would take a substring of no more than the limit #characters of the message as the value of the message attribute.

[Deleted User]

Thanks for the note.  So an attribute value is limited to 16384 character.

JBuijs

Yes, this sould be sufficient for most use cases and reduces the size of the cache database used by XESame.
In general you rarely need complete letters or messages in your event log for analysis. If you store identifiers in your log you can always look it up if necesarry in the source data.