Attribute Assistant - Intersecting feature not working from lines to points

1601
5
05-01-2017 04:16 PM
Labels (1)
NicholasKunkel
New Contributor

I have a problem here. While keeping all parameters the same in the dynamic table, I have an intersecting feature rule that is supposed to pull a control number from a gas main to a test location point when a new test location is created on said gas main. On creation of the new feature, the AA is not populating the control number for the test point. However, when creating a service line, using the same rule with the same parameters, it works. This method seems to be working for line to line intersects, but not line to point. Any idea what could be going on here? I have made sure that all layer names, field names, and parameters are good. I have also verfied that the test point is being snapped to the gas main when creating a feature. 

0 Kudos
5 Replies
MikeMillerGIS
Esri Frequent Contributor

Can you activate the log file and post it here so we can see what is going on?  You can also log a tech support call and they can help you trouble shoot the issue.  

0 Kudos
NicholasKunkel
New Contributor

Edit Log Started at: 5/17/2017 1:03:13 PM
-----------------------------------------
Attribute Assistant start editing
Process Count: 0
Unwiring the events
#######################################################
CP_Test_Location - ON_CREATE
Starting AA
***********************************************************
############ 5/17/2017 1:03:30 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1
Number of results: 2
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: CP_Test_Location
FieldName: CPCNTRLNUM_A
ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
ValueMethod: INTERSECTING_FEATURE
On Create: 1
On Change: 0

Checking for Subtype Restriction
Field Name: CORCON Control Number A was found at index: 22
Trying: INTERSECTING_FEATURE
Starting to process rule
Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
Layer Found: Gas_Main_Dec30th_2016
CPCNTRLNUM: at 68
map tolerance: 1.5625000000058
spatial tolerance: 0.00328083333333333
Using Layer: Gas_Main_Dec30th_2016
Searching on Layer
Selected features count:1
Searching on Selection Set
Cursor created
Starting Loop of found features
Checking Class
Different FCs
Setting Value: 801345456
Value Set
Feature count: 0
Option: First
Finished: INTERSECTING_FEATURE
------------------------------------------------
------------------------------------------------
Row Info
Row Number 2
TableName: CP_Test_Location
FieldName:
ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP
ValueMethod: UPDATE_INTERSECTING_FEATURE
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field is not specified, empty, or set for all.
Trying: UPDATE_INTERSECTING_FEATURE
Getting Value Info
Checking values
UP at index -1
Value used UP
Finished: UPDATE_INTERSECTING_FEATURE
------------------------------------------------
DONE
---------------------------------------
#######################################################
Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE
Starting AA
***********************************************************
############ 5/17/2017 1:03:30 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1
Number of results: 1
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: Gas_Main_Dec30th_2016
FieldName: OPERATINGSTATUS
ValueInfo: RETPL|Retired_Gas_Main
ValueMethod: COPY_FEATURE
On Create: 0
On Change: 1

Checking for Subtype Restriction
Field Name: Operating Status was found at index: 65
Trying: COPY_FEATURE
Feature and valueinfo is valid
Splitting up value info: RETPL|Retired_Gas_Main
COPY_FEATURE: Field listed in the Field Name did not change, skipping
Finished: COPY_FEATURE
DONE
---------------------------------------
#######################################################
Wiring the events
Process Count: 0
Unwiring the events
#######################################################
CP_Test_Location - ON_CREATE
Starting AA
***********************************************************
############ 5/17/2017 1:03:54 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1
Number of results: 2
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: CP_Test_Location
FieldName: CPCNTRLNUM_A
ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
ValueMethod: INTERSECTING_FEATURE
On Create: 1
On Change: 0

Checking for Subtype Restriction
Field Name: CORCON Control Number A was found at index: 22
Trying: INTERSECTING_FEATURE
Starting to process rule
Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
Layer Found: Gas_Main_Dec30th_2016
CPCNTRLNUM: at 68
map tolerance: 1.5625000000058
spatial tolerance: 0.00328083333333333
Using Layer: Gas_Main_Dec30th_2016
Searching on Layer
No Selected features
No Selected Features
Cursor created
Starting Loop of found features
Checking Class
Different FCs
Setting Value:
Value Set
Feature count: 0
Option: First
Finished: INTERSECTING_FEATURE
------------------------------------------------
------------------------------------------------
Row Info
Row Number 2
TableName: CP_Test_Location
FieldName:
ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP
ValueMethod: UPDATE_INTERSECTING_FEATURE
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field is not specified, empty, or set for all.
Trying: UPDATE_INTERSECTING_FEATURE
Getting Value Info
Checking values
UP at index -1
Value used UP
Finished: UPDATE_INTERSECTING_FEATURE
------------------------------------------------
DONE
---------------------------------------
#######################################################
Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE
Starting AA
***********************************************************
############ 5/17/2017 1:03:54 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1
Number of results: 1
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: Gas_Main_Dec30th_2016
FieldName: OPERATINGSTATUS
ValueInfo: RETPL|Retired_Gas_Main
ValueMethod: COPY_FEATURE
On Create: 0
On Change: 1

Checking for Subtype Restriction
Field Name: Operating Status was found at index: 65
Trying: COPY_FEATURE
Feature and valueinfo is valid
Splitting up value info: RETPL|Retired_Gas_Main
COPY_FEATURE: Field listed in the Field Name did not change, skipping
Finished: COPY_FEATURE
DONE
---------------------------------------
#######################################################
Wiring the events
Process Count: 0
Unwiring the events
#######################################################
CP_Test_Location - ON_CREATE
Starting AA
***********************************************************
############ 5/17/2017 1:04:14 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1
Number of results: 2
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: CP_Test_Location
FieldName: CPCNTRLNUM_A
ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
ValueMethod: INTERSECTING_FEATURE
On Create: 1
On Change: 0

