Bug
When using the Psycopg2 module in a Python script with the fetchall() function and then using the tool in a geoprocessing service, the service returns errors the second time.
| Bug ID Number | BUG-000117170 |
|---|---|
| Submitted | October 1, 2018 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.5.1 |
| Operating System | Windows OS |
| Operating System Version | 8 |
| Status | Will Not Be Addressed |
Additional Information
The team extends their apologies as this issue is unable to be reproduced within the current product support cycle on their end. If the issue continues to affect the work in a supported release, please contact ESRI Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024. Refer to https://support.esri.com/en-us/products/arcmap/life-cycle. There are no plans to release an ArcGIS Desktop 10.9, and it is recommended to migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro at https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.Workaround
Use pg8000 and SQLAlchemy. However, there are concerns that this can lead to additional issues down the line based on current experience.
Steps to Reproduce
Bug ID: BUG-000117170
Software:
- ArcGIS for Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App