In P6 Professional, Selecting "Close All" Produces Event Code: PRMDB-2176-3 (Doc ID 2119782.1)

Last updated on OCTOBER 19, 2023

Applies to:

Symptoms

Using P6 PROFESSIONAL client application:  After opening an entire EPS (hundreds of projects)  and attempting to use "File - Close All", the following error occurs:

ERROR
-----------------------
Event Code: PRMDB-2176-3

PRM DBAccess Error: Error executing query. Error: ORA-01795: maximum number of expressions in a list is 1000


Session -1 -- privuser::ASEHIC (PM.exe) -- UTF-8 -- 668E-15CC-192.168.1.1{EA1FCCCD-5527-4ED6-B75B-1DC3F04D16C3}
DB Connection oracle.jdbc.driver.T4CConnection@7c09f58a
Request type: EXECUTE_SQL
Command text: Generic_Delete
Parameter count: 4
0 -- INPUT -- String = PROJSHAR
1 -- INPUT -- Integer = 3931
2 -- INPUT -- String = 1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1598,1599,1600,1601,1603,1605,1628,1630,1632,1635,1658,1660,1663,1667,1683,1687,1714,1728,1735,1759,2038,2040,2042,2044,2046,2050,2052,2054,2056,2068,2070,2072,2074,2076,2078,2082,2084,2086,2088,2089,2090,2092,2093,2095,2096,2103,2104,2105,2106,2107,2108,2109,2111,2116,2118,2120,2122,2124,2126,2129,2132,2133,2134,2135,2136,2137,2138,2140,2144,2146,2148,2149,2150,2151,2152,2154,2155,2156,2157,2158,2159,2161,2162,2163,2164,2165,2166,2167,2168,2170,2172,2174,2176,2179,2180,2182,2184,2186,2188,2198,2200,2202,2204,2206,2208,2209,2210,2212,2213,2214,2215,2216,2217,2228,2238,2242,2244,2246,2249,2251,2258,2259,2260,2261,2263,2264,2265,2266,2267,4358,4366,4370,4633,4634,4635,4636,4637,4638,4639,4640,4641,4642,4643,4644,4645,4646,4647,4648,5287,5337,5387,5437,5487,5537,5587,5637,5687,5737,5787,5837,5887,5937,5987,6037,6087,6137,6187,6237,6287,6337,6387,6437,6487,6537,6587,6637,6687,6737,6787,8489,8539,8589,8639,8689,8739,8789,8839,8889,8939,8989,9039,9089,9139,9189,9239,9289,9339,9389,9439,9489,9539,9589,9639,9689,9739,9789,9839,9889,9939,9989,10039,10089,10139,10189,10239,10289,10339,10389,10439,10489,10539,10589,10639,10689,10739,10789,10839,10889,10939,10989,11039,11089,11139,11189,11239,11289,11339,11389,11439,11489,11539,11589,11639,11689,11739,11789,11839,11889,11939,11989,12090,12141,12242,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12345,12346,12347,12348,12349,12350,12351,12352,12353,12354,12355,12356,12357,12358,12359,12360,12361,12362,12363,12364,12365,12366,12367,12368,12369,12370,12371,12372,12373,12374,12375,12376,12377,12378,12379,12380,12381,12382,12383,12384,12385,12386,12387,12388,12389,12390,12391,12392,12393,12394,12395,12396,12397,12398,12399,12400,12401,12402,12403,12404,12405,12406,12407,12408,12409,12410,12411,12412,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,12440,12441,12442,12443,12444,12477,12478,12479,12480,12481,12482,12483,12484,12485,12486,12487,12488,12489,12490,12491,12492,12493,12494,12495,12496,12497,12498,12499,12500,12501,12502,12503,12504,12505,12506,12507,12512,12513,12514,12515,12516,12526,12527,12529,12530,12531,12601,12602,12603,12604,12605,12606,12607,12608,12609,12610,12611,12612,12614,12615,12616,12617,12618,12619,12620,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12633,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12646,12647,12648,12649,12650,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12706,12707,12708,12709,12710,12711,12712,12713,12714,12715,12716,12717,12718,12719,12720,12721,12722,12723,12724,12725,12726,12727,12728,12729,12730,12731,12732,12733,12734,12735,12736,12737,12775,12776,12777,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12798,12799,12800,12801,12802,12803,12804,12805,12806,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12856,12857,12858,12859,12860,12861,12862,12863,12864,12869,12870,12871,12872,12873
3 -- INPUT -- String = headerParam=pt|name,pw|session_id,ic|proj_id
Block count: 0
Total data size: 0 bytes (before compression)
Total job time spent to push in the queue: 0 ms
Total job time: 0 ms (not including compression)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.