topic Re: None of the Statistics Plugins Work. Same Error for All Tools. in ArcGIS Pro Questions

None of the Statistics Plugins Work. Same Error for All Tools.

ack_ack_ack_ack — Sat, 07 Jun 2025 01:39:19 GMT

Per the title, none of the statistics features work with my data set in ArcGIS Pro 3.4.3

field = self.allFields[fieldName.upper()]

~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^

KeyError: 'BIKE_SHARE.PUBLIC.%BIKE_STATIONS_DATA_3_8_52_305_471.START_POPULARITY'

The data source is a Postgresql table. Database name bike_stations_data. Schema name is public. Database name is bike_share.

It looks like ArcGIS has some sort of cached version of the data in some kind of internal table BIKE_STATIONS_DATA_3_8_52_305_471.

The column of interest is start_popularity. It's an integer.

Same error for Ordinary Least Squares, Generalized Linear Regression, Local Bivariate Relationships.

The tools work like magic in ESRI's youtube videos. Not sure what I am doing wrong.

Is it the case that while one can connect to external databases, nothing actually works with an external database?

Re: None of the Statistics Plugins Work. Same Error for All Tools.

ack_ack_ack_ack — Tue, 10 Jun 2025 02:30:03 GMT

AFAICT, using a PostgreSQL database is mostly broken. Documentation suggests this should "just work." And, it does nothing of the kind.
PostgreSQL is free software and they didn't bother testing *anything* beyond connecting to the database. What a hot mess.
https://pro.arcgis.com/en/pro-app/3.3/help/data/databases/database-connections-in-arcgis-pro.htm

What does work is a query as a data source. Which, somehow, is different than just a connection to a database.

More questions than answers about the ESRI's software development process after this. Yikes!

Re: None of the Statistics Plugins Work. Same Error for All Tools.

ack_ack_ack_ack — Wed, 11 Jun 2025 06:00:08 GMT

Null. Duplicate

Re: None of the Statistics Plugins Work. Same Error for All Tools.

ack_ack_ack_ack — Wed, 11 Jun 2025 06:00:53 GMT

Null. Triplicate