topic Re: SDE feature class attributes updated with Python script not displaying in ArcGIS Pro Questions

SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Thu, 26 Jul 2018 19:37:42 GMT

My Python script tool runs from the geoprocessing pane in ArcGIS Pro 2.2, and what it does is create a new point in an SDE feature class and populate attributes. You could say that it is working, but the problem is that the new attributes for the point do not display in the attribute table until I perform more editing (manual, not via the script) on that feature class. The new attributes need to be seen immediately after the script ends.

I use an edit session in arcpy (my SDE feature class is versioned) and within that I do an update cursor for the new attributes. But somehow there seems to be a delay with edits being committed or the row getting updated or the edit session being saved.

Re: SDE feature class attributes updated with Python script not displaying

DanPatterson_Retired — Thu, 26 Jul 2018 23:32:15 GMT

are you using the Editor within arcpy?

Editor—Data Access module | ArcGIS Desktop

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Fri, 27 Jul 2018 14:14:35 GMT

Dan,

Yes, I am using arcpy.da.Editor and arcpy.da.UpdateCursor. And earlier in the code I use arcpy.ChangeVersion_management to set the specific version of the data that I am editing, and I also called arcpy.CreateDatabaseConnection_management to set a connection specifically for that version.

Re: SDE feature class attributes updated with Python script not displaying

ThomasColson — Fri, 27 Jul 2018 16:55:45 GMT

I had a sort of similar case where the solution was to "Disable Caching" on the layer in question: Right Click layer in TOC, Properties, Cache....

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Fri, 27 Jul 2018 18:19:25 GMT

Thanks Thomas, good suggestion, I tried it but it didn't change anything.

Re: SDE feature class attributes updated with Python script not displaying

DrewFlater — Fri, 27 Jul 2018 19:20:27 GMT

Does your script tool have a normal output parameter, or use a derived output parameter?

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Fri, 27 Jul 2018 21:10:33 GMT

No output parameter that I am aware of, although I'm a little confused by the question. The script tool updates data and then ends, no further processing.

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Fri, 27 Jul 2018 21:15:38 GMT

Could this problem be related to my using a feature layer as the input to the Update Cursor (within the edit session)? Would it behave better if I used the original SDE feature class instead?

The reason that I use a feature layer instead of the actual feature class is because I had to change the version of the database, and that tool required a feature layer.

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Fri, 27 Jul 2018 23:44:09 GMT

I got it working!

The feature layer idea wasn't it at all...still using the feature layer, but what did work was actually very simple. At the very end of my script, which is immediately after the StopEditing(True) statement, I added a Try/Except statement - where I added code to change the SDE database connection back to the Default version - since I was finished editing anyway. Maybe it just needed some code at the end to help the edit session complete and the SDE database to refresh, and the specific code I gave it really didn't matter what that was. I'm not sure.

Re: SDE feature class attributes updated with Python script not displaying

Anonymous User — Tue, 20 Jul 2021 21:07:18 GMT

@LeeBrannon1 Hi Brannon,

I am building a script tool using changeversion, have you ever try to create a dropdown list of all the versions in a default.sde?

Re: SDE feature class attributes updated with Python script not displaying

LeeBrannon1 — Tue, 20 Jul 2021 21:37:30 GMT

No, I have not tried to create a dropdown list of sde versions. My experience with changeversion is limited to just the script tool that was the subject of this post.