ArcSDE Oracle Maximum number of grids per feature (8000) exceeded

Question

Hi,
I have a problem with the import of data (lines) to ArcSde Oracle.
2011-07-14 12:10:04|  22.9|  0.0|ERROR |Error while executing stream insert operation for table 'CHEMN'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(29875) SDE_ERROR_MSG1(ORA-29875: échec d'exécution de la routine ODCIINDEXINSERT
ORA-20092: Maximum number of grids per feature (8000) exceeded.
ORA-06512: à "SDE.ST_DOMAIN_METHODS", ligne 1982

Have you a solution ?
Thanks

GISGroup · Answer

Hi, I have same problem. did you solve your issue? regards KumarWhat version of Oracle are you using [A.B.C.D notation] Which CPU has been applied? 11g What version of ArcSDE are you using? [version and service pack, plus any patches] 10 without patch How are the layer's index parameters currently defined? ('sdelayer -o describe_long' output will suffice) ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010 Layer Administration Utility ----------------------------------------------------- Layer Description ....: Table Owner ..........: TEST Table Name ...........: CHEMN Spatial Column .......: SHAPE Layer Id .............: 183 SRID .................: 0 Auth SRID.............: 0 Minimum Shape Id .....: 1 Offset ...............: falsex: -400.000000 falsey: -400.000000 System Units .........: 1000000000.000000 Z Offset..............: -100000.000000 Z Units ..............: 10000.000000 Measure Offset .......: Measure Units ........: XY Cluster Tolerance .: 0.000000008983 Spatial Index ........: parameter: SPIDX_GRID,GRID0=0.066,FULL exist: Yes array form: 0.066,0,0 Layer Envelope .......: minx: -79.49073, miny: 44.99677 maxx: 1083343.00000, maxy: 1354905.00000 Entities .............: l+ Layer Type ...........: Extended SQL Type/ST_GEOMETRY Creation Date ........: 07/05/11 15:34:26 I/O Mode .............: NORMAL Autolocking ..........: Enabled Precision.............: High User Privileges ......: SELECT, UPDATE, INSERT, DELETE Coordinate System ....: GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1 984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292 5199433]] What is the origin of the data which is being loaded? What tool is being used to load it? I try to import line (MapInfo) to ArcSde. And i use FME Desktop and Server. How many rows exist in the layer before import? How many rows are being added? May be 10000 features.

VinceAngelo · Answer

0.066 degrees is an awfully small grid size.  How large are the objects?  Do they vary greatly 
in extent? 
 
It probably wouldn't hurt to set the grid size to 5 or even 30 degrees, load the features, and 
*then* try to determine a more appropriate grid size.
 
- V

JOhntwi · Answer

What version of Oracle are you using [A.B.C.D notation] Which CPU has been applied? 11g What version of ArcSDE are you using? [version and service pack, plus any patches] 10 without patch How are the layer's index parameters currently defined? ('sdelayer -o describe_long' output will suffice) ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010 Layer Administration Utility ----------------------------------------------------- Layer Description ....: Table Owner ..........: TEST Table Name ...........: CHEMN Spatial Column .......: SHAPE Layer Id .............: 183 SRID .................: 0 Auth SRID.............: 0 Minimum Shape Id .....: 1 Offset ...............: falsex: -400.000000 falsey: -400.000000 System Units .........: 1000000000.000000 Z Offset..............: -100000.000000 Z Units ..............: 10000.000000 Measure Offset .......: Measure Units ........: XY Cluster Tolerance .: 0.000000008983 Spatial Index ........: parameter: SPIDX_GRID,GRID0=0.066,FULL exist: Yes array form: 0.066,0,0 Layer Envelope .......: minx: -79.49073, miny: 44.99677 maxx: 1083343.00000, maxy: 1354905.00000 Entities .............: l+ Layer Type ...........: Extended SQL Type/ST_GEOMETRY Creation Date ........: 07/05/11 15:34:26 I/O Mode .............: NORMAL Autolocking ..........: Enabled Precision.............: High User Privileges ......: SELECT, UPDATE, INSERT, DELETE Coordinate System ....: GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1 984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292 5199433]] What is the origin of the data which is being loaded? What tool is being used to load it? I try to import line (MapInfo) to ArcSde. And i use FME Desktop and Server. How many rows exist in the layer before import? How many rows are being added? May be 10000 features.