Geoevent server throwing ORA-01795 Error to Arcgis Server

[kishanchintala]

I am using GeoEvent server  filter to filter envent data then i am getting   ORA-01795 Error. T

Error: Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000:: OBJECTID IN ( 409156 , 409184 , 409185 , 409225 , 409226 , 409247 , 409268 , 409276 , 409279 , 409281 , 409289 , 409290 , 409294 , 409300 , 409308 , 409316 , …..)

[PanagiotisPapadopoulos]

You cannot have more than 1000 literals in an IN clause.

But there are alternatives see here:

ORA-01795, limit on in clause | Oracle Community

http://stackoverflow.com/questions/17842453/is-there-a-workaround-for-ora-01795-maximum-number-of-ex...