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 , …..)