0019238: Linked items fail when too many columns in Oracle

Description

When a module with too many new tables and columns is installed, the Linked items in the User screen fails to load, giving the following message:
@CODE=1795@ORA-01795: maximum number of expressions in a list is 1000

openbravo.log lists this:

1151813 [http-8180-7] ERROR org.openbravo.erpCommon.utility.UsedByLinkData - SQL error in query: SELECT AD_PARENT_MENU_ELEMENT(M.AD_MENU_ID, ?, ?) AS ELEMENT_NAME, ((case when Wt.NAME IS NULL then W.NAME else Wt.NAME end) || ' - ' || (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end)) AS NAME, a.referenced_column_id, T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_ID, '' AS HASTREE, '' AS ID, '' AS WHERECLAUSE, 0 AS TOTAL, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end) AS WINDOWNAME, (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end) AS TABNAME, (CASE WHEN (SELECT COUNT(*) FROM AD_WINDOW_ACCESS WA WHERE W.AD_WINDOW_ID = WA.AD_WINDOW_ID AND WA.AD_ROLE_ID = ?)=0 THEN 'N' ELSE 'Y' END) AS ACCESSIBLE, W.AD_WINDOW_ID as AD_WINDOW_ID, '' as AD_MENU_NAME FROM ( SELECT AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN WHERE UPPER(COLUMNNAME) = UPPER(?) AND (ISPARENT='Y' OR AD_REFERENCE_ID IN ('19', '35')) UNION SELECT AD_COLUMN.AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN, AD_ELEMENT WHERE AD_COLUMN.AD_ELEMENT_ID = AD_ELEMENT.AD_ELEMENT_ID AND UPPER(REPLACE(REPLACE(REPLACE(AD_ELEMENT.columnname, 'Substitute_ID', 'M_Product_ID'),'BOM_ID', '_ID'), 'M_LocatorTo_ID', 'M_Locator_ID')) = UPPER(?) AND AD_REFERENCE_ID IN ('30', '31') AND AD_REFERENCE_VALUE_ID IS NULL UNION SELECT C.AD_COLUMN_ID, s.ad_column_id as referenced_column_id FROM AD_COLUMN C, AD_REF_SEARCH S WHERE C.AD_REFERENCE_ID = '30' AND S.AD_TABLE_ID = ? AND C.AD_REFERENCE_VALUE_ID = S.AD_REFERENCE_ID UNION SELECT C.AD_COLUMN_ID, r.ad_key as referenced_column_id FROM AD_COLUMN C, AD_REF_TABLE R WHERE C.AD_REFERENCE_ID = '18' AND C.AD_REFERENCE_VALUE_ID = R.AD_REFERENCE_ID AND R.AD_TABLE_ID = ? UNION SELECT AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN WHERE AD_REFERENCE_ID = '21' AND UPPER(?) = 'C_LOCATION_ID' UNION SELECT AD_COLUMN_ID, AD_COLUMN_ID as referenced_column_id FROM AD_COLUMN WHERE
AD_COLUMN_ID IN ('03E0E77862F94320AF0A043A52B9D473', 'F9AFAE3531384151BCC1008E5160108E', '803828', '803830', '803837', '803841', '803846', '803848', '803816', '803818', '803858', '803860', '800533', '800535', '800025', '800017', '802527', '802529', '619', '621', 'A742EEB6EBD211DDBAE60016D4EE9DB3', 'A74DB3B4EBD211DD8AA10016D4EE9DB3', '550', '552', '6F387D3737CF3635E040007F01002312', '6F387D3737D13635E040007F01002312', '2599', '2601', '2643', '2645', '10CAC0D710AB4E14B4129E739B032BCC', '9C56850497CE409C9C48FBB4C2A0F7C1', '6F61A8993BC75E52E040007F01005AF5', '6F61A8993BC95E52E040007F01005AF5', '580', '582', '47A925222BF44DED8FC19F413BD5821B', 'D0029DD2D6314D83BFE6141C3DBAA8E1', '5381', '5383', '5391', '5393', '673', '675', '800813', '800815', '4601', '4603', '4629', '4631', '4614', '4616', '1005400242', '1005400244', '915561E66D2E1638E040007F01001C17', '915561E66D301638E040007F01001C17', '9155635C578298D2E040007F01001C13', '9155635C578498D2E040007F01001C13', '6292', '6294', '614', '616', '565', '567', '708', '710', '600', '602', '638', '640', '590', '592', '610', '612', '802450', '802452', '802462', '802464', '565E56DF64DE9042E040007F01002829', '565E56DF64E09042E040007F01002829', '682633A6E6AE9D31E040007F010061E4', '682633A6E6B09D31E040007F010061E4', '682633A6E6BA9D31E040007F010061E4', '682633A6E6BC9D31E040007F010061E4', '682633A6E68C9D31E040007F010061E4', '682633A6E68E9D31E040007F010061E4', '9382FCA58F53AF36E040A8C021013A93', '9382FCA58F55AF36E040A8C021013A93', '800853', '800855', '5C315336D8D8F72DE040007F01013754', '5C315336D8DAF72DE040007F01013754', '5D5E01C8EBD211DD8F740016D4EE9DB3', '5D6B2100EBD211DD92520016D4EE9DB3', '8227', '8230', '1271', '1273', '1471', '2806', '2808', '1292', '1294', '5951', '8224', '8222', '2819', '2821', '2837', '2839', '800704', '800706', '2849', '2851', '555', '557', '668', '670', '560', '562', '1005400270', '1005400272', '718', '720', '5512', '5514', '802700', '802702', '802711', '802713', '628', '630', '8577', '8581', '5C7FEB5FDD3A1EA1E040007F01002676', '5C7FEB5FDD3C1EA1E040007F01002676', '9178CF053CDDBEEDE040007F01002B8B', '9178CF053CDFBEEDE040007F01002B8B', '7809', '7805', '1005400220', '1005400222', '575', '577', '62DD925A901F41099D962DFEFE9CC84F', '9FA500579F424EAC8C1FD05AAFA4F2FA', '653', '655', '545', '547', '8567', '8569', '800688', '800690', '802429', '802431', '802439', '802441', '2860', '2862', '2872', '2874', '624', '626', '5397', '971', '723', '725', '585', '587', '570', '572', '1335', '1337', '698', '700', '77237543C377C8DCE040007F0101413D', '1724F76E1EC411DE85BF8FAF68F519DE', '173056541EC411DEBFB28F44D4806F33', '26E3702BD6F345FB802CD410C12FC6EE', 'AB67B03AC4A84D3F8CF236A16709D908', 'A37C6F84AA243F50E040007F01006E35', 'A37C6F84AA263F50E040007F01006E35', 'BDFC6B326633430292F1C59CEF831534', '046498C716474A6EAAEA0CA26E09C69D', '8BBA8047E1892A2FE040007F010030DC', '8BBA8047E18B2A2FE040007F010030DC', '9DE9E45A80994A969AC623FA97A3C0E8', 'BB2A987CBD534A18B91D77B7D43AF879', '82EFB8E4044019C9E040007F01003778', '82EFB8E4044219C9E040007F01003778', '1007400006', '1007400008', '800481', '2314', '2316', '8515', '8514', '8502', '8524', '8495', '8496', '8478', '8480', '8528', '8533', '8461', '8462', '3036', '3038', '3069', '3071', '4896', '4898', '2898', '2900', '3100', '3101', '5224', '4966', '4968', '4979', '4981', '800800', '800802', '2955', '2957', '800179', '800181', '803229', '803231', '3119', '3121', '40D8FCC5F0774A108328E8ADD47C7D5B', 'D651E163B279486F8F399DC05B63D426', '1111', '1113', '1987', '1989', '1000500050', '1000500052', '1000500054', '946', '948', '9609', '9601', '793', '795', '783', '785', '93FBE8C7C3884D2BA4C194E780B65267', 'E2D4BAECEDD04EE1ADDC4AA88B2DE55B', '9623', '9630', '2415', '2417', '7E4EC834996311DD819F001D09C4A2FE', '7E58D482996311DD9B45001D09C4A2FE', '57A0D4EA68DE7E16E040007F01004841', '57A0D4EA68E07E16E040007F01004841', '57A0D4EA68F87E16E040007F01004841', '57A0D4EA68FA7E16E040007F01004841', '57A0D4EA68EC7E16E040007F01004841', '57A0D4EA68EE7E16E040007F01004841', '8413', '8363', '1000500021', '1000500023', '1506', '1508', '3131', '3133', '1000500033', '1000500035', '1000500007', '1000500009', '1000500061', '1000500063', '2425', '2427', '1005100005', '1005100007', '6908', '6910', '803053', '803055', '803063', '803082', '803084', '803072', '803074', '8189F49FFEA56E56E040007F01003E83', '8189F49FFEA76E56E040007F01003E83', '8189F49FFEBD6E56E040007F01003E83', '8189F49FFEBF6E56E040007F01003E83', '7891269C8412655DE040007F010155CE', '7891269C8414655DE040007F010155CE', '7891269C8404655DE040007F010155CE', '7891269C8406655DE040007F010155CE', '804880D7B0F11126E040007F01004F9E', '804880D7B0F31126E040007F01004F9E', '7891269C83D4655DE040007F010155CE', '7891269C83D6655DE040007F010155CE', '7DC33C42755D3636E040007F01001C0B', '7DC33C42755F3636E040007F01001C0B', '7891269C83F6655DE040007F010155CE', '7891269C83F8655DE040007F010155CE', '78D16B5B178C661EE040007F010152F7', '78D16B5B178E661EE040007F010152F7', '3762A04F00E04B1298FB53AC436B47BF', '001DD60EF52E442C85374BBCB4CABEC6', '0F1394CAD68C4E1EBEC90416205E521B', '0CC9E53ACEFA4F678C718071C423E931', '80E839B16923298FE040007F01005AAF', '80E839B16925298FE040007F01005AAF', '1E02E4686375485595D2EC09B32DCFD5', 'B9336FB7C2B0400EB495358FAB55E17F', '78D10D5CC28EA0ADE040007F010152E6', '78D10D5CC290A0ADE040007F010152E6', '802DBB308CFBC960E040007F01001D1B', '802DBB308CFDC960E040007F01001D1B', '78903669795C2CEFE040007F01013334', '78903669795E2CEFE040007F01013334', '7FF2BE0C55FE41FDE040007F010060C1', '7FF2BE0C560041FDE040007F010060C1', '8189F49FFED86E56E040007F01003E83', '8189F49FFEDA6E56E040007F01003E83', '2EB409FE29174F31AD2C5AF5C3694DE5', 'EFEAAF057602425299AF5E2723FDC786', 'B7ED22A39C674AA0B00C1E8440C0A980', '149DBC9F632549EDB94CE1FE07A37553', '1019', '1021', '5852', '5854', '803765', '803767', '802993', '802995', '1000600018', '1000600020', '803789', '803791', '803776', '803778', '2468', '2470', '3440', '3442', '2660', '2662', '2487', '2489', '800516', '800518', '801074', '801076', '801095', '801097', '8045', '8063', '8039', '802793', '802795', '8109', '8116', '802808', '802810', '828EE0AE7FDC5FA1E040007F010067C7', '828EE0AE7FDE5FA1E040007F010067C7', '4914', '4916', '4931', '4933', '802838', '802840', '802850', '802852', '775', '777', '5265', '5267', '5276', '5278', '5246', '5248', '802928', '802930', '802957', '802959', '800304', '800306', '800724', '800726', '800463', '800465', '800352', '800354', '800377', '800379', '800864', '800866', '803', '805', '1132', '1134', '800269', '800271', '3160', '3162', '828EE0AE7FEE5FA1E040007F010067C7', '828EE0AE7FF05FA1E040007F010067C7', '1646', '1648', '1535', '1537', '3338', '3340', '5009', '5011', '800442', '800444', '800453', '800455', '1622', '1624', '1664', '1666', '800121', '800123', '5288', '5290', '828EE0AE7FD15FA1E040007F010067C7', '828EE0AE7FD35FA1E040007F010067C7', '831', '833', '7B51E0A4E08D4FC6B5C342557B9BD2AF', 'E83170858DE8441C94B64CDA46BC91FF', '876D244AC9DC81F3E040007F010077EB', '876D244AC9DE81F3E040007F010077EB', '876D355A747812B0E040007F01007860', '876D355A747A12B0E040007F01007860', '876D70C14FA50860E040007F0100787B', '876D70C14FA70860E040007F0100787B', '876CE05E802988E4E040007F0100789B', '876CE05E802B88E4E040007F0100789B', '876CE05E803D88E4E040007F0100789B', '876CE05E803F88E4E040007F0100789B', '2032', '2034', '801024', '801026', '3171', '3173', '842', '844', '1817', '1819', '60FCCD631EA7EDF8E040007F01013AD4', '60FCCD631EA9EDF8E040007F01013AD4', '802536', '802538', '803013', '803015', '803032', '803034', '803092', '803094', '800824', '800826', '800330', '800332', '2071', '2073', '4100', '4102', '1002100040', '1002100042', '2245', '2277', '5081', '5083', '1002100022', '1002100024', '1002100079', '1002100081', '1002100093', '1002100095', '1002100062', '1002100064', '803800', '803802', '8207', '8200', '802474', '802476', '3182', '3184', '5095', '5097', '1035', '1037', '4075', '4077', '4088', '4090', '3489', '3491', '3512', '3513', '800788', '800790', '3833', '3835', '801047', '801049', '803126', '803128', '7E595A11D61A446FE040007F010052E9', '7E595A11D61C446FE040007F010052E9', '5574', '2141', '2143', '3856', '3858', '5527', '5529', '5545', '5551', '813', '815', '1394', '1396', '8457', '8449', '8432', '8434', '803499', '803501', '803564', '803566', '803574', '803576', '803606', '803608', '803628', '803630', '803649', '803651', '803671', '803673', '803511', '803513', '803522', '803524', '801239', '801241', '801349', '801351', '802344', '802346', '802223', '802225', '802212', '802214', '802494', '802496', '802071', '802073', '803309', '803311', '803166', '803168', '803214', '803216', '803285', '803287', '802385', '802387', '801481', '801483', '803181', '803183', '803192', '803194', '801205', '801207', '803320', '803322', '801229', '801231', '802578', '802580', '802676', '802678', '802598', '802600', '802628', '802630', '802642', '802644', '802588', '802590', '802688', '802690', '802237', '802239', '802305', '802307', '802379', '802248', '802250', '802258', '802260', '801524', '801526', '803466', '803468', '803488', '803490', '803477', '803479', '801541', '801543', '802322', '802324', '801513', '801515', '3616', '3618', '803332', '803334', '803344', '803346', '803274', '803276', '803354', '803356', '801647', '801649', '801185', '801187', '802332', '802334', '801336', '801338', '801325', '801327', '802357', '802359', '802110', '802112', '801217', '801219', '801610', '801612', '801620', '801622', '801554', '801556', '801569', '801571', '801585', '801587', '2575', '2577', '2589', '2591', '3462', '3464', '800752', '800754', '802753', '802755', '802767', '802769', '3574', '3575', '3587', '3589', '3547', '3549', '3560', '3562', '3663', '3665', '4759', '4761', '3601', '3603', '3526', '3528', '3797', '8771', '3534', '3536', '800647', '800649', '800664', '800666', '1E0F1FC0A13111DD8C2607AC7CEDF203', '1E1DC5C0A13111DDB99E3B8DB28EF9C2', '58E839A0929E0D3BE040007F01015CDF', '58E839A092A00D3BE040007F01015CDF', '56EBD77E6C007067E040007F0100331E', '56EBD77E6C027067E040007F0100331E', '59212C15A6FBF425E040007F01003D5C', '59212C15A6FDF425E040007F01003D5C', '57C8E0FB1412DE03E040007F01001B6B', '57C8E0FB1414DE03E040007F01001B6B', '467F96E0F2BE11DDABCF001D09C4A2FE', '46880B36F2BE11DDAF37001D09C4A2FE', 'FF6EFE0861064F48BF0B0A54C0E8328C', 'B589A2A84FDE4A25966D23BFCDF4F27F', '5506EF5A70A840CF8C8AA08B2E505CBA', '3078E5FF2ED3461796F183DE05D28AED', 'CAFD7AEE08DF4BE1990582203F1B9760', '966A942FA0784F879453553A3A8CA358', '95CC63FD04C021F2E040007F010075C1', '95CC63FD04C221F2E040007F010075C1', '96FCF4C1EF9DAE63E040007F01002B87', '96FCF4C1EF9FAE63E040007F01002B87', '95CC5757ECB7E5B8E040007F010076A5', '95CC5757ECB9E5B8E040007F010076A5', '927D0D118B87EF36E040A8C0CF071CF5', '927D0D118B89EF36E040A8C0CF071CF5', '927D156047B86E92E040A8C0CF071D3D', '927D156047BA6E92E040A8C0CF071D3D', 'F312B5DACFC948D88C060AA5A84F5902', 'E76F59F7E8DE4AE6881DB269A26A0E4E', 'B4ADF38C791A48928DEF50057A6C6412', '104E9E1221184AFBB3BFBA2A80149A95', '927D156047C46E92E040A8C0CF071D3D', '927D156047C66E92E040A8C0CF071D3D', '927D156047A66E92E040A8C0CF071D3D', '927D156047A86E92E040A8C0CF071D3D', '927D156047B06E92E040A8C0CF071D3D', '927DA01A83533AFAE040A8C0CF072B85', '927DA01A83553AFAE040A8C0CF072B85', '7EE03BC0EF044133B80147985FDC69D9', '23C2C64A20BF45E38EF29F98A47B4EDF', '927DA01A835D3AFAE040A8C0CF072B85', '927DA01A835F3AFAE040A8C0CF072B85', '2CE601D3765C4E93A7A754B9EE4819AD', '77EBA5E29565415A9F26C56FA285908F', 'B6DBF915A950414DB1613EAEF2D4EAD1', '55D1966F036543D1A63B16B60A02BB15', '50E6C69E2DBA4C87A4B4F54677644486', '25C39503BBF34AA1BFE3DEB34B457FE8', '5E4F5ECE51A34B969AB3B4483F393CE2', '369AB06834A643D0A737EB8082D9E21D', 'A8FD2025FA244939B687F49907BE94C5', '264214655D654262848E2AB4442322CA', 'E275477B5DC7474AA9490AC2980F9225', 'E8D215F7042A4209BE321D7B83AA163A', '71E68BDB26FF4885B56A3C32A1B3CB78', 'D5ADE9C71E914B68A176C32825772F27', 'F122D4D6438447B9BBBCB52B2F49FBDE', 'AE6A4E222AFC4431A26E7C35B693C498', '5F6CA4435F8E4097B085D4391510CDF7', '927DA01A832F3AFAE040A8C0CF072B85', '927DA01A83313AFAE040A8C0CF072B85', '927DA01A83463AFAE040A8C0CF072B85', '927DA01A83483AFAE040A8C0CF072B85', '927FD1CA753D6901E040A8C0CF073D3E', '927FD1CA753F6901E040A8C0CF073D3E', 'E5831C3A7FB243B78D6C6446D63CAF89', '01D197C1A5A74518AFC6C77F50B7D14C', 'B4FD9EC573F94B9096FF3A41284F338F', '398D12F96DA24398ABD22A7062130761', '182023ADC5294B6C87123A6AF98F567D', 'A03032C18765408EB1F0EF608CDF37D0', 'B0F4DF9FB5024E8484C813D17537FD05', 'B15A61113BD546F989D720AC3A6F236E', 'F9AFC432E4724671909604558790F37C', 'EE79308CC7934527B4E965BBD94B5096', 'F456EE44F0DF47B09107AD51E7D352C1', '816D1C6AE7FA4E789FC1CB73521ECE6F', '10898EB4BCB34C178ED6790431BBFFB1', '2166', '2168', '2186', '2763', '8763', '938BD9AC20C9E2ADE040007F02000462', '1011100005', '1011100007', '2210', '2212', '803113', '803115', '7E562C34A0506EB2E040007F01001D67', '7E562C34A0526EB2E040007F01001D67', '3352', '3354', '713', '715', '581C573C99CA693BE040007F010135E1', '581C573C99CC693BE040007F010135E1', '5BE6AE18BFFB1D56E040007F010148F2', '5BE6AE18BFFD1D56E040007F010148F2', '1997', '1999', 'A908EA6CF218F9C9E040007F01011582', '49438452B86C4672AE4246B40804B601', 'C523906F9ACC461A9C95D7DEB111D566', '92F840D280D411DD83E7FFC78829B539', '92F8940680D411DD82E0AB3620E5EE68', '58D503FCDD99D53FE040007F01016BBB', '58D503FCDD9BD53FE040007F01016BBB', '801109', '801111', '801128', '801130', '801138', '801140', '803258', '803260', '801148', '801150', '801158', '801160', '800774', '800776', '2105', '2107', '6586', '6588', '6617', '6619', '2992', '2994', '2060', '2062', '800215', '800217', '800236', '800238', '800250', '800252', '802724', '802726', '800225', '800227', '802736', '802738', '57B98D87940DA967E040007F01013153', '57B98D87940FA967E040007F01013153', '588907857EA1E0C2E040007F010120BD', '573D452F04D1243FE040007F01012792', '573D452F04D3243FE040007F01012792', '58866B56AA0CDDF4E040007F01014048', '6162397BD0F24953E040007F0101559D', '6162397BD0F44953E040007F0101559D', '6518', '6520', '6502', '6504', '803534', '803536', '1004400029', '803547', '803549', '1004400034', '1004400010', '1004400012', '1407', '1409', '3391', '2562', '2564', '4718', '4720', '9BAEEE4845E738D8E040007F01002420', '9BAEEE4845E938D8E040007F01002420', '1773', '1775', '5116', '5118', '800738', '800740', '803456', '803458', '9C8C523F49E7BD9DE040007F0100646F', '9C8C523F49E9BD9DE040007F0100646F', '1440', '1442', '3327', '3329', '800008', '800011', '1354', '1357', '5797', '5752', '2299', '2301', '9838', '9851', '5763', '5765', '8719', '8710', '800110', '800112', '800114', '800068', '800070', '800075', '800097', '800099', '8739', '8738', '8874', '8877', '8893', '8895', '8707', '8704', '800082', '800084', '87F060C29C5211DDB3CF001D09C4A2FE', '87F7F2389C5211DD8B8A001D09C4A2FE', '861', '863', '6857', '6855', '8839', '6829', '6827', '6894', '6896', '6783', '6781', '7399CFDCF5B72DD0E040007F0101239A', '7399CFDCF5B92DD0E040007F0101239A', '04A44B86E981420381BEF976DF13B3A7', '67CE6AB656E344709AD049E70CE73054', 'F923F1A4C7DC41D58A643E7F2D8294C7', 'A8E9D840B0FE4ACA9E686F96FA26BE39', 'C0D594AEAB0643AFAFCC9362680C3B27', '620CB554320943D0B1CFED7D02E96B2E', '24BC7027AD7D4833A48F1433E59B4AF4', '263C7AB3511940D180A2FF42047B506B', '83D00F01983B40C693967513C4034535', '46B52920215E4094928F34019B54BDB9', 'B69714676FCB43FC80FABFBB6898354D', '2493BA115F494234807CB52B44A0B2DA', '045268C9634D44D8AD2EB80281843F10', '99CDDE1BE7634B0FAB8A7F63013A5B84', '7AC8FF0784D0496FB96A046D0103683F', '5B68F92E550E4827B37CF5D97DC2C488', '9A60ABC9538B984FE040A8C054012F31', '9A60ABC95389984FE040A8C054012F31', '9E263C9DA393F8B9E040007F02005037', '9E263C9DA395F8B9E040007F02005037', '9FC9DBBCA04C8CB2E040A8C054012878', '9FC9DBBCA04E8CB2E040A8C054012878', '9E1C0D274C924C05B1FA4B533DF51131', 'EAECDC93E0BC4C0182416FEE41806274', '0D504D7534F64E979272E0E5DF17F03C', 'A7CE36B8B7F4405CB4E9343D4B2DB205', 'E47190960F754B73B4652B8E3D7BE6C4', '66212E7CDADB45B58EC92C204A9AABB5', '9C6B24FA9EFDEA7AE040007F02005226', '9C6B24FA9EFFEA7AE040007F02005226', '9C81A3830852DAD6E040007F02003345', '9C81A3830854DAD6E040007F02003345', '7ED9426DCBB345C1A3381DE079376A77', '4CB83116C2B848ADA53A1574F7D9A250', '042DC405FED941849701DBE0258BC08D', '2CEC644A54294875AE2A73E7AA253AF9', '81D04E100F10408499416F768DCEAF6A', '8E8FCA82AFD74CB1B4EE86001ACD6C95', 'F0330EF7CF1848598D1243E989864AE6', '844F448A3289434DB369606B894E83B7', 'C08E1CDBC40C4C7A958317589240CEB4', 'EF1F7916E5104451827FADAD9058F063', '078C0FABB9E64297A2539583E58A757D', '69C049B2625C4BE684C247EF9A35CCB2', '6FCD394DA82140BDBB39A38038EF95A7', '84B54AF172BD40539DCC5D93AEFEDC85', '10E3BE3299264BDE93F34C776CCBB446', '01F058F66B1444E299BA53CCF8327493', '3683EB0FEE404779B2FB4BB212F8E3F5', 'E13EC90DA1084089824641994A2AEC50', '3B371F648B154FF5A98799E48D18EB4D', '32B8E38B303947138A2C45A72B70FFEF', '3131DEAF117C490DAEC8D20FE3E6A37F', 'B0C76975F22A41239651F2035AC3C45B', '9CD0221154724463E040007F02001351', '9CD0221154744463E040007F02001351', '9CD02211547F4463E040007F02001351', '9CD0221154814463E040007F02001351', '09D6BC66A430459CAEFEB04A45F6A889', '659905BE6DC64A4CB0CD248B2C09DE03', '9FB5C6F1F16BD7C6E040A8C080CE1D4E', '9FB5C6F1F16DD7C6E040A8C080CE1D4E', '9F8D7D3011B03025E040A8C0813A24B7', '9F8D7D3011B23025E040A8C0813A24B7', '9CD0BC152B1D437AE040290A518804D0', '9CD0BC152B29437AE040290A518804D0', '362321E4DBDF4F4786217681AC0957ED', 'D9A8D21F7E0E48328869261138495519', '80235DC587CA46E086E722D836AD626A', 'DE9AE3258A0D4179B7FEF0F6BCBDF8D9', '218DB593148446548B547EB4CEA1A8EC', '4166355FF7FB4B30AD55BE1EB2A8C2A5', 'FF1A54344CD64F5E8F1A90506CA9D8CD', '9987AB01121048F2A8937B95C6A8654E', '0C23178F2D3849E3B8CE0AE5B73F2956', '2F2AEA48E5884E1FA4A40174488EFEA4', '33CDA91829FF410EAFAF545ACEFC15BD', '0B6B69A008FC416FBB73E7E3DD5BD01C', 'C99AD59ADE634FE69E0FBE65BBCE7254', '7231BAB16E884526A03673BD555E1EAE', 'FE421B8AB59845228493C7F5B4B3DA90', '5E7C68B7BF6E446DA055995904FE23E0', '92EB0211DC796D4AE040007F02003A89', '92EB0211DC7B6D4AE040007F02003A89', 'D20FBD06327F459C8CD4E464D7C6CBE2', '071A31872E4E4C9A802262A3BA3D80BA', '95D015DE46845A79E040A8C0540171EA', '641D62981CF3451B998B1502028D1BB9', '02EDBBAAA3E049CDAE6AF888FDBA27BD', '054EE4EB55B5431AB21D6EB2E5B72C62', '039895156F7C49D49441E24F82833771', 'BBC97D66A40444D8A51DD8732B36FEEB', '62FBA94A10984D0EB9928599278DA5F3', '8802179F29C014F4E040290A6E8830DE', '8802179F29C214F4E040290A6E8830DE', '8802179F29C514F4E040290A6E8830DE', 'A69F7D75639F48D0B637CA278BDF7C0D', 'E0EED41D5D7744BEA521F1EDB1C828F4', '976DBAA78BF54A759FFEFD1317CB46CA', 'AFF58B615F4C4F3197B03C689BC24181', '87FA997D34F1ED10E040290A6E886E0E', '87FA997D34F3ED10E040290A6E886E0E', '7C305C8C5C764A5098A804A65E68371A', '0DFEAB8BE524493D9A186716C8402FCC', 'A605A4527C71491882B3C350CCD9B334', '0F9DEF3BC7574E65A1CE3D4A73E4E81C', 'BFDC3F8D80BD4065ADA010452AC137D9', '4B4B32BB1A7F4E2A97367C94FDA77F04', '6876E6D1800A41A893396068A0BEB8F5', '9CD5CB3E550F4B99869721B4B85F92EE', '93CA1BB6A42E4FE49316B7F6872A72B6', 'B81473E9E4CF4780A902D53BAEF6DEBA', '8C75FD2550982B31E040007F02000165', '8C75FD2550A12B31E040007F02000165', '7BF2755AE8C40438E040007F020016EC', '7BF2755AE8C60438E040007F020016EC', 'D81E55E086EB441D949D68A4905C91A1', 'C20D1BC8ED544F86BFB7D6137DFAC327', '2659E99F258F44FEA2B9BBED7684F7CF', '8C0F945C46F22CCEE040007F020002CC', '8C0F945C46F42CCEE040007F020002CC', '8C0F945C46F52CCEE040007F020002CC', '8C0F945C46E72CCEE040007F020002CC', '8C0F945C46E92CCEE040007F020002CC', '8C0F945C46EA2CCEE040007F020002CC', 'A9365E5F08D3441782A3221488692389', '445FDB4DCF1B44149047758B417C3A25', '8C103784C0739EADE040007F020002C2', '8C103784C0759EADE040007F020002C2', '8C103784C08D9EADE040007F020002C2', '8C103784C08F9EADE040007F020002C2', '25176297F91A4E71931F0BBE42347808', '50C363EE807F4359BB206E65DCB16491', 'D204B56536DB4512B6874C2B33372383', '3270B8B6822147F1BC4863559449AB78', '880E671A1368D0D5E040290A6E8828AE', '880E671A136AD0D5E040290A6E8828AE', '8C0F945C46DB2CCEE040007F020002CC', '8C0F945C46DD2CCEE040007F020002CC', '8C0F945C46DF2CCEE040007F020002CC', '8C0F945C46E02CCEE040007F020002CC', '87FA997D3501ED10E040290A6E886E0E', '87FA997D3503ED10E040290A6E886E0E', '00FC9E415F4F46FD9BFA46AA26B27C6A', '1902FFD144424E3DB1429FFAE0AD37FB', '69A8F59B910F403A806FD24B3BE0D0F7', '6D9559D2147E4EA1B1FECCDE202882E4', 'B410A49F6BB449C38F1D47F68D6CB2F0', '2D2FB2CA684C4615BD4ED72E34F659BA', '85BA7CEA76A84C9C9B4C21B59956EA0F', '8529104725AE4201B4CFBFA8214BCBD2', '8DA95227FBE14F468DBB6B98A00ACC58', '3DD0AB7F96944BBA924DE896D30ACD13', 'F2AD246BE5EA46BA8E01E2A9549F9BD1', 'B737202D077F4FF78C8E3A052C42A602', 'FB1AEDF6B37742ABB85D8F31D6ECB1E3', '4D1CA5776F904B4884B6847F5AAE462F', '8C75FD25508F2B31E040007F02000165', '8C739566170A1353E040007F02000167', '8C7A90CFF0FF9FC1E040007F02000169', '8C7A90CFF1019FC1E040007F02000169', '1F3D5A3FF6774D79BAA7C49459A8E9B6', '931FEA2139A54DE3BAC70B4610BD6563', '6F0916A8C8B94FC3B8CC42A1E3313113', 'CAE8A7A3FAE0441788B04F2F1F84B87F', '8C7A90CFF0EF9FC1E040007F02000169', '8C7A90CFF0F19FC1E040007F02000169', '8A6464BF2E4F4A36AEF1852E4FBA375E', 'EDF8EBADDA854A7E8AC4074CF094C10E', '9F530A4E07E7DC88E040A8C0813A46DA', '9F530A4E07E9DC88E040A8C0813A46DA', '803144', '803146', '803155', '803157', '5672', '5674', '5689', '5691', '5832', '5834', '5705', '5707', '5807', '5809', '1828', '1830', '3395', '8419', '8523', '9084', '9089', '2082', '2084', '9098', '9100', 'B9F3EA403E4049FCBA20C129E5582919', 'C476E0E12AB54B9C9BFADB8D65AE57FB', 'D96682AB088E4B7E8F0E78B23B7CEF61', '007809594C4547ECA877F9B7265AA339', '02FBE256EE1C4279837233AD4563308B', '02D2BC59DCF04D9FA0DDA92B3E062712', '6843', '6841', '6883', '6881', '803422', '803424', '8848', '8847', '852', '854', '1007', '1009', '3964', '3966', '2435', '2437', '1251', '1253', '2447', '2449', '800201', '800203', '2DDCB67302B645219733425DA5964925', 'C4D1537CF8DC4388AEA47EF0D73D5E8B') ) A, AD_TABLE T, AD_COLUMN C, AD_MENU M, AD_WINDOW W left join AD_WINDOW_TRL Wt on W.AD_WINDOW_ID = Wt.AD_WINDOW_ID AND Wt.AD_LANGUAGE = ?, AD_TAB TB left join AD_TAB_TRL TBt on TB.AD_TAB_ID = TBt.AD_TAB_ID AND TBt.AD_LANGUAGE = ?, AD_FIELD F left join AD_FIELD_TRL Ft on F.AD_FIELD_ID = Ft.AD_FIELD_ID AND Ft.AD_LANGUAGE = ? WHERE W.AD_WINDOW_ID = TB.AD_WINDOW_ID AND TB.AD_TABLE_ID = T.AD_TABLE_ID AND T.AD_TABLE_ID = C.AD_TABLE_ID AND C.AD_COLUMN_ID = A.AD_COLUMN_ID AND C.AD_COLUMN_ID = F.AD_COLUMN_ID AND W.AD_WINDOW_ID = M.AD_WINDOW_ID AND TB.ISACTIVE = 'Y' AND W.ISACTIVE = 'Y' AND (TB.WHERECLAUSE IS NULL OR TB.WHERECLAUSE NOT LIKE '%@%') GROUP BY M.AD_MENU_ID, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end), (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end), a.referenced_column_id, T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_ID, W.AD_WINDOW_ID ORDER BY 1, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end), (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end), T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_IDException:java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Steps To Reproduce

