topic Re: Problem with export feature class inside Postgres in ArcGIS Pro Questions

Problem with export feature class inside Postgres

PatrickAvanesians — Fri, 11 Oct 2024 17:16:23 GMT

Hi,

I have problem with exporting table or feature class from ArcPro inside Postgres.

When I export it I get the ERROR 000210: Cannot create output

Anybody know how to fix this problem?

I have the permission to export data to the location and my schema is not locked.

Re: Problem with export feature class inside Postgres

George_Thompson — Fri, 11 Oct 2024 17:43:01 GMT

Where are you exporting to?

The error message points me to the location of the export being the issue.

Re: Problem with export feature class inside Postgres

PatrickAvanesians — Fri, 11 Oct 2024 17:47:29 GMT

Exporting to Postgres. I have sde connection that I use as export geodatabase and I add name to it, something like "C:\\Postgres Connection files\\Postgres Connection.sde\\table_fc_name"

Re: Problem with export feature class inside Postgres

George_Thompson — Fri, 11 Oct 2024 18:00:13 GMT

Ah ok. Thanks for the clarification.

Can you create a new feature class (empty one) in the PostgreSQL database, as a test?

Can you export the same data from Pro into a local file geodatabase?

What version of ArcGIS Pro (also license level) and version of PostgreSQL being used?

What is the version of the geodatabase in PostgreSQL?

Re: Problem with export feature class inside Postgres

PatrickAvanesians — Fri, 11 Oct 2024 18:13:01 GMT

1 - Can you create a new feature class (empty one) in the PostgreSQL database, as a test?

I can create empty feature Class in Postgres

2 - Can you export the same data from Pro into a local file geodatabase?

I can export into local gdb.

3 - What version of ArcGIS Pro (also license level) and version of PostgreSQL being used?

ArcPro Version 3.3.2, Postgres version 12.19

4 - What is the version of the geodatabase in PostgreSQL?

I am not sure about this. I do know how to find this info

Re: Problem with export feature class inside Postgres

George_Thompson — Fri, 11 Oct 2024 20:09:14 GMT

Thanks for that info. Is the issue only occurring with a "single" layer that you are exporting or any layer that is exporting?

If you copy from the fGDB to Postgres, does that work? (I am just trying to see if it is data related).

Re: Problem with export feature class inside Postgres

PatrickAvanesians — Fri, 11 Oct 2024 20:21:08 GMT

I have problem with any layer.

When I try to copy/paste I get this "ERROR 000260: This geodatabase does not support this client or operation"

Re: Problem with export feature class inside Postgres

George_Thompson — Mon, 14 Oct 2024 11:13:29 GMT

Can you confirm the license level of Pro you are using?

What is the version of the Enterprise Geodatabase, query the sde.version table?