Trouble With Valency Check

[GregHorch]

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?

[KumarBhardwaj]

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?

[GregHorch]

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

[KumarBhardwaj]

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?

[MichelleJohnson]

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