Latest Contributions by AllenScully

We have a fairly straight-forward GeoEvent service that recently stopped working.  Essentially the service takes an input table that has geometry stored as a string, and writes to a polygon feature class (using a field calculator on the geometry string field).   These polygons are then used as geofences in a separate GeoEvent service. However something has caused this to stop working - I cannot get the service to write to the feature class any more.  No configuration changes were made, nor schema changes to any table/FC involved.  I've tried different versions of the output feature service (new services w/ new, empty feature class) - multiple restarts of the service and full server reboots (it's dev environment) - no change.  - We are running Enterprise 10.5, and I have installed the patch for GEP (GeoEvent-10.5-Patch1) to not avail.  - The service WILL write to json output successfully, so it must be related to the output (Update a Feature).  - The Monitor shows that the correct # of records are sent to the output, but nothing gets written to the feature service.  - There are 2 errors I see in the logs:        1) Error Code 400 - Error while writing to feature service xxxx. Error: Unable to complete operation > Operation rolled back...       2) com.esri.ges.fabric.internal.ZKPersistenceUtility > KeeperErrorCode = ConnectionLoss for /geoevent/config/clusters/default/arcgisServerConnections....(much more here that I can't intelligently decipher).  I've checked to Default connection in the data store, and all appears ok there.   I'm stumped after 2 days of trying to track this down.  Likely will open a ticket, but figured I'd ask wiser more experienced heads than myself first.   ... View more

Question very similar to this one: https://community.esri.com/message/599770?commentID=599770#comment-599770?q=Update%20Hosted%20Datastore%20features%20wit…  But for a feature layer hosted in Enterprise/Portal datastore. I have set up the connection to our Portal site in the data store section of GeoEvent.  I go to create an output (Update a Feature) and the connection works - I can see my content there, and select the hosted feature service (it has just one layer) in the 'Service Name' box with no issues:  <MyHostedLayer> (FeatureServer) What I can't do is select the Layer in the next box - The drop down is empty, so I can't create the Update a Feature output.   So - is this possible?  Is there a different Output I need to use when updating hosted data (we are using regular PG Datastore for our hosted stuff in Portal).   And does it matter that for now our GeoEvent instance is NOT part of our Enterprise instance that contains our Portal site? Thanks -  Allen https://community.esri.com/message/599770?commentID=599770#comment-599770?q=Update%20Hosted%20Datastore%20features%20with%20GeoEvent ... View more

We have an editing web app under construction that will allow Fire Dept. staff to quickly enter hydrant inspection results on a mobile device (VPN connection to our network since we're using Portal). We have the actual feature service that will be edited published on a web-tier secured server and added to Portal as a feature layer ( I have found web tier is a better for editor tracking credentials to flow through - but if someone has tips on other options, I'm all ears). The issue is that the web tier secured layer asks for credentials a second time (in addition to the users logging in to Portal which is expected and fine w/ users).   I seem to recall one can change a setting in IIS that impacts this behavior - possibly disabling anonymous authentication?   The net goal here is to have the web tier server read the Portal credentials the user signs in with to avoid 2 sign ins (both the Portal site and web tier server use AD). I know for single sign-on we have modified settings in browsers on individual machines, but this would be prohibitive in this case Thanks -  Allen ... View more

Here's a fun one.   We are building an application that uses Geoevent to poll a map service for features (permits in this case), geotag the permits with a geofence, and write the output to a new feature class. The problem we are having relates to the 'Get Incremental Updates' property and the way our permit data gets updated. I really want to set the GEV Service to poll every 5-30 minutes (doesn't need to be 'real time') and only bring over new OR modified records.  My understanding is that this is what 'get incremental updates' does (at least for new features).   The problem we have is that nothing gets picked up at all when we set 'Get Incremental Updates' to 'yes'.  My concern is that because our permit data gets truncated/appended every night, the objectids get shuffled as part of that process, thereby rendering the Get Incremental Updates option powerless to do what it's designed to do.   Just wondering if that's the correct interpretation of this functionality. Thanks -  Allen ... View more

Having a difficult time with what should be a simple task -  In a python script, i'm trying to write records from a view in an SDE database (sqlserver) to either a table or feature class (whichever works - the idea is to write a set of records to an table/FC that serves as an archive, with a date marking the date of the run time for the script) I've tried CopyRows, Append, ArcSDESQLExecute - all fail, for a variety of reasons - geometry type not supported (Append) or an error relating to being unable to insert NULL values into OBJECTID column - fair enough but my understanding is that because the target table is registered with the database, and would automatically generate an OBJECTID (this is for ArcSDESQLExecute method with an 'Insert' SQL statement).   My hunch is something is not right with the view (the 'source' data) - but am looking for suggestions/experiences around working with views in Arcpy tools in a python (not desktop ArcGIS) environment. Thanks -  Allen ... View more

I'm wondering if anyone can help with the syntax (or confirm that it can be done) to reference an SQL table that's in a non-spatial database in a python script In my case I'm trying to append from this table into an SDE table.  I need the field mapping, because there is an ID field in the source table (non-spatial) that needs to be preserved and by default it treats it as an object id field, so it changes every time the job is run, which is a problem.  So it is mapped to the correct column in the target (SDE) table.   The connection to the SQL non-spatial database is fine in ArcMap, and I can run the append tool without issue.  Whne I grab the python snippet, no matter how I modify the table name/path, the Append_management section fails, saying 'Cannot open table...' (the input table). Here's what I have:  (only import currently is arcpy) arcpy.Append_management (inputs="SQLDB.TABLENAME.dbo.users",   *this is what the table is listed as under 'properties' in the catalog window in ArcMap target= SDE_DEV + "\TABLENAME_DEV", schema_type="NO_TEST", field_mapping=....) SDE_DEV is a variable that is the path to the SDE connection file + sde file name to our dev sde database.  I've tried the same methodology for the input dataset, with no luck so far. Gracias -  Allen ... View more

1st day with Enterprise (Portal) 10.6, and the new Ops Dashboard is really nice.  One issue that I had hoped would be resolved is apparently still happening for us.   Basically we have a whole bunch of level 1 users, who have no need, desire, or skills, to do anything in Portal.  So, the idea is that they just have the URL to the dashboard, sign in (we use active directory) and boom, they have their dashboard with essentially no learning curve, or new interfaces to navigate.   However, when a level 1 user goes to the Dahsboard URL, sign-in fails, and they are taken to our Portal homepage.   I'm really hopeful this is something that can be addresses through a security setting in Portaladmin, or on the server (IIS).  This is a deal-breaker for our particular user-base. A little history - using the old version Ops Dashboard, with Portal/Enterprise 10.5, this functionality was fine.  When we upgraded to Enterprise 10.5.1, we noticed that the direct URL to the Dashboard failed to load, just spun indefinitely.  This was a bug that was logged, with the workaround being that if you made the users Level 2, AND made them an administrator, it would open for them.  We balked at implementing this, and waited for 10.6, but after re-building the dashboard in the new environment this morning, the behavior is still happening.  They can get to the dashboard by logging into Portal, finding the group this is shared with, and opening it there.  So it is accessible to them permissions-wise.  Also, a direct link to the WebMap being used by the dashboard works as desired (go to webmap URL, sign in, and you're good). ... View more