Attribute Assistant in the Enterprise GDB Enviroment... Again

1183
7
Jump to solution
11-28-2016 09:31 AM
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos
1 Solution

Accepted Solutions
MikeMillerGIS
Esri Frequent Contributor

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

View solution in original post

0 Kudos
7 Replies
MikeMillerGIS
Esri Frequent Contributor

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?

0 Kudos
JoeBorgione
MVP Emeritus

Extension is on: Check

Dynamic Table named accordingly: Check

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

That should just about do it....
0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos
MikeMillerGIS
Esri Frequent Contributor

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

0 Kudos
JoeBorgione
MVP Emeritus

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.

That should just about do it....
0 Kudos
MikeMillerGIS
Esri Frequent Contributor

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

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos