idea Please change: Attribute Table open constitutes a lock for Python Toolboxes in ArcGIS Pro Ideas

Please change: Attribute Table open constitutes a lock for Python Toolboxes

AlfredBaldenweck — Thu, 14 Dec 2023 17:43:49 GMT

Not sure if this is a bug or if it's intentional behavior, but either way I don't remember it being a problem before we switched to Pro 3.1 (our current version).

See this post for further details Pro 3.1.3: Running an update cursor on a feature l... - Esri Community

To summarize, I had a tool I was running involving an update cursor, and it kept failing because of a lock on the data.

It was in a file geodatabase on my own hard drive, so no one else had access.
The data was only used in this project, which was the only project I had open.
I was not in an edit session.

I eventually figured out that having the attribute table open constitutes a lock on the data, at least in the context of a Python Toolbox. Closing the table immediately solved the issue.

The Python Window doesn't seem to be affected, and I have not tested in Notebooks or Scripting tools in an atbx.

Please remove this behavior.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

MErikReedAugusta — Thu, 14 Dec 2023 17:52:37 GMT

I recently ran into a similar issue trying to run a simple da.UpdateCursor operation in the Python window and wondered why it was so lock-happy. I'm pretty sure I also had the attribute table open.

One thing I've noticed after our team switched from Desktop to Pro is that it seems a lot more lock-happy than Desktop was.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

RandyCasey — Thu, 14 Dec 2023 18:13:51 GMT

@AlfredBaldenweck I am surprised you only ran into this issue now, as for years now I have struggled with trying to figure out when and why any GDB gets locked, file or Enterprise. At least with Enterprise GDBs you can disconnect users, if necessary, but not with FGDBs. There should be comparable functionality for all GDBs to disconnect users and release any locks. Especially those random glitch locks that fail to release and stay present indefinitely until the FGDB owner goes in and manually deletes it.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

AllenDailey1 — Thu, 14 Dec 2023 18:36:30 GMT

I wonder if this behavior is because in Pro you don't have to formally open an edit session, you can just click and start editing in the table? so it's like always in edit mode? not sure. Anyway, yes, it would be helpful if it didn't have a lock when you're viewing the table.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

ScottFedak2085 — Thu, 14 Dec 2023 18:40:44 GMT

Do you have the same behavior when viewing the Attribute Table via a TOC object versus an attribute table via a Catalog object. When you view it through Catalog you get that little database silo in the tab and the RightClick menu says "Open Table". When you view it via an object in the TOC the RightClick menu says "Attribute Table". Is it possible the Catalog option accesses the database directly where as the TOC option accesses some sort of cache?

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

RandyCasey — Thu, 14 Dec 2023 18:57:28 GMT

@ScottFedak2085 I have experienced this issue when the Details Panel is open in the Catalog View and the Table tab is active, which is why I keep the Details Panel closed by default. I can confirm, with an Enterprise GDB at least, that when the Table tab is active, it is running a Select Query, which is locking that table, so as far as I can tell, any time a table is being viewed, a Select Query is being ran, especially if you are scrolling up or down on that table. I would not be surprised to find out that ArcGIS Pro does the same thing to FGDBs. My question would be: why would you lock the table for just a Select Query when the table isn't even in a state where edits are even possible? to paraphrase @MErikReedAugusta: ArcGIS Pro just seems to lock tables as a default action regardless of context. This is really inefficient and frustrating.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

AlfredBaldenweck — Thu, 14 Dec 2023 19:21:11 GMT

@AllenDailey1 I have manual edit sessions turned on, and I wasn't in one. Also, inside the tool, the cursor is wrapped in an Editor object anyway.

@ScottFedak2085 Just checked, this behavior is still present when opening the table directly from catalog, rather than bringing it into a map. Same thing, closing the table fixes any issues.

Can also confirm @RandyCasey 's issue with running it while viewing the table through the Details of Catalog View. The Geography and Metadata tabs are fine.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

PaulPrevedoros1 — Thu, 14 Dec 2023 21:02:49 GMT

I have found similar behavior using notebook. It appears in doing a calculate on almost 2 mill records, Does not release the lock quick enough before the next action. I solved by adding delays

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

AlfredBaldenweck — Tue, 02 Jan 2024 16:38:04 GMT

Another annoying thing along these lines is that, if viewing the file's table in Catalog (even with manual sessions), it'll create a lock file.

Sure, okay.

BUT.

There isn't any way to get rid of this lock file short of closing Pro. Like, could the lock at least be released when I'm no longer looking at that file?

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes - Status changed to: Closed

HannesZiegler — Wed, 10 Jan 2024 15:38:10 GMT

Thank you for your submission. This appears to be a bug. One of my coworkers attempted to reproduce the issue you described but was unable to. Please note that idea Exchanges are not the right place to log software bugs.  However, just because it isn’t the right fit as an Idea does not mean that we aren’t here to help. Bugs and crashes should be logged with Technical Support. Support will help you establish a reproducible workflow that will then help us debug and address the issue.

Note: To contact Technical Support, you need to be an authorized caller. See Why can't I submit cases? (Or, How I became an authorized caller and reported my issue) for more information.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

AlfredBaldenweck — Wed, 10 Jan 2024 15:48:53 GMT

Thanks for the update. Did this get logged as a bug already, or do I need to do that?

In any case, since Pro is so lock-happy, I would not have been surprised had it been an intentional thing.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

HannesZiegler — Wed, 10 Jan 2024 15:56:19 GMT

@AlfredBaldenweck If you are able to, contacting Support would be the best way to get this logged. This way you will also be able to track the status of the bug. However, this does involve talking to Tech Support so a reproducible case can be established (workflow steps, data requirements, machine context, etc.). Without a reproducible case to debug, it is very difficult to address bugs like these.

Re: Please change: Attribute Table open constitutes a lock for Python Toolboxes

AlfredBaldenweck — Thu, 15 Feb 2024 14:04:16 GMT

To update, I submitted a ticket and it's tied to the number of records in the table. If there are 200 or more records, this bug will occur.