AnsweredAssumed Answered

SDE Invalid Column Data Type Error

Question asked by mvolz47 on Jan 18, 2017
Latest reply on Jan 25, 2017 by asrujit_pb

I am trying to edit a linear SDE feature class that is part of a geometric network in a feature dataset that has not been edited in quite some time (probably not for 2 SDE upgrades). The linear SDE feature class is stored in an Oracle 11.2.0.3 (AIX 64-bit platform) database and I am working with ArcGIS for Desktop v10.3.1. When I try to make an edit (e.g. delete 2 line segments) after starting an edit session, Desktop throws an error "The features could not be deleted.  Invalid column data type.".  Then if I try to the delete a feature after that I get the initial error, I then get a different error "The features could not be deleted.  FDO error: -2147216071".

 

If I recreate the geometric network and feature dataset inside a new file gdb, I am able to successfully delete the line segments without the errors I am encountering in SDE.

 

This layer is used widely across my organization's enterprise environment in 100s of mxds so it is imperative that it is fixed without the renaming of the data which would create many broken links.

 

Has anyone encountered this type of error before?  If so, how did you solve the problem?

 

Any help or hints are greatly appreciated.

Outcomes