laptop and a wrench

Bug

ArcSDE 9.3.1 incorrectly identifies column data type information if adding a 'number(N) default 1 not null' column to a table through SQL.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM049811
SubmittedOctober 14, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
StatusWill Not Be Addressed

Additional Information

No Public Explanation

Workaround

Manually update the sde.column_registry table:TEST1@ORCL>select column_name, sde_type, column_size, decimal_digits from sde.column_registry where table_name = 'TESTDT1' and column_name = 'PS';COLUMN_NAME SDE_TYPE COLUMN_SIZE DECIMAL_DIGITS-------------------------------- ---------- ----------- --------------PS 4 38 10TEST1@ORCL>conn sde/sdeConnected.SDE@ORCL>update sde.column_registry set sde_type = 2 where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>update sde.column_registry set column_size = 10 where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>update sde.column_registry set decimal_digits = null where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>select column_name, sde_type, column_size, decimal_digits from sde.column_registry where table_name = 'TESTDT1' and column_name = 'PS';COLUMN_NAME SDE_TYPE COLUMN_SIZE DECIMAL_DIGITS-------------------------------- ---------- ----------- --------------PS 2 10SDE@ORCL>commit;Commit complete.Preview in ArcCatalog, it is shown as LONG INTEGER

Steps to Reproduce

Bug ID: NIM049811

Software:

  • ArcSDE/Enterprise Geodatabase

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