topic Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines in ArcGIS Pro Questions

ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Wed, 15 Nov 2023 20:31:23 GMT

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

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

George_Thompson — Wed, 15 Nov 2023 20:53:30 GMT

What is the version of the geodatabase and RDBMS flavor / version being used?

Have you updated the Enterprise Geodatabase to Pro 3.2?

You could also run these 2 tools to see if there is any reported errors:

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/diagnose-version-metadata.htm

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/diagnose-version-tables.htm

Do NOT run the repair without a full and verified backup.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Thu, 16 Nov 2023 16:38:27 GMT

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...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Fri, 17 Nov 2023 19:12:30 GMT

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...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

George_Thompson — Fri, 17 Nov 2023 19:54:53 GMT

Getting the version of the geodatabase and RDBMS would be most helpful for any potential troubleshooting.

Have your admin query the SDE_version table and return the info for the geodatabase side.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Fri, 17 Nov 2023 20:07:43 GMT

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

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

George_Thompson — Fri, 17 Nov 2023 20:31:57 GMT

Ok, my hunch may have been correct....... you need to update the version of SQL Server to at least SQL 2016 to be on a supported version of SQL Server (https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm). I would recommend something newer like 2019 or 2022 for the SQL version to get more mileage. I do not think that version of SQL Server has been supported since before Enterprise 10.9.1 / Pro 2.9 in terms of our clients and DBMS combinations.

I would look at upgrading the geodatabase to a newer version: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/upgrade-geodatabase-sqlserver.htm

I would also make sure that you verify any dependencies on the geodatabases to other GIS systems, like Enterprise.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Fri, 17 Nov 2023 20:35:17 GMT

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...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

George_Thompson — Fri, 17 Nov 2023 20:51:43 GMT

We support PostgreSQL also and have had many clients move that direction.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Mon, 20 Nov 2023 13:53:22 GMT

Yes, this might be an issue that will get us to push the move to PostGreSQL sooner then...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

EliasRex — Tue, 21 Nov 2023 05:13:04 GMT

Hello, my organization is experiencing the same error. However, we do have sql server 19 and our geodatabase is at version 11.1. We have ran the diagnose version tables and metadata tables and no errors are reported, however the error message regarding state_id=0 in ArcGIS Pro 3.2 persists. We dont have any other versions aside from default. Any recommendations on how we might fix this?

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

George_Thompson — Fri, 01 Dec 2023 12:50:39 GMT

I am not sure of a specific recommendation. It may be best to contact Technical Support and work with an analyst on this issue.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

joonpark — Tue, 05 Dec 2023 14:41:15 GMT

We also exp. same things with ArcGIS Pro SDK, randomly showing errors , worked fine ArcGIS Pro 3.1 , broken in 3.2

For that reason we rollback to ArcGIS 3.1 ; we have geodatabase / sql server that compatible so we shoulnd't mess with it.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

TanuHoque — Wed, 06 Dec 2023 01:29:54 GMT

hello all,

I just wanted to add a note here.

Drawing Alert is a new feature for ArcGIS Pro 3.2. Drawing alerts—ArcGIS Pro | Documentation

The purpose of this feature is to bring up any issue that Pro internally runs into while drawing layers in the current map extent. Prior to 3.2, these alerts (warnings or errors) were getting ignored and never made the users be aware of these.

With this new feature, now you can be aware of any potential issues in your map's current extent... which used to get unnoticed in previous release.

Therefore, going back to 3.1 or previous releases is not really solving any problems except that they get hidden away.

Please let me know if you have any questions.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Wed, 06 Dec 2023 13:28:00 GMT

@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...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

joonpark — Wed, 06 Dec 2023 14:46:36 GMT

@TanuHoque In our case, once we got "Drawing error" , geometry was disappearing. now we do believe we have compatible geodatabase and versioned table that worked for decades

-so what is the "hidden away" issue ?

-was there mandatory geodatabase upgrade to 11.2 ?

- it's simple , it worked fine 2.x, 3.1 and suddenly broken in 3.2. without clear reason

- i will create support ticket but we need clear guideline on this , as i suspect other will experience same issues

Thanks

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

EliasRex — Wed, 06 Dec 2023 16:48:14 GMT

Same in my case, the geometry completely disappears after the error. Although these drawing errors being displayed are supposed to be a feature of 3.2, I find it fishy that this specific error is happening to others all while nothing appears to be wrong with our databases according to ESRIs own diagnostic tools (diagnose version metadata and diagnose version tables). ArcGIS Pro 3.2 introduced discarding and undoing edits on non-versioned data which makes me wonder if there was a bug introduced. Currently, this issue isn't documented as a bug, and when we opened up a support ticket, support seems hesitant to do so because they can't recreate the issue. Altogether, I think either there is truly something wrong with our databases that the diagnostic tools currently don't catch and we have been fortunate enough to not to receive this error in every previous version of ArcGIS Pro or there is some issue with ArcGIS pro 3.2, which seems more likely to me. As of now, I will probably just revert back to ArcGIS pro 3.1.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Wed, 06 Dec 2023 17:34:38 GMT

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...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

MartinWong1 — Wed, 06 Dec 2023 20:36:03 GMT

I was having this same issue using 3.2 with the drawing errors and the geometry disappearing. Everything would be normal until I started editing and split a line feature but discarded the edit. At that point I would start seeing the notices and the geometry would stop drawing.

I discovered that there is a new option introduced in 3.2 to "Enable and disable editing from the Edit tab" in either a single or multiple (the default) workspace edit session. If I set this to single, hit the Edit button, and select my editing workspace, as soon as I panned and zoomed around I would start seeing the drawing alerts even though everything was still drawing and I had not made any edits yet. These alerts would continuously open and close as I panned around, but the geometry for all of my layers continued to draw. Even if I split a feature and hit the Discard button the geometry did not disappear as it did before. As soon as uncheck the Edit button the drawing errors would stop. However, if I set the editing option to "Multiple workspace edit session", then split and discard the edit, the geometry would again disappear and the notifications would begin to pop up again.

TLDR: Enabling the Editing option "Enable and disable editing from the Edit tab" with single workspace edit session should keep the geometry from disappearing.

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning STATE_ID Error when editing Polylines

PeteJordan — Thu, 07 Dec 2023 15:32:50 GMT

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...