topic Re: Attribute Assistant in the Enterprise GDB Enviroment... Again in State & Local Government Questions

Attribute Assistant in the Enterprise GDB Enviroment... Again

JoeBorgione — Mon, 28 Nov 2016 17:31:47 GMT

In https://community.esri.com/thread/185672-attribute-assistant-in-the-enterprise-gdb-enviroment we all figured that the generate id table needs to be in the same enterprise geodatabase, but that the Dynamic Value table can reside in a separate file geodatabase.

I had my Dynamic Table rules working just great while testing everything (feature classes included) in a file geodatabase. Now I've moved things into the enterprise environment and nothing gets updated as it has before.

Originally the 'Table Name' was CommonNamesSample, and resided in the same fgdb with the dynamic table. I have the dynamic table in it's own FGDB and refer to the Table Name as:

database_name.OWNER.feature_class_name

I've also tried simply

feature_class_name

But haven't been able to get any of my rules to work. Being the king of 'missing the obvious' I'm hoping someone can point me in the right direction....

mmiller-esristaff‌

AMuise-esristaff‌

jmward‌

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

MikeMillerGIS — Tue, 29 Nov 2016 01:56:11 GMT

Does the extension turn on? Does the button go green? If so, what is in the log? If not, what is the name of the dynamic value table into the TOC?

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

JoeBorgione — Tue, 29 Nov 2016 12:18:23 GMT

Extension is on: Check

Dynamic Table named accordingly: Check

Log Table: I'll get back to you. (Thanks!)

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

JoeBorgione — Wed, 30 Nov 2016 20:50:53 GMT

Michael- when I run the AA on the file GDB the logfile gets filled up with all sorts of info telling me what's going on. However, this is the extent of the log file when I do the exact same thing (just add a point) in the enterprise database:

Edit Log Started at: 11/30/2016 1:32:56 PM
-----------------------------------------
Process Count: 0
Unwiring the events
#######################################################
vecc2016.VECC.CommonNamesMaster - ON_CREATE
Starting AA
***********************************************************
############ 11/30/2016 1:33:00 PM ################

Setting sort order: Field - RUNORDER
Querying table for Last Value for layer: vecc2016.VECC.CommonNamesMaster
Query Used: (TABLENAME = '*' OR TABLENAME = 'CommonNamesMaster' OR TABLENAME like 'CommonNamesMaster|*' OR TABLENAME like 'CommonNamesMaster|%') AND VALUEMETHOD = 'Last_Value'
Number of results: 0
Querying table for rules for layer: vecc2016.VECC.CommonNamesMaster
Query Used: (TABLENAME = '*' OR TABLENAME = 'CommonNamesMaster' OR TABLENAME like 'CommonNamesMaster|*' OR TABLENAME like 'CommonNamesMaster|%') AND ON_CREATE = 1
Number of results: 0
DONE
---------------------------------------
#######################################################
Wiring the events
Attribute Assistant is being suspended
Attribute Assistant is being turn off
Attribute Assistant is being turn off
**************************************
Closing Log File 11/30/2016 1:33:10 PM

mmiller-esristaff‌

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

MikeMillerGIS — Wed, 30 Nov 2016 21:01:43 GMT

What is in the dynamic value table, vecc2016.VECC.CommonNamesMaster or CommonNamesMaster

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

JoeBorgione — Wed, 30 Nov 2016 21:34:35 GMT

Currently vecc2016.VECC.CommonNamesMaster, as mentioned in my op, I started out with CommonNamesMaster. When that didn't work I figured I need the full database name and changed it.

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

MikeMillerGIS — Wed, 30 Nov 2016 23:13:07 GMT

Try just the table name and see what it says in the log.

Re: Attribute Assistant in the Enterprise GDB Enviroment... Again

JoeBorgione — Mon, 05 Dec 2016 20:49:41 GMT

I've used just the table name as per your suggestion and a few but not all of my DynamicValue table rules are working and show up in the log. I'll give it my best shot to iron out why things aren't working at 100%.

As always, thanks for your help-

mmiller-esristaff‌