Checking for Subtype Restriction
Field Name: CORCON Control Number A was found at index: 22
Trying: INTERSECTING_FEATURE
Starting to process rule
Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
Layer Found: Gas_Main_Dec30th_2016
CPCNTRLNUM: at 68
map tolerance: 1.5625000000058
spatial tolerance: 0.00328083333333333
Using Layer: Gas_Main_Dec30th_2016
Searching on Layer
No Selected features
No Selected Features
Cursor created
Starting Loop of found features
Checking Class
Different FCs
Setting Value:
Value Set
Feature count: 0
Option: First
Finished: INTERSECTING_FEATURE
------------------------------------------------
------------------------------------------------
Row Info
Row Number 2
TableName: CP_Test_Location
FieldName:
ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP
ValueMethod: UPDATE_INTERSECTING_FEATURE
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field is not specified, empty, or set for all.
Trying: UPDATE_INTERSECTING_FEATURE
Getting Value Info
Checking values
UP at index -1
Value used UP
Finished: UPDATE_INTERSECTING_FEATURE
------------------------------------------------
DONE
---------------------------------------
#######################################################
Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE
Starting AA
***********************************************************
############ 5/17/2017 1:04:14 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1
Number of results: 1
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: Gas_Main_Dec30th_2016
FieldName: OPERATINGSTATUS
ValueInfo: RETPL|Retired_Gas_Main
ValueMethod: COPY_FEATURE
On Create: 0
On Change: 1

Checking for Subtype Restriction
Field Name: Operating Status was found at index: 65
Trying: COPY_FEATURE
Feature and valueinfo is valid
Splitting up value info: RETPL|Retired_Gas_Main
COPY_FEATURE: Field listed in the Field Name did not change, skipping
Finished: COPY_FEATURE
DONE
---------------------------------------
#######################################################
Wiring the events
Attribute Assistant start editing
Process Count: 0
Unwiring the events
#######################################################
CP_Test_Location - ON_CREATE
Starting AA
***********************************************************
############ 5/17/2017 1:04:59 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: CP_Test_Location
Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1
Number of results: 2
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: CP_Test_Location
FieldName: CPCNTRLNUM_A
ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
ValueMethod: INTERSECTING_FEATURE
On Create: 1
On Change: 0

Checking for Subtype Restriction
Field Name: CORCON Control Number A was found at index: 22
Trying: INTERSECTING_FEATURE
Starting to process rule
Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F
Layer Found: Gas_Main_Dec30th_2016
CPCNTRLNUM: at 68
map tolerance: 1.5625000000058
spatial tolerance: 0.00328083333333333
Using Layer: Gas_Main_Dec30th_2016
Searching on Layer
No Selected features
No Selected Features
Cursor created
Starting Loop of found features
Checking Class
Different FCs
Setting Value:
Value Set
Feature count: 0
Option: First
Finished: INTERSECTING_FEATURE
------------------------------------------------
------------------------------------------------
Row Info
Row Number 2
TableName: CP_Test_Location
FieldName:
ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP
ValueMethod: UPDATE_INTERSECTING_FEATURE
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field is not specified, empty, or set for all.
Trying: UPDATE_INTERSECTING_FEATURE
Getting Value Info
Checking values
UP at index -1
Value used UP
Finished: UPDATE_INTERSECTING_FEATURE
------------------------------------------------
DONE
---------------------------------------
#######################################################
Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE
Starting AA
***********************************************************
############ 5/17/2017 1:05:00 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: Gas_Main_Dec30th_2016
Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1
Number of results: 1
Looping through the rows
------------------------------------------------
Row Info
Row Number 1
TableName: Gas_Main_Dec30th_2016
FieldName: OPERATINGSTATUS
ValueInfo: RETPL|Retired_Gas_Main
ValueMethod: COPY_FEATURE
On Create: 0
On Change: 1

Checking for Subtype Restriction
Field Name: Operating Status was found at index: 65
Trying: COPY_FEATURE
Feature and valueinfo is valid
Splitting up value info: RETPL|Retired_Gas_Main
COPY_FEATURE: Field listed in the Field Name did not change, skipping
Finished: COPY_FEATURE
DONE
---------------------------------------
#######################################################
Wiring the events
Attribute Assistant is being suspended
Attribute Assistant is being turn off
Attribute Assistant is being turn off
**************************************
Closing Log File 5/17/2017 1:05:11 PM

0 Kudos
NicholasKunkel
New Contributor

This is the log file. I am interested in the intersecting feature attempts with CP test location. I got it to work the first time, as you will see in the file. But when I deleted the features and tried again, it did not work. Update intersecting feature works. So do the other methods listed in the log file. I need to find out if our audit extension is interfering with the AA rules. 

0 Kudos
NicholasKunkel
New Contributor

This is the log file. I am interested in the intersecting feature attempts with CP test location. I got it to work the first time, as you will see in the file. But when I deleted the features and tried again, it did not work. Update intersecting feature works. So do the other methods listed in the log file. I need to find out if our audit extension is interfering with the AA rules. 

0 Kudos
MikeMillerGIS
Esri Frequent Contributor

Can you turn off the update intersecting feature rule and try again.  I wonder if there is a loop going on here that is messing up something.  Also, the first one is evaluating the selection set, the other ones are not.  Do you have other mains in the area?  Can you try the Prompt Method to see if it is finding other mains?

0 Kudos