search

pacificclimate / pdp

The PCIC Data Portal - Server software to run the entire web application
GNU General Public License v3.0
1 stars 2 forks source link

Station data portal download error #251

Closed faronium closed 2 years ago

faronium commented 2 years ago

Frank Weber from BCHydro informed me that he is seeing download errors with the station data portal that prevent him from obtaining data. I just tried a download and get the error message:

tmp/qeMwqEew.zip.part could not be saved, because the source file could not be read.

Try again later, or contact the server administrator.

I'm attaching a screenshot. Seems independent of how filters are set.

Screenshot from 2021-09-27 16-36-16

faronium commented 2 years ago

This ties into the issue that we've been e-mailing about regarding the vars_id associated with wrong network. I seem to have caused this error here, but don't know how to go about solving this issue. I can replicate a problem by going through the pdp back end such as the URL https://data.pacificclimate.org/data/pcds/lister/raw/BCH/PNK/ returns:

There was a serious problem while generating the streamed response ('(psycopg2.ProgrammingError) syntax error at or near "Pressure"\nLINE 1: ...SE WHEN vars_id=817 THEN datum END) as Barometric Pressure,M...\n ^\n',) None

faronium commented 2 years ago

Okay, I think I solved this. Sorry for the noise. Issue was that I had put spaces in the net_var_name column of meta_vars for the new variables I created to solve the other problem. Seems this causes the query to fail when it's passed to postgres.