Latest Contributions by NathanKoski

‎05-28-2019

We recently deployed an ArcGIS Online app made in web appbuilder for our customers to help communicate electric power outages. The map is viewable to the public. (see link: https://allete.maps.arcgis.com/apps/webappviewer/index.html?id=cdbd5b27e6e94d8b81091b1fe04bc67b) We have received feedback from a few customers that the ETR (Est. Time to Restore) and Date Off Fields are showing incorrect times which are several hours in the future. When I investigated I realized that they were seeing the times displaying using the UTC timezone, and not the Central US Timezone timezone that all our data is published in, and so all the timestamps are appearing to them as +5 hours. The feature service was configured when it was created to be in the Central Timezone. During testing, we noticed during testing that the time fields will display in whatever timezone the viewing device is using, so we have hypothesized that the customers reporting this error must have something interfering with the map's ability to detect their timezone, and so the map is defaulting to UTC. Getting more detail on the devices from the customer is a challenge, and not likely to happen. Is there a way to change the app, map, or feature service so that all times will always display in the Central Timezone? We do not have any customers outside of Central Time, and so having the timestamps altered automatically like this simply generates more confusion. Thanks!

‎03-26-2019

Hello, I have two feature/map service layers which are connected via a relationship class. Is there a way to query all of the related records of a layer, without going through and entering each objectID into a list? I tried using a wildcard (*) but it just returns zero results. For reference on what I am trying to do: Query Related Records (Map Service/Layer)—ArcGIS REST API: Services Directory | ArcGIS for Developers Screenshot attached as well. Thanks!

‎02-05-2019

This solution worked perfectly. I set the recycle to happen at 8:30pm to ensure that the reconcile job had fully completed, and the gap trap processor, which is used for data check-ins, in the geoevent service shows data stopping at 8pm as excepted, but returning through the input at 8:30pm. Thanks for your advice! Nate

‎02-04-2019

Hi Stefan, Thanks for the reminder to check the ArcGIS Server Log Error: Failure to access the DBMS server [ORA-01012: not logged on Process ID:*** Session ID: *** Serial number: ***] [GISADM.GEO_OMS_ORDER_UPDATES]. Is the error I receive. GEO_OMS_ORDER_UPDATES is the database table. This appears to only affect the non-spatial table, as I never see an error from the Point feature that is attached to this feature service, which is in the same database. After 12:00am this stops. I set the recycle time to be 8:15pm, and so will test this tonight. Thank you for your advice, I will post an update tonight/tomorrow. Nate

‎02-01-2019

We have a table on our ORACLE database, named Order_Updates, which Geoevent is querying on a 1 minute interval using the "Poll an ArcGIS Server for Features." The table is inside of a feature service which is hosted on the GeoEvent's ArcGIS Server, so on the localhost, and it deletes the rows after it finishes its query. The problem is that every night, at 8pm, our database does a Reconcile batch job to move all the updates from that day from Common to Default, which puts a lock on all the tables and features in that database. And every night after 8pm Geoevent is unable to query the table giving this error: com.esri.ges.transport.featureService.FeatureServiceInboundTransport Error while retrieving features from service Cust_Order_Data. Error: Error accessing data store at https://localhost:6443/arcgis/. : 400 : Unable to complete operation.. This continues to appear until exactly midnight, which after the server seems to have no issues performing the input connector's query. I can help aid this process by manually restarting the input connector after which the connections are fine. I am thinking the reason why it works after midnight is that midnight is when Geoevent is set to do its daily backup, and something in that is effectively restarting the connector. I understand that during the 5-10 minutes that the batch job is running, and the lock is placed on the table, that GeoEvent and the feature service will be unable to access it, but why is it that after the batch completes and the lock is removed that it does not automatically restore its connections? Is there some type of behavior with Feature Services that might cause this, or is it a GeoEvent problem? Any input would be amazing because I cannot find any info online regarding this behavior. Right now, if we disable the batch job, the Connectors remain active, but that is not a long term solution. Thanks, Nate

‎11-16-2018

Hi there, I am building a web app and ideally it needs to open at the user's location when they start the app. So far we have the My Location widget set up as an On Screen app, and it works perfectly when turned on/off, however, I have to actually turn the widget on. I was experimenting if there was a way to configure My Location to simply be active on startup. I tried adding the attribute "openAtStart": true to the widgets json config, but it does not work. Is there an alternative method for the map to open and navigate directly to the user's location by default? The app will be mostly used from inside of an iframe, so might it be possible to configure the extent that way? Thanks in advanced.

‎10-24-2018

Hi RJ Sunderman‌ Working with your advice I removed all of the filters/processors from the service. Doing so seems to result is no errors, however, I was mistaken because the errors do happen even if dumping into a csv file. Working under the idea that the original data is completely intact I decided to then to test each processor individually. I learned that when I use the processor Envelope Creator and then use the Buffer on the same data the errors appear. All of the other workflow paths are fine and leave no errors, but when I try and pass my data through Envelope Creator then buffer the envelope it breaks. There is a screenshot attached that shows the broken workflow for you better. Replacing Envelope Creator with Convex Hull Creator fixes the problem. It seems like something is going wrong with how those two processors interact with each other. Is it worth still opening a ticket, or perhaps is there someplace better to submit a formal bug report? The odd thing is that overall the enveloped data seems to be rendering on the map more or less fine... For now, I will simply just use the Multipoint > Convex Hull > Buffer instead as it gains me similar results and no errors. Thanks for your fast replies! Nate

‎10-24-2018

Hi there, When my service goes to output using the update feature process I am constantly seeing a series of errors that come from com.esri.ges.messaging.jms.GeoEventBytesEncoder, the most common are: "null java.lang.NullPointerException" "An unexpected error occurred while attempting to serialize the GeoEvent to a Byte Array. Error: null." "Malformed data. Length is negative: -40 org.apache.avro.AvroRuntimeException: Malformed data. Length is negative: -40 at org.apache.avro.io.BinaryDecoder.doReadBytes(BinaryDecoder.java:336) [18:avro:1.8.2]" "An unexpected error occurred while attempting to serialize the GeoEvent to a Byte Array. Error: Malformed data. Length is negative: -40." (this error is coming as an info type in the log when I have it set to debug, full error is in a screen shot below) I cannot figure out what is causing them at all. During some research, I found that similar errors seem to come from using nesting geoevent definitions, but I am not using nested. The service outputs into a multipoint and a polygon, both give this error. However, it does not seem to have trouble outputting into a CSV file. Inside the CSV file the data looks perfect and shows no problems. I have tried deleting and manually remaking the definition with did not help. The error is not constantly happening, it seems to come and go. I was curious if anyone has experienced this before. The one that is really confusing me is the data length -40 because I cannot figure out how that is possible.RJ Sunderman‌ Thanks!

‎08-28-2018

Hi RJ, Thank you so much for following up, and confirming this for me. Yes, the approach we ended up taking with this service was to change the data source itself. The data source for the geofence points was in an oracle SDE, so I created a spatial view which aggregated all the pointed together using GROUP BY and a ST_GEOMETRY function, which will combine points into a multipoint feature on the fly. From there it is possible to then re-host the spatial view as a new map service, and use field enricher to grab the ORDER_ID geometry as a multipoint. If anyone comes across this and is curious what the Oracle SQL code is, SELECT ORDER_ID, sde.st_aggr_union (SHAPE) as SHAPE FROM GeoFence_SP GROUP BY ORDER_ID The ability to join multiple rows to a geoevent using field enricher is something that I look forward to one day having, as I believe it would be an even simpler fix for several problems we have with Geoevent! Thanks again, for your detailed follow-up, and confirming this with your devs. Nate

‎08-14-2018

Hi all, I am working with a geofence of points, each geofence has a category/name of ORDER_ID/METER_ID. I am processing incoming events which contain ORDER_IDs which match a geofence. I want to use Union to grab all of the geometeries related to that events ORDER_ID and combine them for further processing. I am trying to use Regex to grab the ORDER_ID out of the incoming event and use the events ORDER_ID to match to Fences this is my current regex: ${ORDER_ID}/.* but it does not seem to work. However if I manually enter an order id into the union processor, say 123456/.* then it behaves as desired. I am wondering if I am doing something wrong here, or if Unions cannot use fields in their regular expressions? I cannot find anything one way or the other in any of the documentation. If it is not possible, what might be a way to specify geofences on an event by event basis? Thanks!

‎07-06-2018

It is funny that you should mention it possibly being a permission problem. After briefly discussing Michael Volz‌'s reply we thought perhaps we could just try and take down the Geoevent role from the server to see if that helps. This being a new server, with nothing running yet. Well, it turns out we never actually provisioned/authorized an ArcGIS Server licenses in the first place, just the geoevent one! After authorizing that everything works fine, but I really wish that it would have simply told me it was a permissions problem and not this generic "Internal Error." I feel silly to have not realized this in the first place. Thanks for your help!

‎07-05-2018

It is regarded as a best practice to publish the services and federate the server with Portal, but not required. It depends on what type of load you are going to be handling. So far nothing is running on the Geoevent Server, so that isn't the issue I believe. Also, our dev environment, which is almost the exact same, worked with both systems running on the same machine. (This is a new Test environment.)

‎07-05-2018

Hi there, I have a clean new setup of ArcGIS server 10.6, and I am trying to publish a service to it. I am attempting this via the server manager>manage services>publish service I am able to select my .SD and upload it, however, then I receive the error: " java.lang.Exception: Error while processing request. Internal error. JSON response not set." I am unable to determine the source of the error, and digging through the Windows Events results in nothing. On this server, we also have the Web Adapter setup and configured with trusted CA certs, and with Geoevent Server. I am unsure what this error might be referring to, and I am having a hard time tracing it back to the problem. Any input would be amazing. Best Wishes, Nate

‎06-22-2018

Hi RJ, Thanks for following up, I have read that blog post in detail, and it was quite helpful on a different project. I did consider using the incremental updates with the date and time field, however, I am concerned that it will only create more bugs down the line. Generally, our project goal is to have multiple people being tracked, online or offline. This means that if Person A is out in the field at 4pm and is online, and Person B is out in the field offline at 2pm but syncs their data at 5pm, that Geoevent will ignore Person B's updates because they did not take place after Person A? (If I am explaining the problem right?) Do you happen to know if Geoevent will reset its incremental querying if I delete the past results? Right now the workaround is to receive all updates from the location track layer and to have each event stored in a new feature after Geoevent processes them. Then have the Geoevent use Delete Polled Features option to remove events it has processed off of the location track layer. This feels clunky, but it actually works out pretty well, because it means the location track layer gets cleaned up automatically. It does not solve the issue we are having with events coming in out of order, however, so using spacial filters and geofences end up being really messy... In my above example, I entered/exited a Geofence twice, however, if I use the ENTER ANY filter I get 12 events stating I entered the Geofence. Very confusing! Anyways, thanks for your followup! I hope that someone from the collector group knows why my collector syncs data out of order. Nate

‎06-21-2018

Hi there, I am trying to make use of the location tracking ability of collector to track users using the app and geoevent watches this activity using "Poll ArcGIS Server for Features." So far it works great in online mode, however, when using it in offline mode there is a problem when it goes to sync the location tracking data. All of the location data syncs with correct timestamps and geometry, but the objectid's seem to be assigned randomly to each location track point. Normally this wouldn't be that big of a deal, however, geoevent polls these events in order based on objectid. Which results in my path looking completely wrong in the eyes of geoevent. Attached is a screenshot of the feature with the OIDs labeled. You can clearly see them out of order of what the path was. In online tracking, these results would have their OIDs climbing in order to match their respective timestamps. Is there a way for me to sync my results in the correct order? Is this a bug? Thanks! Nate

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by NathanKoski

Issue with date/time fields not displaying with the correct timezone.

Querying all related records?

Re: Input Connector's getting stuck after a database lock

Re: Input Connector's getting stuck after a database lock

Input Connector's getting stuck after a database lock

My Location widget being active on start

Re: Error when outputting, "Malformed data. Length is negative: -40 "

Error when outputting, "Malformed data. Length is negative: -40 "

Re: Specifying a Event's field when using Union Processor

Specifying a Event's field when using Union Processor

Re: Problem Publishing to ArcGIS Server 10.6

Re: Problem Publishing to ArcGIS Server 10.6

Problem Publishing to ArcGIS Server 10.6

Re: Problem with Location Tracking in Offline Mode

Problem with Location Tracking in Offline Mode

Re: Error when load existing survey

GeoEvent vs Webhook Service

Querying all related records?

Not all values returning when Symbolizing using Ar...

Issue with date/time fields not displaying with th...