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; } } }

Model Builder Freezes When I click Verify

MarkYoung3

Hi,

For some reason model builder just hangs when I click verify on a simple query within query builder on the final select process below. The query is: table name.FIELDNAME is null

If I verify without running the first two processes it says there is an error with the expression. If I run the first two processes then click verify it hangs and I have to kill ArcMap and try again.

Find more posts tagged with

Accepted answers

All comments

MarkYoung3

Hi,

As I have previously mentioned it is an alias!

My table is not called table name and my field is not called field name. As I am posting on the internet I have removed the real table name and field name....... So please spare me a lecture on creation of metadata and data usability.

Thank you

D_Hornby_ddh_uni

Your query has a space in it between table and name, that would be invalid

table name.FIELDNAME is null

Personally and far from me to tell you how to do your analysis but a dataset called "table name" and a field called "fieldname" are not very descriptive! What metadata are you going to write about these and it is not very helpful for others if you intend to pass this data onto a client. It's akin to receiving a dataset simply called export_output7.shp. Export of what?

MarkYoung3

Hi,

That was the sql query (apart from table name and field name is aliased) - I just want to select null values in a field. Unfortunately there is no error message, it just hangs then I have to Kill ArcMap

Thanks

Mark

D_Hornby_ddh_uni

If the error message is saying that it's with the expression then I guess that is the problem!

Update your question to show the expression that is being used. You seemed to have given us a generic example rather than the actual expression.
What's the data source formats? Are you joining a dBase to an ArcSDE?
Confirm that your join actually worked, do that outside model builder.

MarkYoung3

Hi,

I don't use model builder that often but as far as I know it used to work OK

Thanks

Mark

JacobTodd1

Is this a new issue? When did this begin occurring?

MarkYoung3

10.2.2

JacobTodd1

Hi Mark,

What version of ArcMap are you using?

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.