Select to view content in your preferred language

Interop workbench returns 'No module named psycopg2'

126
1
a month ago
TomGeo
by
Frequent Contributor

I am using sqlalchemy in a Python script that I created in VSC using a clone of the arcgispro-py3 environment.

When I run the code in VSC there is no problem. Now I need to have the code running in the Data Interop Workbench in a PythonCaller, and that's where I am facing 

Python Exception <ModuleNotFoundError>: No module named 'psycopg2'

I went to check the Package Manager in ArcGIS Pro to check if the clone is set as the active environment and if I in fact have psycopg2 installed. Here a screenshot of the installed module

TomGeo_0-1744105623567.png

and here the sqlalchemy

TomGeo_0-1744105742915.png

 

Can I get some help why I am facing this issue, if the module is installed?

- We are living in the 21st century.
GIS moved on and nobody needs a format consisting out of at least three files! No, nobody needs shapefiles, not even for the sake of an exchange format. Folks, use GeoPackage to exchange data with other GIS!
0 Kudos
1 Reply
BruceHarold
Esri Regular Contributor

Tom in the Workbench application, open the Tools menu and in the Translation options set the Python compatibility to agree with Pro - the option named "Esri ArcGIS 3.11" or similar, depending on version.

0 Kudos