topic Re: Trouble With Valency Check in ArcGIS Data Reviewer Questions

Trouble With Valency Check

GregHorch — Tue, 06 Sep 2011 18:57:06 GMT

I'm trying to create a valency check using a customized table query.

Many of the checks I've created are working just fine, like this one:

(ValencySum >= 1) AND (DATUM = DATUM_1) AND (Round((UPSTMINVERTELEV - UPSTMOFFSET),2) <> Round(INVERTELEVATION ,2))

However, the ArcMap crashes every time I run this query:

(ValencySum >= 1) AND (Left (MAINID, 9) <> NODEID)

The valency check is creating an access db in my local temp directory. In that db, the text fields (MAINID and NODEID) are stored in a currency field.

I'm running PLTS Service Pack 2 Patch 1.

Any thoughts?

Re: Trouble With Valency Check

KumarBhardwaj — Wed, 07 Sep 2011 19:50:00 GMT

Hi Greg,

I have added two text fields MAINID and NODEID in the sample data and then run the valency check using the same customized table query on a Production Mapping 10 SP2 Patch 1 machine:

(ValencySum >= 1) AND (Left (MAINID, 9) <> NODEID)

but I am not able to reproduce this issue.

Can you please confirm

1. What type of values are present in MAINID and NODEID fields?
2. MAINID and NODEID fields exist in the same feature class or different feature classes?
3. Are you running the individual check or a batch job?
4. What is the extent you are running this check on? Selection set, Definition Query or Full Database?

Also would it be possible for you to share a sample of your data to reproduce this issue?

Re: Trouble With Valency Check

GregHorch — Thu, 08 Sep 2011 11:15:29 GMT

Hi Kumar,

1) MainID = 0145T0012:0145T0013 NodeID = 0145T0012
2) These fields are in different feature classes (MainID is a line and NodeID is a point)
3) ArcMap crashes in both a batch job and an individual check
4) Extent is a Selection Set

Re: Trouble With Valency Check

KumarBhardwaj — Fri, 09 Sep 2011 23:13:53 GMT

Hi Greg,

I am still not able to reproduce this issue. Can you please provide us a sample of your data to reproduce this issue?

Re: Trouble With Valency Check

MichelleJohnson — Tue, 13 Sep 2011 20:21:20 GMT

Check to see if there are any invalid geometries in your dataset.