topic esriFieldTypeDouble Max Value in SDE? in ArcObjects SDK Questions

esriFieldTypeDouble Max Value in SDE?

RobertTrevino — Tue, 10 Aug 2010 19:09:40 GMT

Greetings,
I am converting an In-Memory feature class to SDE, but am having an issue.
If I have a column defined as esriFieldTypeDouble, and the value in that column is 1.000000e+037, then saving to an oracle SDE instance fails when attempting a
featureDataConverter.ConvertFeatureClass(inFCName, null, null, outFCName, targetGeometryDef, pFixedFlds, null, 100, 0);
The error I get is:
DBMS table not found[ORA-00942: table or view does not exist][SDEServer.fclassname][STATE_ID = 167]

This seems to only happen when the values in the double column are large, as above. If I edit the value in that column to be a number such as 123.45, it saves without issue.
Is there something special I need to be doing when defining the column? I've tried setting the precision and scale for the esriFieldTypeDouble column to many different combinations, but nothing seems to work.

Thanks for any help!
-Robert

Re: esriFieldTypeDouble Max Value in SDE?

RobertTrevino — Thu, 12 Aug 2010 14:40:50 GMT

No one's ever dealt with saving large numbers to SDE and run across this problem?

Re: esriFieldTypeDouble Max Value in SDE?

vincentLahaye — Thu, 12 Aug 2010 15:19:56 GMT

Hi,

seems Esri featureclass field can get only 17 digits. I already post a similiar question to esri support, and limitation is 17 digit.

here my old thread

http://forums.esri.com/Thread.asp?c=93&f=2370&t=302174&mc=1

The task is NIM032501 but i dont know where to find the definition of this case. This request status is "deffered�??"

Hope it can help you.

Vincent

Re: esriFieldTypeDouble Max Value in SDE?

RobertTrevino — Fri, 13 Aug 2010 18:44:18 GMT

Thanks for the information, Vincent. Not what I was hoping for, but I appreciate your posting the link.