ORA 01795- Maximum numbers of expressions error creating Local Geodatabase

1867
1
03-17-2016 03:40 PM
CyientNAM
New Contributor

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

0 Kudos
1 Reply
ThavitinaiduGulivindala
Occasional Contributor

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

0 Kudos