Problems with VALIDATE_ATTRIBUTE_LOOKUP

MarielaDel_Rio — Thu, 16 May 2019 20:12:45 GMT

Any ideas as to where to get help when something fails?

I configured the dynamic table to get some values from a master street table into the SiteAddressPoint table using the Validate attribute lookup method. It did not work.

I set the AA to debug and found that a couple of fields were not found. I have no idea where these fields are searched because both, the SiteAddressPoint and Master tables have the fields.

This is the configuration on the dynamic table:

TABLENAME: SiteAddressPoint

FIELDNAME: FULLNAME,PREDIR,STNAME,STTYPE,STTYPE1, STTYPE2, ALTUNITTYPE

VALUEMETHOD: VALIDATE_ATTRIBUTE_LOOKUP

VALUEINFO: MasterStreetName|FULLNAME, ROADPREDIR, ROADNAME, ROADTYPE, ROADTYPE1, ROADTYPE2, RAMP

Both sets of fields exist, FIELDNAME fields are from siteAddressPoint, and Fields from VALUEINFO exist in Master Street name.

The logfile states the rule was not processed:

------------------------------------------------
Row Info
Row Number 8
TableName: SiteAddressPoint
FieldName: FULLNAME,PREDIR,STNAME,STTYPE,STTYPE1, STTYPE2, ALTUNITTYPE
ValueInfo: MasterStreetName|FULLNAME, ROADPREDIR, ROADNAME, ROADTYPE, ROADTYPE1, ROADTYPE2, RAMP
ValueMethod: VALIDATE_ATTRIBUTE_LOOKUP
On Create: 1
On Change: 1

Checking for Subtype Restriction <------ I do not know where this is
Field Name: Street Name was found at index: 12 <---- I am not sure where "Street Name is"
Field Name: QUADRANT was found at index: 43 <---- or quadrant
Field Name: STNAME was found at index: 44
Field Name: STTYPE was found at index: 45
Field Name: STTYPE1 was found at index: 54
STTYPE2 Field not found <------ These two fields exist in SiteAddressPoint
ALTUNITTYPE Field not found
Rule not processed
------------------------------------------------

Any help would be appreciated.

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP

MikeMillerGIS — Fri, 17 May 2019 13:34:12 GMT

It searches the TOC, not by layer name, but feature class name. Could there be a table with the same gdb name?

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP

MarielaDel_Rio — Tue, 21 May 2019 16:45:21 GMT

Unfortunately, that is not the case. the TOC has spaces in it, the actual FC do not. They are MasterStreetName and SiteAddressPoint.

Thank you

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP

MikeMillerGIS — Thu, 30 May 2019 20:11:42 GMT

It does not use the TOC name, just the Feature Class Name. Some pictures of the map and your dynamic value table would be helpful

topic Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP in Water Utilities Questions

Problems with VALIDATE_ATTRIBUTE_LOOKUP

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP

Re: Problems with VALIDATE_ATTRIBUTE_LOOKUP