topic Re: ArcGIS Pro 3.1 issues with Postgres 14.5 in ArcGIS Pro Questions

ArcGIS Pro 3.1 issues with Postgres 14.5

ckesler_egi — Tue, 07 Mar 2023 22:57:04 GMT

My organization has a need to export table data stored in a file geodatabase to a PostgreSQL v 14.5 database.

Until recently the workflow worked flawlessly from ArcGIS Pro. I recently upgraded to ArcGIS Pro 3.1 and now the workflow fails. I get a useless, rarely used error code - "ERROR 160236 - The operation is not supported by this implementation."

The workflow made use of the Append tool where I was appending to a table in PostgreSQL from a table in a file geodatabase.

I am still able to make the sde connection to PostgreSQL and see the existing tables. My login and schema are same and thus I can make a connection without a server license.

Any ideas as to what could be wrong would be appreciated. Thank you in advance.

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

DanPatterson — Wed, 08 Mar 2023 00:12:20 GMT

160236: The operation is not supported by this implementation.—ArcGIS Pro | Documentation

as indicated, more information is needed since it is rarely seen and your information would help. Did you try following their recommendation there?

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

George_Thompson — Wed, 08 Mar 2023 11:56:16 GMT

Did you upgrade to PostgreSQL 14.x also as part of this process?

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

ckesler_egi — Wed, 08 Mar 2023 15:57:04 GMT

I have not given ESRI feedback yet per the instructions via the error link. I appreciate the suggestion.

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

ckesler_egi — Wed, 08 Mar 2023 16:00:06 GMT

Greetings,

No, I did not upgrade PostgreSQL as part of the process. I have been using v. 14.5 without a problem along with ArcGIS Pro 3.0.2. Is it possible that ArcGIS Pro 3.1 is not compatible with PostgreSQL 14.5?

Thank you,

Christopher

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

ckesler_egi — Thu, 09 Mar 2023 19:43:56 GMT

Problem solved, although I don't know how. After closing my python notebook, closing the project and rebooting, my workflow worked again.

Re: ArcGIS Pro 3.1 issues with Postgres 14.5

Robert_LeClair — Thu, 09 Mar 2023 19:49:46 GMT

When I upgraded to ArcGIS Pro 3.1, I had to upgrade my st_geometry.dll located in the C:\Program Files\PostgreSQL\12\lib directory with a newer version. I've had zero problems with PostgreSQL 12.x using ArcGIS Pro 3.1.

Supported PostgreSQL databases in ArcGIS Pro are here.