Latest Contributions by RoyceSimpson

‎12-12-2016

It's point data and only about 30 points in the whole feature class. Archiving is turned on however, so I'm sure there's more overhead behind the scenes, but I can't imagine there's a ton. I do have verbose logging on and haven't seen anything stand out. In Arcmap, the data draws extremely quickly. As fast as you'd expect for 30 points in a feature class.

‎12-12-2016

I'm running a single cluster (3x 4 core servers) AGS 10.41 server system with web adapter in dmz and having serious performance issues on a feature service shared out to a web app builder app. I can't share it to this post out as it is secured but I've tried disabling security with no positive effect. Just panning and zooming the map can take upwards of 30+ seconds (there are only perhaps 30 features in the entire feature class). If I turn the feature service visibility off in the TOC in my web app builder app, the map pans and zooms properly within a second or two. If I inspect the web traffic with the feature service I notice that there are upwards of 15 separate queries back to ArcGIS Server on every pan and zoom for that feature service. Is that normal? If I view the map service (not feature service) directly in the built in JavaScript viewer in AGS, it is very snappy. Everything is pointing to something being wrong with this feature service but I can't figure out what it is. I've viewed the AGS logs with no errors or warnings present. Thanks for any help. -Royce

‎09-06-2016

Ah, Thanks Kelly. That's exactly what I was trying to get at. Problem solved.

‎09-06-2016

I'm still not following how to configure an app in AGOL then, after having configured it, download the configured app for hosting on my local server. I do see how to download apps prior to configuring them... as pointed out by Derek in the AGOL doc but that doesn't get me what I'm looking for. My workflow is this: I open a web map in AGOL, add a map service, configure the web map the way I'd like it then open it in a "basic map viewer" app template. I go into the app and configure it to have the colors I want, various functionality turn on, etc... Then would like to download that exact app/site to my local server for hosting locally. I don't want to simply go back and download the basic viewer from github as that zip doesn't have any of the configurations that I saved in the hosted app. I want to download the hosted, configured app. Thanks, -Royce

‎09-06-2016

I'm having an issue with an Oracle SDE based map service feature layer query operation returning back incorrect "sum" statistic values. The issue seems to be related to archiving being enabled on the feature class and the map service query returning a sum for all the records in the feature class, which if archiving is enabled, is far more records than actual features in the feature class. If I turn off archiving, the sum operation works correctly, that is, if I have 5 points in the features class with a number field called "testnumfield" and each one has that field value populated at the number 10.... the sum would be 50. If I go in and edit that feature class and change one of the values to 20... The sum operation should return 60 but in fact returns 70, which is the original 50 + the new 20. Since archiving retains a history of the values of fields, it seems that this REST endpoint "sum" operation is erroneously taking into account all those values and not just the values of the current state of the feature class. See below. For simplicity, I calculated all the values of "testnumfield" all back to 0, but they have been calculated to various values over the past few days. The first link shows that no features have a "testnumfield > 0". However, the second link, on the same map service/feature layer, performs a "sum" on that field. The result should be 0, since no features have a value greater than 0 for that field. But the result is a number much bigger than zero. The number actually is reflecting all the values that have been given to those points over the past few days, even though they are all currently calculated to 0. I've verified this by opening the raw Oracle tables in PL SQL Developer and examining the attribute table. All the archived records and associated "testnumfield" values are there. Interestingly, I've tried this same test via hosted map service in AGOL with no issues. Either ArcGIS Server/AGOL is doing something differently or this is a database specific issue and AGOL and esri ArcGIS Server uses SQL Server or some other backend DB. First link: Select all features with a "testnumfield" value greater than zero. Query: GIS.testPoints (ID: 0) Second link: Sum all the values of "testnumfield" for the same point feature class. The result should be 0. The result of "100" reflects archived values for previous edits to the "testnumfield" for those features. Query: GIS.testPoints (ID: 0) I currently have a ticket in with esri on this issue but it's been stuck at "we can't duplicate this issue". Since they are not testing this on their end using Oracle, that is not a surprising answer. This is a critical function for me to be able to perform as our whole incident management mapping website depends on Operations Dashboard and key "sum" values for structure damages. The "gauge" widget uses the exact sum operation presented above in the first link. Any help would be greatly appreciated. Much Thanks, -Royce

