English

Error: Failed to Paste Underlying DBMS error

Error Message

While trying to Copy, Paste or Import existing data as ST_GEOMETRY, one of the following errors is displayed:

"Failed to Paste <FEATURE>
Underlying DBMS error[Error executing PL/SQL Block db_stgeom_create_index::ORA-29855: error occured in the execution of ODCIINDEXCREATE routine
ORA-20083: Parameter ST_SRID <SOME NUMBER> does not exist in ST_SPATIAL_REFERENCES table.]
DBMS table not found[<further error info removed>]"

or

"Failed to Paste <FEATURE>
Underlying DBMS error[Error executing stored procedure <schema>.spref_util.insert_spatial_ref::ORA-01400: cannot insert NULL into ("SDE"."ST_SPATIAL_REFERENCES"."SR_NAME")]
DBMS table not found[<further error info removed>]"

Cause

Previous versions of ArcObjects allowed a Spatial Reference to be defined without supplying a name. This created the Spatial Reference with a NULL name.

For example, it is possible to create a feature with a spatial reference (projection) that consists of a string that contains:

GEOGCS["",DATUM["",SPHEROID["",1.0,0.0]],PRIMEM["",0.0],UNIT["",1.0]]

The ST_GEOMETRY type is OGC compliant and requires that the feature have a Spatial Reference with a name.

Solution or Workaround

Recreate the spatial reference by using ArcCatalog.

  1. Highlight the Feature in ArcCatalog, right-click and select Properties.
  2. Select the 'XY Coordinate System' tab. Use the Select, Import or New options to define the spatial reference.