ORA-20092: Maximum number of grids per feature exceeded

Symptom

The following warning in the FME log file results in data not being loaded to ArSDE:

Feature will be lost. The error message was: "Error while executing stream insert operation for table 'TABLE1'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(29875) SDE_ERROR_MSG1(ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-20092: Maximum number of grids per feature (8000) exceeded. ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 1982
 

Cause

The SDE maximum grid size has been exceeded.

ORA-20092: Oracle reserves ORA -20000 to -20999 numbers for "user specific error messages", so that applications can raise an application specific error (in this case it's SDE). PL/SQL is used to raise the errors.

ORA-06512: indicates the line number of the PL/SQL code that raised the error.
 

Resolution

If writing to a new table the parameters grid 0, grid 1, grid 2 on the destination feature type allow you to adjust the grid size:

Otherwise, create or adjust the grid size with ArcSDE commands. The following article describes ArcSDE grid size optimization:
The Role of Grid Size Optimization in ArcSDE Performance Tuning.