‎09-06-2016

I echo Jeff's comments and question.

‎09-02-2016

Thanks Derek. I did look at that page but it doesn't seem to address what I'm trying to do, but perhaps I'm not reading the page right too. Everything on that page refers to downloading the configurable app, getting it setup locally and then configuring it. I've already created and configured and app that is being hosted in AGOL. I'd like to download that source, with all the configurations I've already made to it and deploy it locally.

‎09-02-2016

I've created a configured mapping app in AGOL. Can I then download the source files for hosting locally or do I need to download the app first prior to any configuring online?

‎08-12-2016

Voted.

‎07-25-2016

The trigger seems to be the right solution. I'm able to edit our point data (column A and B) in AGOL/Collector, then have a separate "viewer" AGOL web map that shows the calculated column C... works like a charm. We are using an trigger in Oracle to perform the formula calculation on Column C such that when Column A or B get updated with a new value, Column C is calculated and populated.

‎07-21-2016

I've got one other possible play here. My DBA has created an Oracle trigger that will update columnc with the derived value from columns A and B. In Arcmap at least, things look good. I can update either or both of columns A and/or B and Column C automagically reflects the update and math formula. Will update here with the results.

‎07-21-2016

And yet another option... GeoEvent Processor. Could perhaps rig up a trigger such that every time data comes in via the feature service, run a calc on that columnC. Not sure if GeoEvent Processor does that sort of thing but I guess it's worth investigating.

‎07-21-2016

Here's the other option we are looking at. Just add this "columnC" to the point feature class and have one of us GIS people on the hook to calc that field whenever our customer needs it calculated... which could be multiple times a day for weeks on end. Yay! Simple, totally dumb but.. simple.

‎07-21-2016

Tanya. I'm actually starting to think that route as well. Something like building a geoprocessing service that has the calculation built in and the result is the value we need. Then make a button the desktop that the user would click and a web page pops up with that result. Ugh. That's just super clunky (as you say), inelegant to the extreme and just plain sad that there is zero way to get this to work natively within "the platform". I've asked our esri rep and other folks and am shocked that this isn't an issue that GIS folks run into every day. There are so many cases where you have people collecting data but that data isn't usable until some formulas and such are run against it. To rely on manual field calculations to achieve that just seems dodgy as all get out.

‎07-21-2016

Attribute Assistant won't work. That requires a person to be in Arcmap to run the tool. Any other ideas?

Online Status	Offline
Date Last Visited	‎03-24-2021 06:29 PM

My Ideas

Latest Contributions by RoyceSimpson

Re: How to troubleshoot poor feature service performance?

How to troubleshoot poor feature service performance?

Re: After I create a configured app in AGOL, can I download the source code?

Re: After I create a configured app in AGOL, can I download the source code?

Issue with map service REST query "sum stat" with Oracle/archiving enabled

Re: How to publish a service from ArcGIS Pro to ArcGIS server?

Re: After I create a configured app in AGOL, can I download the source code?

After I create a configured app in AGOL, can I download the source code?

Re: How do I sum the values in a field in ArcGIS Pro?

Re: I'm dead in the water if I can't somehow create a "virtual column".

Re: I'm dead in the water if I can't somehow create a "virtual column".

Re: I'm dead in the water if I can't somehow create a "virtual column".

Re: I'm dead in the water if I can't somehow create a "virtual column".

Re: I'm dead in the water if I can't somehow create a "virtual column".

Re: I'm dead in the water if I can't somehow create a "virtual column".

Options for an Embed Web Map with Time Aware URL P...

ArcGIS Server "image server" error

Re: How do I sum the values in a field in ArcGIS P...

Allow Users to Change and Disable Alerts

Re: WAB Dev Edition deployment... fail.