Latest Contributions by HeatherScroggins

‎03-31-2022

Yes! I would love this. Not only to keep things consistent but just for ease of use. It would be one less thing to have to worry about when creating new items.

‎02-25-2022

I figured out the issue. While testing I discovered that edits weren't saving in the web map like I thought they were. When the map was refreshed, the edits that were made were gone. With that in mind, I thought it might have to do with the service. So I first tried to publish a completely new service with the data from the database and I was having the same issues. But I ran into the same issues. I added the new service to a new map and when trying to edit, as soon as the map was refreshed, the edits were gone. So it wasn't an issue with the original service. Since it wasn't a service issue (that I could tell) I wanted to see if I could edit the data in Desktop. So I opened Pro and pulled in the data. The first edit I made I got an error. But at least this time I got a message as to why. The dataset wasn't registered as versioned. I registered the dataset as versioned and then went back to the original web app to test. Sure enough, edits were saving like they should. What I get from this, is that ESRI needs the same kind of messaging when edits fail to save in web apps as they do in the desktop products. I wouldn't have had near as many problems if ESRI would have just told me *why* the edits weren't saving.

‎02-23-2022

I am running into an issue with a service in a wep app on ArcGIS Online. I'm not sure if it's an AGOL issue or an ArcGIS Server issue, so I'm just posting it here. I have a service with three layers in it; a point layer and 2 line layers. I got a call from a user this morning saying that while the two line layers were editing fine, the point layer would not save any changes made to it. When checking the server logs I found that there was a severe level log message saying "Error: Objects in this class cannot be updated outside an edit session [LayerName]." What I find weird though, is that if I try to edit the point feature class in the underlying web map, it will save the edits just fine. I also tried creating a completely new web map and then created a new web app off of that new web map and the point layer will still not edit. I don't know why it will edit fine in the web map but not the app. They are both shared the same (with the organization and the group), I have double checked the Edit widget settings in the app to make sure that the layer is actually editable. I first tried to restart the service and when that didn't work, I republished the layers overwriting the original service. And I still had the same issues. Any advice to fix this issue would be appreciated. If it matters, the service is on a stand alone 10.7.1 ArcGIS Server.

‎02-22-2022

Hi Craig, Thanks for pointing me to those tools. I've run the Diagnose tools for both Metadata and Tables. The tables diagnose tool said that 51 multiversioned tables had orphaned, duplicate, missing, or redundant rows. Some of the tables listed looks like all the rows in the feature class reference nonexistent states. What happens when I run the repair tool? Will it delete all those rows? I can't find good documentation about what the tool does on the backend to fix the issue.

‎02-22-2022

Hi Kim, Yes there is only a single record referring to state 0. Here is a screenshot of the states table from first thing this morning.

‎02-21-2022

I am trying to enable attachments on a feature class in our enterprise geodatabase. However, I keep getting an error that says: 'Failed to create table attachments. Target state not found in the STATES table.' I have done a full compress on the database (removed all versions and compressed down to 1 state) and I still get the error. Any ideas of how to troubleshoot this would be appreciated. Extra notes: database is version 10.7 it is on SQL 2019 I also tried to de-register the dataset as versioned and I got an error trying to do that. It wouldn't let me unregister the dataset as versioned.

‎10-19-2021

Okay, I understand now. So putting those two fields in the Out Fields gets these results. It is pulling from the Place Name table. As for the locator style, it is the General - Gazetteer. When searching for 499 Harris St vs 499 Harris Street I get different results. 499 Harris St matches to Wallis State Bank with a match score of 64.28 and 499 Harris Street matches to Burger Street with a match score of 64.77.

‎10-19-2021

@HenryLindemann unfortunately we can not keep the same name. They are merging several smaller SQL machines into one larger one, so a name change is inevitable. But I'm confused now. Both @ReeseFacendini and @ChristopherPawlyszyn say that just changing the .sde file of the registered Data Stores on ArcGIS Server is enough to get everything working again. But @HenryLindemann is saying that it isn't and that I need to be worried every single .mxd and .aprx that was used to publish services. Which is the correct answer?

‎10-18-2021

