laptop and a wrench

Bug

Spatial Type for Oracle: Registration fails for tables with an ST_Geometry attribute and an SRID set to 0. (Please see technical article 35028 for a suggested workaround.)

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM036997
SubmittedJuly 24, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3
Version Fixed9.4
StatusFixed

Description

When attempting to register a layer using the ArcSDE administration command 'sdelayer -o register' and specifying a SRID value of 0, the registration fails.

Code:
D:\>sdelayer -o register -l world_capitals,shape -e p -R 0 -C oid,sde -t st_geometry -u admin -p admin -i 5151

Error, Invalid (-R) SRID 0


Cause

Registering a layer with the ArcSDE administration command 'sdelayer -o register' currently does not support a SRID value of 0. The specified SRID value must be greater than 0.

Workaround

Change the table's geometries SRID value to a value greater than 0 and re-execute the registration command.
Code:
D:\>sdelayer -o register -l world_capitals,shape -e p -R 1 -C oid,sde -t st_geometry -u admin -p admin -i 5151

ArcSDE 9.3 for Oracle11g Build 508 Thu Apr 17 12:23:18 2008
Layer Administration Utility
-----------------------------------------------------
Successfully Created Layer.


    Steps to Reproduce

    Bug ID: NIM036997

    Software:

    • No Product Found

    Get notified when the status of a bug changes

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options