topic ArcSDE Oracle Maximum number of grids per feature (8000) exceeded in Data Management Questions

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

JOhntwi — Thu, 14 Jul 2011 16:20:10 GMT

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

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

VinceAngelo — Thu, 14 Jul 2011 16:28:55 GMT

There are many possible solutions; determining the best solution requires more information...

What version of Oracle are you using [A.B.C.D notation] Which CPU has been applied?

What version of ArcSDE are you using? [version and service pack, plus any patches]

How are the layer's index parameters currently defined? ('sdelayer -o describe_long' output
will suffice)

What is the origin of the data which is being loaded? What tool is being used to load it?

How many rows exist in the layer before import? How many rows are being added?

- V

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

JOhntwi — Thu, 14 Jul 2011 16:35:25 GMT

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 ....: <None>
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 .......: <None>
Measure Units ........: <None>
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.

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

VinceAngelo — Thu, 14 Jul 2011 17:31:00 GMT

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

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

GISGroup — Thu, 22 Sep 2011 05:28:54 GMT

Hi,

I have same problem. did you solve your issue?

regards
Kumar

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 ....: <None>
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 .......: <None>
Measure Units ........: <None>
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.