My Oracle Support Banner

Cannot Retrieve Instances from Engine 'ENGINE_NAME' due to ORA-01795 (Doc ID 1407813.1)

Last updated on SEPTEMBER 04, 2018

Applies to:

Oracle Business Process Management Suite - Version 10.3 and later
Information in this document applies to any platform.

Symptoms


PAPI application cannot execute a filter. When it does you get the following exception:


Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000

You will see the stack trace shows the query which will have a huge number of parameters for the roles:


Caused by: fuego.transaction.DatabaseException: An error occurred while accesing the database.
Detail:SQL statement: 'SELECT PROCESSID, INSTID, THREADID, NAME, PARENTTHREAD, PRIORITY, CREATIONTIME, AUTHOR, PARTICIPANT, NEXTPARTICIPANT, PROCESSDEADLINE, ACTIVITYDEADLINE, RECEIVETIME, ACTIVATIONTIME, ACTIVITYNAME, NTHREADS, CTHREADS, TOTALTHREADS, STATE, SOURCEACTIVITYNAME, ROLEIN, PENDINGITEMID, LASTRESULT, ITEMDEADLINE, NREMARKS, NATTACHMENTS, NCHANGES, FCTHREAD, V_ACCOUNTID, V_ACTIVITYINTIME, V_ALTMANAGERINTIME, V_APPROVALSTATUS, V_APPROVEDSTATUS, V_APPROVERID, V_APPROVERLIST, V_ARRIVEDAPPROVAL, V_BUSINESSUNIT, V_COMPLETEDBYISA, V_COUNTRY, V_CURRANTAPPROVER, V_DEADLINE, V_EXCEPTIONNAME, V_FORMID, V_FORMNAME, V_GROUPAPPVRINTIME, V_HASEXCEEDEDSLA, V_INTIME, V_ISFORMAUTOMATED, V_ISAMANAGERINTIME, V_LOBID, V_MANAGERINTIME, V_MULTIPLESOEIDS, V_ONBOARDINGSOEIDS, V_ONETIMEPASSWORD, V_OVERIDEMGRINTIME, V_OVERRIDEINTIME, V_PASSWORD, V_REACHEDISA, V_REQUESTID, V_REQUESTRECEIVED, V_REQUESTORINTIME, V_SECONDAPPROVERID, V_SECONDMGRINTIME, V_SECURITYPROFILE, V_SUBFIELDS, V_SUBMITTER, V_SYSTEMNAME, V_THIRDPARTYINTIME, V_UNIQUEREQUESTID, V_UNIQUESUBMITTER FROM PPROCINSTANCE WHERE (PROCESSID=4 ) AND (((STATE NOT IN (32,64,1056,17440,1088,17472)) AND (ROLEIN IN (50000000, 50002293, 50002311, 50000119, 50000001, 50002301, 50002302, 50002296, 50000002, 50000003, 50002304, 50002288, 50002294, 50000253, 50000616, 50000620, 50000623, 50000625, 50000648, 50000656, 50000659, 50000660, 50000661, 50000662, 50000663, 50000664, 50000665, 50000666, 50000667, 50000668, 50000669, 50000670, 50000671, 50000672, 50000673, 50000674, 50000675, 50000676, 50000677, 50000678, 50000679, 50000680, 50000681, 50000682, 50000683, 50000684, 50000685, 50000686, 50000687, 50000688, 50000689, 50000690, 50000691, 50000692, 50000693, 50000694, 50000695, 50000696, 50000698, 50000699, 50000700, 50000701, 50000702, 50000703, 50000704, 50000705, 50000706, 50000707, 50000708, 50000709, 50000710, 50000711, 50000712, 50000713, 50000714, 50000715, 50000716, 50000717, 50000718, 50000719, 50000720, 50000721, 50000722, 50000723, 50000724, 50000725, 50000726, 50000727, 50000728, 50000729, 50000730, 50000731, 50000732, 50000733, 50000734, 50000735, 50000736, 50000737, 50000738, 50000739, 50000740, 50000741, 50000743, 50000744, 50000745, 50000746, 50000747, 50000748, 50000749, 50000750, 50000751, 50000752, 50000753, 50000754, 50000755, 50000756, 50000757, 50000758, 50000759, 50000760, 50000761, 50000762, 50000763, 50000764, 50000765, 50000766, 50000767, 50000768, 50000769, 50000770, 50000771, 50000772, 50000773, 50000774, 50000775, 50000776, 50000777, 50000778, 50000779, 50000780, 50000781, 50000782, 50000783, 50000784, 50000785, 50000786, 50000787, 50000788, 50000789, 50000790, 50000791, 50000792, 50000793, 50000794, 50000795, 50000796, 50000797, 50000798, 50000799, 50000800, 50000801, 50000802, 50000803, 50000804, 50000805, 50000806, 50000807, 50000808, 50000809, 50000810, 50000811, 50000812, 50000813, 50000814, 50000815, 50000816, 50000817, 50000818, 50000819, 50000820, 50000821, 50000822, 50000823, 50000824, 50000825, 50000826, 50000827, 50000828, 50000829, 50000830, 50000831, 50000832, 50000833, 50000834, 50000835, 50000836, 50000837, 50000838, 50000839, 50000840, 50000841, 50000842, 50000843, 50000844, 50000845, 50000846, 50000847, 50000848, 50000849, 50000850, 50000851,

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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