BUG

ArcCatalog converts column type Double to Numeric when using SQL Server

Last Published: April 25, 2020

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.

Article ID:000007248

Software:
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

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