|
POST
|
First we have an LRS table in SDE and instead of using SQL Manager Studios to update the LRS data, we have linked the table to Access to make it much easier. In old ArcMap, there were 2 registry files that could be used to toggle Caching to allow LRS updates to display the new measures graphically on the fly when changed. This was for all data on ArcMap regardless of project as it affected it as a whole and worked great. In ArcGIS Pro, it seems we have the Cache options on a layer by layer basis. With that, though, I have run into an issue. Issue It seems when updating an LRS measure in the database table in SDE, the data change will show in the attributes in ArcGIS Pro just fine, but Refreshing usually doesn't update the graphical part. The only way I've consistantly found to actually do this is to do the following: i) Original data (Step1 - Show original measures.jpg) a) Make the change in the database table (Step2 - Change a Measure.jpg) Test b) In ArcGIS Pro, Refresh (sometimes a few times) until I see the change in the attributes for that feature (Step3 - Change is shown in Attributes but no change in graphics.jpg) c) Go into the layer's Properties --> Cache and then change it from "Keep the cache between sessions. Automatically clear the cache every x mins" to "Clear cache when the session ends" or visa-versa. (Step4 - Cache showing current Method.jpg & Step5 - Change Cache Method.jpg) d) Press OK and this then redraws the features and displays the correct LRS extents for that feature. (Step6 - Update Now Reflects new LRS Measure Change.jpg) Edit: for some reason I can't put the image here in a spoiler or remove the extra duplicate one. I was hoping that the features would automatically update when there was a change to an LRS measure, but none of the options in the Cache pane does this. I have also tried to find the ESRI tool or code for the type of Refresh/redraw that occurs when I swtich between the two Cache methods above, but I am unable to find the one that those use to redraw the feature to the new measures (LRS - Refresh.jpg). Any ideas on why the Cache isn't working or if not, how I can keybind the Refresh/Redraw that occurs after you switch a Cache method? Unsure if this should be a bug or not? Thanks
... View more
12-20-2023
12:42 PM
|
0
|
2
|
5208
|
|
POST
|
I have tested this myself and it does work. I do still get the errors showing up below, but it doesn't affect the drawing updates which is good. The only thing is I just have to remember to activate the editing session as I used to do in ArcMap with this method as each time you close out of the project and reopen ArcGIS Pro you have to enable the Editing again or else the attribute data is greyed out, but that only needs to be done only one time when you open the project. This has sped things up on my end a lot and very happy you found this...
... View more
12-07-2023
07:32 AM
|
2
|
0
|
6233
|
|
POST
|
For those using versioned editing. My work around is to Reconcile, Post, Reconcile and that updates all my edits. It's annoying, but at least I don't have to exit and go back into the project each time it happens...
... View more
12-06-2023
09:34 AM
|
0
|
0
|
6004
|
|
POST
|
@TanuHoque Though in some cases like mine where IT needs to either upgrade to SQL Server or move to something like PostGres then, rolling back would sovle the issue as it would in my case. The only reason I'm having to use a annoying work-around right now is because I'm enjoying testing out the new Customization feature in 3.2. So I think in some people's cases rolling back may solve the issue if it's like mine with versioned editing on an older SQL Server...
... View more
12-06-2023
05:28 AM
|
1
|
1
|
7691
|
|
POST
|
Yes, this might be an issue that will get us to push the move to PostGreSQL sooner then...
... View more
11-20-2023
05:53 AM
|
0
|
0
|
17138
|
|
POST
|
Thanks George, The database admins are going to discuss upgrading, but have to check out a few things first. I think they one thing was moving over to PostGres from SQL, so maybe that was why it hasn't been updated. They also want to check about any other issues it could impact if they do update it and such. Anyways I passed on the information. Thanks for your help and will let you know if that is in fact the solution if it does get updated to a newer version...
... View more
11-17-2023
12:35 PM
|
0
|
2
|
17167
|
|
POST
|
Hey George, I did get that information for you. Geodatabase Version: 10.6.0 (and can be upgraded and that is in the talks) SQL Server Version: 14.0.2014.8 This might help as well: Thanks
... View more
11-17-2023
12:07 PM
|
0
|
8
|
17174
|
|
POST
|
Update: The issue happened once again after doing the fix yesterday. Instead of Reconciling and Posting it, I just Reconciled the version and it worked. So it somehow has to do with a versioned geodatabase on SDE. Not sure if it's directly related to ArcGIS Pro 3.2 or if it's just a random new issue not related to the new update, but I hadn't seen this error before 3.2...
... View more
11-17-2023
11:12 AM
|
0
|
10
|
17183
|
|
POST
|
Thanks George, I had the GIS database admin to try those tools and they came back with nothing. I then decided to try to reconcile my current version and post it to SDE and this seemed to have worked. I'm no longer getting that issue currently after testing it for some time. So that may have just been the issue with updating to 3.2 and it having a conflict with the current version I was editing of the data. I'll respond if the error does come back, but so far so good. I don't have the versions of the RDBMS or Geodatabase, but the Admin was going to post that for you here, but he had ESRI login issues...
... View more
11-16-2023
08:37 AM
|
0
|
11
|
17205
|
|
POST
|
I've upgraded to ArcGIS Pro 3.2 and found when editing a Versioned Geodatabase located within SDE that I'm now getting this error now: Seems researching it, I'm just finding some information that it could be linked to a corruption of the database somehow or at least something with the linking of the table via SDE. We've run some maintenance scripts as well as I've relinked the entire table as I have noticed that in 3.2 the New Database Connection has changed it's look a little from 2.9. I'm notcing this is happening with several different tools, not just one. Such as creating a new feature, reshapping, etc. So I'm not thinking it's directly related to Editing of the Versioned Geodatabase on SDE. Any suggestions that I or the database side GIS guys can look at to try and resolve this issue? I'm assuming it's from 3.2, but not 100% sure as I haven't worked in this database for a little over 2 weeks, but I did notice it after updating to 3.2 at least... Thanks
... View more
11-15-2023
12:31 PM
|
7
|
81
|
50319
|
|
POST
|
Yes I don't seem to find an option either as the degrees now won't work in say Google like it did with the directional one. I have filtered out the issue anyways in the other program so it will just ignore the degree symbol and direction at least and place the - in the Long for me at least. So the issue is fixed, but still would be nice to have that symbol removed if possible...
... View more
10-23-2023
09:33 AM
|
1
|
0
|
2725
|
|
POST
|
Yes that helps, it does give me almost exactly what I need. Though I still have the degree symbol which I don't want either. Not sure if there is anything I can do about that though? Result: -104.8318135° 39.9715380° Thanks for the location of this though, I forgot to look in the Options in Pro for it... -104.8318135° 39.9715380°
... View more
10-23-2023
09:27 AM
|
0
|
2
|
2728
|
|
POST
|
I want to use the [Copy Coordinates] tool to copy the location in ArcGIS Pro to paste in another program. The issue I'm having is the output in Pro contains the degrees and excludes the +/- signs. This is how it shows in Pro (104.9833292°W 39.7263745°N ) In ArcMap it showed as (-104.9833292 39.7263745), which is the format I want. I have tried to change this in the Coordinate Conversion pane, but using the [Copy Coordinates] tool still outputs it with the degrees and without the - sign. Anyway I can actually get this to copy it in the format I have shown below? I figure there has to be a simple way, but I'm just not having any luck... Thanks
... View more
10-23-2023
07:00 AM
|
0
|
4
|
2813
|
|
POST
|
I have a table that I have created in Access for LRS measures for a small project. I've accessed the table through the "New OLE DB Connection" and using "Microsoft Office 16.0 Access Database Engine OLE DB Provider". When I "Make Route Event Layer", the data displays just fine, however I can't select individual projects. It just selects everything in the new layer, but doesn't even show they are selected in the Attribute Editor or in the Attributes pane at all. If I put that exact same Access table on SQL (via SQL Server Management Studio 19.1), and then link the table into Pro via that method, everything works the way it should and I can select individual projects in that table and have the data for that displayed. Does anyone know why this would be only occuring with linking the table through Access and not SQL? Am I not linking the Access table correctly eventhough it does display the data? Confused here...
... View more
10-09-2023
02:42 PM
|
0
|
0
|
877
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 12-05-2025 05:54 AM | |
| 2 | 12-11-2025 10:19 AM | |
| 2 | 12-11-2025 12:39 PM | |
| 2 | 12-04-2025 01:12 PM | |
| 6 | 11-17-2025 08:42 AM |
| Online Status |
Offline
|
| Date Last Visited |
03-12-2026
07:12 AM
|