topic Can't Load Data "Field not nullable" in Data Management Questions

Can't Load Data "Field not nullable"

tongkimongki — Wed, 14 Apr 2010 06:01:23 GMT

Dear experts,

I cant load data into my Oracle SDE because there is error "field not nullable". I've checked all fields, they have property "allow null : Yes" except the geometry field. I have tried to load data which have values for all fields but the error is still the same.
Why ?

Environment: SDE 9.3 sp 1, Oracle 10g R2, Desktop 9.3, Windows 2000 Server

Thanks before

Can't Load Data "Field not nullable"

VinceAngelo — Wed, 14 Apr 2010 11:27:21 GMT

ArcSDE requires that the geometry column permit NULL values. Registered
rowid columns are required to be NOT NULL.

- V

Can't Load Data "Field not nullable"

tongkimongki — Thu, 15 Apr 2010 01:29:06 GMT

Morning Vince,

I just realized that the geometry colums permit NULL values by default. As I said, i have tried to load data with non-empty values but it just wont get loaded... I dont have any null values, why do i get rejected as if i am trying to insert null values into non-null field ?

Thanks again

Can't Load Data "Field not nullable"

VinceAngelo — Thu, 15 Apr 2010 02:34:47 GMT

ArcSDE isn't generating this message, so I have no idea what is going on.

I'm assuming you're using Desktop to load. Have you tried a command-line
loading tool with the same data? Have you tried enabling tracing, and looking
at the sequence of functions? Have you tried using 'sdetable -o describe' on
the table to see if the attributes agree (the rowid column cannot allow NULLs,
and must be SDE-set for ArcGIS to load it)?

- V

Can't Load Data "Field not nullable"

JoseSanchez — Tue, 27 Apr 2010 12:37:32 GMT

When I have this problem I just open the database with Oracle SQL DEveloper and change the specific field to accept null values. Do not use ArcCatalog for that.