ORA 01795- Maximum numbers of expressions error creating Local Geodatabase

CyientNAM — Thu, 17 Mar 2016 22:40:58 GMT

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

Re: ORA 01795- Maximum numbers of expressions error creating Local Geodatabase

ThavitinaiduGulivindala — Fri, 01 Dec 2017 13:51:37 GMT

Hi,

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

- Thaviti

topic Re: ORA 01795- Maximum numbers of expressions error creating Local Geodatabase in .NET Maps SDK Questions

ORA 01795- Maximum numbers of expressions error creating Local Geodatabase

Re: ORA 01795- Maximum numbers of expressions error creating Local Geodatabase