Create Territory Solution Error

Question

I'm trying to create a territory design and trying to run the Create Territory Solution tool using a polygon feature class from my SDE database. I run the tool and I end up getting an error saying The field is not nullable. All of the fields allow nulls so I'm not sure why I keep getting this error. Any help would be greatly appreciated! Thanks in advance!

kwatsonredlands · Answer

Hi again @michael_vetter thanks for the update! Glad to hear this is resolved. I wonder if this is specific to SDE. For example you could try to export the original feature class to FGDB and see if the same file structure works (where null values would still be present). We wouldn't know for certain unless we had a reproducible scenario. But for now, good to know you can move forward. And if you are able to upgrade to the latest 3.2 version later this year, we have some great UX updates to Territory Design.

michael_vetter · Answer

I was able to figure out what was causing the error. The feature class that I was using has a globalID field that doesn't allow for null values. I created a new feature class without the globalID field and imported the data from the original feature class. Then I used the new feature class as the input data to create the territory solution which ran without any errors.

kwatsonredlands · Answer

Hi @michael_vetter OK that's good to know. To investigate the problem it would be ideal to have your input data and the steps/parameters you used to reproduce the error. WDYT, are you able to share the data? You don't have to do that in this forum, my contact info is above. We can also route this through our Support services team so that we track this. Either way, we'd like to understand this more so we can assist.