topic 2.9.5 patch crashing when accessing OLE DB tables in ArcGIS Pro Questions

2.9.5 patch crashing when accessing OLE DB tables

arahman_mdmajid — Tue, 25 Oct 2022 11:46:43 GMT

The process was working fine where we were useing MS Access DB (.accdb) by adding a OLE DB connection and then exporting the table to point features.onto the Map.

However, after applying the new patch 2.9.5, the process is causing ArcGIS Pro to crash. we are able to add the OLE DB connection and able to see the table in catalog pane, however when we are trying to drag and drop the table into the contents or trying to export it, the application is crashing.

Kindly look into the issue and let me know if you need further information to recreate the issue.

Re: 2.9.5 patch crashing when accessing OLE DB tables

Czapiga_Jason — Wed, 02 Nov 2022 15:40:19 GMT

I'm experiencing the same issue. please advise.

Re: 2.9.5 patch crashing when accessing OLE DB tables

NeilFordyce — Thu, 17 Nov 2022 00:38:59 GMT

Same problem here.. installed patch yesterday and now crashing on .accdb linked oledb data

Re: 2.9.5 patch crashing when accessing OLE DB tables

Paul_Adamson — Fri, 18 Nov 2022 15:50:40 GMT

Yes, I'm got the same issue.
I can add an OLE DB Connection and it will list all the tables.
If, I attempt to add one into the project, then Pro immediately crashes.
I have logged a call with ESRI...

Re: 2.9.5 patch crashing when accessing OLE DB tables

Robert_LeClair — Fri, 18 Nov 2022 21:29:07 GMT

Paul - great to hear you've logged a call to Esri Support Services - hopefully they are able to resolve this issue. If you're interested in uninstalling the ArcGIS Pro 2.9.5 patch, you can very easily. Go to your Control Panel, click Uninstall a program, top left is the phrase "View installed updates", click that. Then you can click the ArcGIS Pro 2.9 Patch 5 (2.9.5) item and uninstall that. Hopefully the crashes you're experiencing with the OLE DB connection workflow ceases.

Re: 2.9.5 patch crashing when accessing OLE DB tables

arahman_mdmajid — Fri, 18 Nov 2022 21:45:41 GMT

Robert I am sure that you are already aware of the reason why 2.9.5 patch was released was to deal with a serious crash while modifying symbology, more details at this link

Simply uninstalling the same patch that has made version 2.9 stable isn't a permanent solution. Looking forward to a more permanent solution to the issue.

Thanks

Re: 2.9.5 patch crashing when accessing OLE DB tables

Robert_LeClair — Fri, 18 Nov 2022 21:52:42 GMT

Yes, I was aware of the rationale behind the 2.9.5 patch - thank you! Agree that a permanent solution needs to be created. Currently this is BUG-000153421 - Adding a Microsoft Access Database table to a map from an OLE DB connection in ArcGIS Pro 2.9.5 causes the program to crash. It's currently under review by the team. The issue does not occur in versions prior to 2.9.5 and 3.0 and above.

Re: 2.9.5 patch crashing when accessing OLE DB tables

arahman_mdmajid — Fri, 18 Nov 2022 22:02:23 GMT

Thanks Robert for the prompt response and really appreciate the great effort you guys are putting into providing us the much needed support. 👍🏻👍🏻

Re: 2.9.5 patch crashing when accessing OLE DB tables

DarinaTchountcheva — Thu, 22 Dec 2022 21:36:48 GMT

I a experiencing the same issue but with a SQL Server database.

Can't open any projects that use .odc connection to a SQL Server database and cannot add any tables from such connection.

We cannot move to 3.0 due to breaking functionality and we cannot uninstall the Patch 5 due to the Symbology crash.

Is there a solution for this already?

Thank you!

Re: 2.9.5 patch crashing when accessing OLE DB tables

Robert_LeClair — Thu, 22 Dec 2022 21:48:25 GMT

Darina - with regard to BUG-000153421, I'm seeing that the Tech Review is complete and is "under consideration" for a fix. As stated, this only occurs at ArcGIS Pro 2.9.5. I understand the dilemma you're in with regard to 3.0 breaking functionality and the Patch 5 symbology crash fix. One solution I can think of to get around the not able to open *.aprx's is on a separate machine, have just ArcGIS Pro 2.9.0 on that machine without any updates. Open the *.aprx, remove the *.odc file in the Catalog Pane->Databases and save the *.aprx. Then see if you can open the *.aprx using the ArcGIS Pro 2.9.5 machine. Would that work?

Re: 2.9.5 patch crashing when accessing OLE DB tables

DarinaTchountcheva — Thu, 22 Dec 2022 23:07:22 GMT

Thank you for your reply Robert,

The data that I use from the .odc connection is the main reason for my project. If I remove that data, I have no project. 🙂

