nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Register View with Geodatabase - Not Null Constraint

KathleenCrombez1

I have created a spatial view in SQL Server that has a not null constraint on a primary key field.

When I try to register this view with the geodatabase I receive an error code 999999.

Error message: The column must not have a NOT NULL constraint.

I cannot find this restriction in any of the ESRI documentation.

Since a field can be set to NOT NULL in SDE I don't understand why is error occurs?

Is this a bug?

If not can someone point me to any documentation that discusses this?

SQL Server 2014 (SP3) on Windows Server 2012

ArcDesktop 10.7.1 on Windows 10 (64 bit)

Thanks,

Kathleen

Find more posts tagged with

Accepted answers

ryanuthoff

We actually encountered this issue yesterday. It turns out, the shape column had a NOT NULL constraint on it. It must be configured to allow nulls.

Unfortunately, Esri's 999999 error message did not specify which column it was referring to, so we had to go down the rabbit hole of figuring that one out. I also can't find any Esri documentation that states that this is a requirement of the shape field. Another failure of Esri's documentation.

Esri, if you are going to provide an error message, please provide documentation on how to fix it. I'd also recommend not giving general 999999 error message when the error message clearly lists a specific error. It's not a general error if the error message knows what the problem is.

All comments

RyanDavis1

Did you ever figure this out? I don't have an answer, but I can tell you that registering a table or view with the geodatabase alters the schema. What type of field is your primary key? It has to be a unique integer.

KathleenCrombez1

No. I was not able to get this resolved.

The primary key is a unique integer. It is also an identity field in SQL if that makes any difference.

RyanDavis1

You might have seen this before, but here is how the ArcGIS data types map to those of SQL Server: DBMS data types supported in ArcGIS—Help | Documentation .

I've had issues with non-supported data types before. SQL Server's BIGINT, for example.

ryanuthoff

We actually encountered this issue yesterday. It turns out, the shape column had a NOT NULL constraint on it. It must be configured to allow nulls.

EsCush

Removing the NOT NULL constraint on the shape column worked! Thank you for posting this and preventing me from going down another rabbit hole in the documentation myself to find direct answers.

RiccardoKlinger

someone should mark this as an answer!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.