Select to view content in your preferred language

Problem with export feature class inside Postgres

876
7
10-11-2024 10:16 AM
PatrickAvanesians
Emerging Contributor

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.

0 Kudos
7 Replies
George_Thompson
Esri Notable Contributor

Where are you exporting to?

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

--- George T.
0 Kudos
PatrickAvanesians
Emerging Contributor

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"

0 Kudos
George_Thompson
Esri Notable Contributor

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?

--- George T.
0 Kudos
PatrickAvanesians
Emerging Contributor

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

0 Kudos
George_Thompson
Esri Notable Contributor

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

--- George T.
0 Kudos
PatrickAvanesians
Emerging Contributor

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"

0 Kudos
George_Thompson
Esri Notable Contributor

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

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

--- George T.
0 Kudos