English

Bug: ArcCatalog converts column type Double to Numeric when using SQL Server

Description

ArcCatalog converts a column type Double(0,0) to column type Numeric 17(38,8) when using SQL Server. This can result in data not loading properly. Column type Double(0,0) should be converted to a Float(0,0).

Cause

This is a known issue.

Workaround

Follow one of the workarounds below:

  • Define the columns outside of ArcCatalog.
  • Manually change the column in SQL Server.

    Warning:
    This may only work on an empty column. Data loss may occur if the column types are not compatible.

  • Create a business table using the ArcSDE Admin command sdetable.

    1. Use the following syntax to create a table.

    Code:
    C:\>sdetable -o create -t NewTable -d "NewColumn1 float(0,0)" -i 5151 -s servername -D database -u test -p test

    2. Turn the table into a layer using the ArcSDE Admin command sdelayer.

    Code:
    C:\>sdelayer -o add -l NewTable,shape -e s -g 100
    0,0,0 -G 28355 -i 5151 -s servername -D database -u test -p test

    3. Register the layer with the geodatabase using ArcCatalog.
    4. Populate the layer using the Simple Data Loader in ArcCatalog.