SDE Code (-51): Underlying DBMS error

[LizKuhn]

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

[KimPeter]

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