I can't move to version 3. I run a lot of Python scripts on the 2 machines that I have available and 3 will most likely break the scripts. Upgrading the scripts will take a while.

I opened a case with ESRI and the analyst suggested to install .Net Framework 4.8.1 and remove patch 5, since I can't upgrade to 3. But, unfortunately, the installation of the framework was blocked with the message that it is not supported on this OS (Windows server 2019), go figure. So, that is not going to work.

I uninstalled patch 5 and I can open the projects.

Since my maps were imported from MXDs, I can, probably make all necessary symbology changes in ArcMap and import the maps to Pro after I am done. Then publish the services from Pro 2.9.4.

Hopefully, there will be a solution soon.

Re: 2.9.5 patch crashing when accessing OLE DB tables

PaulHoefflerGISS — Fri, 23 Dec 2022 18:16:45 GMT

Esri has released numerous bad patches in recent months across ArcGIS products, often pulling the patches and replacing them with fixed patches of the same name/number. In the past sometimes they were named as "B" patches, which was clearer than replacing a bad patch with a fixed patch of the exact same name.

Why hasn't this patch been fixed and replaced, or why isn't there a 2.9.6 patch that addresses this and any other defects/regressions introduced with patch 5?

Re: 2.9.5 patch crashing when accessing OLE DB tables

JoyDRoberts — Wed, 18 Jan 2023 13:45:22 GMT

An additional fun behavior is that in Catalog View, even clicking on the Databases item crashes Pro 2.9.5.

We can't go to 3.0.x because we're a UN shop. Can't go back to 2.9.x because of the symbology bug. So, seems like I have to go back to 2.8.8 (the last stable version I used prior to upgrading) and recommend that all the other users downgrade too? This is NUTS. 😞

Re: 2.9.5 patch crashing when accessing OLE DB tables

PaulHoefflerGISS — Wed, 18 Jan 2023 16:32:55 GMT

I don't know that anything related to this ongoing defect introduced with Patch 5 has been addressed, but have you tried Patch 6 (2.9.6)? Might be worth a shot before rolling back to 2.8.8....

Re: 2.9.5 patch crashing when accessing OLE DB tables

DarinaTchountcheva — Wed, 18 Jan 2023 16:54:42 GMT

I did not find this bug in the fixes for Patch 6.

I escalated the bug and this is what I received from ESRI:

********************************************************************

Bug fixes are addressed in upcoming releases or general patches, or they may be addressed as ad-hoc fixes. Enhancement requests are implemented in upcoming releases.

Updates have been made to the following defect which you are associated with:
BUG-000153421 - Adding a Microsoft Access database table to a map from an OLEDB connection in ArcGIS Pro 2.9.5 or 2.9.6 causes the program to crash.

Status: In Product Plan (Learn More)
Alternate Solution:

Use the following ArcGIS Pro versions as this issue does not occur there:
Versions prior to ArcGIS Pro 2.9.5.
ArcGIS Pro 3.0 and above.

It says it is in product plan, so I hope for a resolution soon (if I understand this correctly).

Re: 2.9.5 patch crashing when accessing OLE DB tables

PaulHoefflerGISS — Wed, 18 Jan 2023 22:37:50 GMT

It sounds like those who can upgrade to Pro 3.0.3 will find resolution to BUG-000153421 that way.

Others could uninstall patches to get down to 2.9.4. Anyone taking the second approach will want to be aware of a significant issue that pushed many users into the bad 2.9.5 patch in the first place:
https://community.esri.com/t5/arcgis-pro-documents/recent-microsoft-net-update-resulting-in-arcgis/ta-p/1221829
There is information about a .NET-specific work-around in that post or the comments of that post that could be used to make 2.9.4 fully functional.

Re: 2.9.5 patch crashing when accessing OLE DB tables

Kniwwel76 — Tue, 31 Jan 2023 14:36:41 GMT

Same for me! 😞

Re: 2.9.5 patch crashing when accessing OLE DB tables

Paul_Adamson — Tue, 31 Jan 2023 15:07:42 GMT

Does anyone know if this has been resolved with version 3 and its associated patches?

Re: 2.9.5 patch crashing when accessing OLE DB tables

Robert_LeClair — Tue, 31 Jan 2023 15:11:50 GMT

Paul - I'm seeing the bug fix is in the ArcGIS Pro Product Plan but do not know when. Hopefully soon!

Re: 2.9.5 patch crashing when accessing OLE DB tables

JoyDRoberts — Tue, 31 Jan 2023 15:38:05 GMT

Unknown, but here's what I experienced after going to 3.0.2 for a few hours:
Copying feature classes (FCs) from Oracle database 1 to Oracle database 2 yielded added fields on my FCs due to domains being set on fields. Since I don't like my data adulterated, and don't have time to undo screwy changes like that (nor do I have time to teach all my users to watch for it and correct it!), I gave up and went back down to 2.8.8.