topic Re: SDE Code (-51): Underlying DBMS error in Data Management Questions

SDE Code (-51): Underlying DBMS error

LizKuhn — Tue, 28 Sep 2010 12:21:38 GMT

I try to create an SDE table using the following BAT file at the CMD prompt:
shp2sde ^
-o create ^
-l SDECountyTEMP,shape ^
-f C:\SHPFiles\SDECOUNTY\SDECOUNTY2010.shp ^
-g 95.31 ^
-x -9768.075578,-9600.318133,111320.7 ^
-e a+ ^
-G 4269 ^
-S "ESRI County 2008 Data-Alaska,Hawaii Omitted" ^
-a all ^
-c 500 ^
-v ^
-D REGISSTAGE ^
-i esri_sde ^
-s tacitus ^
-u *** ^
-p ******

I get this error message:
SDE Code (-51): Underlying DBMS error
Extended DBMS error code: 0
Underlying DBMS error
Error in SE_registration_alter ()
3109 features converted.
3109 features stored.

I am working in ArcGIS/ArcSDE 9.3.1

Any help would be appreciated and I am a novice so please low-tech language would also be appreciated,
Liz

Re: SDE Code (-51): Underlying DBMS error

KimPeter — Wed, 13 Oct 2010 21:58:45 GMT

Hi Liz,

I don't think your -g value is valid. That option is used to specify the type of spatial index and, if applicable, spatial index parameters. I believe your possible options are

GRID,<a grid size>
AUTOMATIC
NONE
RTREE

Which ones you can use depends on the DBMS you are using and the geometry storage type used to create the feature class. (In your example, the -k was not specified, so whatever the GEOMETRY_STORAGE value you have set in your DEFAULTS keyword in the DBTUNE table is what will be used to create the feature class.)

However, that error message seems to indicate there's something about the information passed that the DBMS didn't like. Did your DBMS error log file show anything?

-Kim