we are creating local geodatabase using ArcGIS Runtime SDK .net and we are getting ORA-01795 Error. This error is not consistent when we restarted the server this is not reproducible.
Error: Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000::SELECT OBJECTID, GLOBALID, TEST_DATE, ASSESSMENT_TYPE, FUSERID, HF, POLE_ID, STATUS_CODE, SHAPE, CIP_SH.POLE.SE_ANNO_CAD_DATA FROM CIP_SH.POLE WHERE mdsys.sdo_filter(CIP_SH.POLE.SHAPE, MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1), 'querytype=window') = 'TRUE' AND (OBJECTID NOT IN ( 409156 , 409184 , 409185 , 409225 , 409226 , 409247 , 409268 , 409276 , 409279 , 409281 , 409289 , 409290 , 409294 , 409300 , 409308 , 409316 , …..)
We too have the same scenario.
Error: Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000
We see this error once in two/three weeks and after this lot of errors consequently logged like 'General geodatabse error occured', 'Error: Invalid query' etc.
As mentioned by Cyient NAM, restarting the service works, however, any reason and work around for this problem as we don't want this kind of behaviour in production systems.
Thanks in advance