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

Last updated on MARCH 08, 2017

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

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 hundreds of Community platforms