'The field is not nullable' only after turning labels on

BenVan_Kesteren1 — Fri, 10 Dec 2021 22:49:10 GMT

Hi All,

Problem: when I turn labels on within a feature class with a join, I get the error 'The field is not nullable'.

Method:

I have got a Feature class with all properties in my area, these all have a 'parcel_no', these parcels can be joined to an Oracle DB using a simple SQL Query Layer, this is the query:

select 
CAST(mdu_acc AS INT) as PARC_NO
from 
aumememo 
where 
mem_typ = '38'
group by mdu_acc

This returns a table which is looking exactly as expected.

No errors appear at this stage.

So i then navigate to my polygon feature class, and create the join to this newly added table, all works fine:

Still no errors appear, and they display perfectly on the map (in red).

Next I try to add a label based on the parcel number from the original Polygon Feature Class, very simple:

I press OK, then Bingo, the error appears, but note the labels display perfectly:

I have gone and tried to do a simple python label query where it only returns items where fiels is not None, this had no effect at all. I can try turning off the labels in order to remove the error, but this has no effect also.

The only way I can get the error to bugger off is by removing the join, then adding the join again. But the second I turn labels on the error re-appears.

Has anyone found a solution to this or experienced this before?

I am wondering if there is a bug in arc map when creating a join and labeling. I have come across this in the past, but it is not consistent as far as I can tell.

Thanks for your time.

-Ben

Nathan Duncan

topic 'The field is not nullable' only after turning labels on in Mapping Questions

'The field is not nullable' only after turning labels on