topic Re: Model Builder Freezes When I click Verify in ModelBuilder Questions

Model Builder Freezes When I click Verify

MarkYoung3 — Thu, 03 Mar 2016 10:29:37 GMT

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.

Re: Model Builder Freezes When I click Verify

JacobTodd1 — Thu, 03 Mar 2016 13:42:16 GMT

Hi Mark,

What version of ArcMap are you using?

Re: Model Builder Freezes When I click Verify

MarkYoung3 — Thu, 03 Mar 2016 13:47:24 GMT

10.2.2

Re: Model Builder Freezes When I click Verify

JacobTodd1 — Thu, 03 Mar 2016 14:01:14 GMT

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

Re: Model Builder Freezes When I click Verify

MarkYoung3 — Thu, 03 Mar 2016 14:06:13 GMT

Hi,

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

Thanks

Mark

Re: Model Builder Freezes When I click Verify

JacobTodd1 — Thu, 03 Mar 2016 14:13:00 GMT

Below are some suggestions:

Try using model builder in a different map document.
Reset your Normal.mxt by changing it's name to Normal_old.mxt then try to either open and existing map document or a new one to see if this resolves your issue. The path to the Normal.mxt is below:

(C:\Users\<your username>\AppData\Roaming\ESRI\Desktop10.3\ArcMap\Templates\Normal.mxt)

Re: Model Builder Freezes When I click Verify

MarkYoung3 — Thu, 03 Mar 2016 14:53:24 GMT

Hi,

Cleared normal template and tried again but it just hangs.

Thanks

Mark

Re: Model Builder Freezes When I click Verify

DuncanHornby — Thu, 03 Mar 2016 17:18:10 GMT

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.

Re: Model Builder Freezes When I click Verify

MarkYoung3 — Thu, 03 Mar 2016 17:41:42 GMT

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

Re: Model Builder Freezes When I click Verify

DuncanHornby — Thu, 03 Mar 2016 17:51:06 GMT

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?

Re: Model Builder Freezes When I click Verify

MarkYoung3 — Mon, 07 Mar 2016 07:56:06 GMT

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

Re: Model Builder Freezes When I click Verify

DuncanHornby — Mon, 07 Mar 2016 09:54:59 GMT

Only trying to help and if you post substitute information and not the real information then don't be surprised no one can help you! May be the problem is with the very name of the field? But as you seem to be refusing to show us the actual expression then...well... Good luck!