I don't think I've ever used this so I apologize if I did it wrong. But I went to the geocoder REST service, clicked the 'findAddressCandidates' at the bottom of the page and then put my address in the Street field. I changes the 'Match out of range' to 'False' and then clicked the 'GET' button. These were the results. It still shows the Wallis State Bank with a match score of 64.

‎10-18-2021

Our IT team is in the process of upgrading/migrating our current SQL databases to a new machine with a completely new name. Since the machine is going to have a new name, all of our GIS connections are going to break. I'm not so worried about ArcDesktop, that's fairly easy to fix (if just a bit tedious). I'm really worried about our ArcGIS Enterprise deployment. We have one Enterprise deployment that includes Server, Portal, and Datastore. And then we have one stand-alone ArcGIS Server. All are 10.7.1. I've tried to search and I guess I'm just not using the correct keywords because I can't find the answers I need. What do I need to change on the backend of ArcGIS Server, Portal, and Datastore once the migration has happened to make sure they are pointed to the correct SQL machine and data?

‎09-01-2021

I noticed this issue when someone pointed out that a lookup app had geocoded an address inside of city when in reality that address was actually in a different city. The address in question was 449 Harris Street. We don't have a Harris Street in our city. It took me some trial and error but I figured out (using just a blank map in AGOL) that for some reason the geocoder was matching to a Burger Street that was in the Place Name locator. When trying 449 Harris St (instead of Street) it geocoded to a Wallis State Bank. You can see pictures of this happening below. My issue is that this doesn't happen in either ArcMap or ArcPro. When locating 449 Harris Street (or St), it pulls nothing like it should. So why is it pulling items from the Place Name locator in AGOL? For reference: it is a geocoding service published from ArcMap 10.7 to ArcGIS Server 10.7.1. It is a composite locator that includes dual range, place name, site address, and street name locators. Edited to add: I figured out that if I check the 'Show all candidates' in the Locate tool in Pro, it does list Wallis State Bank as a candidate for 449 Harris St. But the match score is only 64 which is why it normally ignores it. So the question becomes, why is AGOL ignoring the minimum match score in the geocoder? Update 9/9/2021: I am still having issues with this. Any ideas of how to fix this would be appreciated.

‎06-25-2021

I had not discovered that feature yet. It's been a while since I've had to do major schema changes. But that is super handy. I will have to remember that next time I need to print the fields view.

‎05-18-2021

Alright, that seemed to do the trick. I ended up with: YEAR(last_edited_date)=YEAR(CURRENT_TIMESTAMP) AND MONTH(last_edited_date)=MONTH(CURRENT_TIMESTAMP) AND DAY(last_edited_date)=DAY(CURRENT_TIMESTAMP)-1 And that seemed to do the trick. Thanks!

‎05-18-2021

Hmm.....it didn't seem to like that. I just get 'There was an error with the expression.' As for where my data is stored, it's in a 10.7 enterprise geodatabase on SQL (2014).

‎05-18-2021

I'm trying to figure out a way to query feature classes based on the 'last_edited_date' field so that it shows features that were edited yesterday. So for today (5/18/2021), anything that has 5/17/2021 in the last_edited_date field regardless of time. And for tomorrow, anything that has 5/18/2021. I've been trying to use the 'CURRENT_DATE' function in SQL, but that doesn't seem to be working. Any help is appreciated.

Online Status	Offline
Date Last Visited	a month ago

My Ideas

Latest Contributions by HeatherScroggins

Re: Default Organizational Item Terms of Use

Re: Objects cannot be updated outside an edit session

Objects cannot be updated outside an edit session

Re: Target state not found in the STATES table

Re: Target state not found in the STATES table

Target state not found in the STATES table

Re: AGOL ignores minimum match score in geocoding service

Re: Migrating to new SQL machine

Re: AGOL ignores minimum match score in geocoding service

Migrating to new SQL machine

AGOL ignores minimum match score in geocoding service

Re: Print ArcGIS Pro Fields View

Re: Query 'yesterdays' edits

Re: Query 'yesterdays' edits

Query 'yesterdays' edits

Data Reviewer Version Differences

Re: Objects cannot be updated outside an edit sess...

Re: Query 'yesterdays' edits

Re: Compression Error: Null value is eliminated by...

Re: Connecting to OneDrive in ArcGIS Pro