It's difficult to reproduce this one because you would have to created many new tables and columns that point back to ad_user table. if you contact me I can privately provide a few customer modules that contain MANY new tables and columns which cause this error to appear.

Proposed Solution

The Linked Items process (namely UsedByLink_data.xsql) needs to be refactored not to use "IN for WHERE AD_COLUMN_ID IN ('1')"

Notes
(0044142) alostale (manager) 2012-01-09 12:15	Changing from defect to design defect as this requires a refactor in the complete component.

(0052407) AugustoMauch (manager) 2012-09-24 20:57	Effort: 3 Impact: low Plan: mid

Issue History
Date Modified	Username	Field	Change
2011-12-02 17:48	roklenardic	New Issue
2011-12-02 17:48	roklenardic	Assigned To	=> alostale
2011-12-02 17:48	roklenardic	Web browser	=> Google Chrome
2011-12-02 17:48	roklenardic	Modules	=> Core
2012-01-09 12:15	alostale	Web browser	Google Chrome => Google Chrome
2012-01-09 12:15	alostale	Note Added: 0044142
2012-01-09 12:15	alostale	Type	defect => design defect
2012-09-10 13:16	alostale	Relationship added	depends on 0019505
2012-09-24 20:57	AugustoMauch	Web browser	Google Chrome => Google Chrome
2012-09-24 20:57	AugustoMauch	Note Added: 0052407
2012-09-24 20:57	AugustoMauch	Status	new => scheduled
2017-03-31 14:36	alostale	Status	scheduled => acknowledged
2017-04-10 14:33	alostale	Assigned To	alostale => platform
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base