Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue connecting to the profile database #6

Open
JavideJ opened this issue May 6, 2019 · 3 comments
Open

Issue connecting to the profile database #6

JavideJ opened this issue May 6, 2019 · 3 comments

Comments

@JavideJ
Copy link

JavideJ commented May 6, 2019

I have installed QuESt and run it satisfactorily but I fail when trying to download (for example) an utility rate structure. The next message appears: "There was an issue connecting to and downloading the lists of utilities. Check your connection settings and try again". This is the screenshot of what´s happening. I have my own API key.

Thanks

Captura

@rconcep
Copy link
Contributor

rconcep commented May 6, 2019

Hello,
Could you grab the console/terminal output when encountering this error? Also, could you see if you have the same error when trying to download other data in QuESt Data Manager (e.g., load profile data)?

You may need to configure proxy/SSL verification settings depending on your internet connection. For example, on my corporate network I need to set my proxy settings in QuESt if they are not configured in my Windows environment variables.

@JavideJ
Copy link
Author

JavideJ commented May 8, 2019

Yes, it also happens when trying to download other data. This is what is displayed in the console:

[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.
[WARNING] [RateStructureDM] Hit download retry limit.
[ERROR ] [RateStructureDM] Failed to establish a connection to the host server.

Thanks

@rconcep
Copy link
Contributor

rconcep commented May 8, 2019

OK, based on your first screenshot, the exception based on a simple request (before the API key matters). Here is the URL it is trying to grab:

https://openei.org/doe-opendata/dataset/53490bd4-671d-416d-aae2-de844d2d2738/resource/500990ae-ada2-4791-9206-01dc68e36f12/download/iouzipcodes2017.csv

I'm assuming if you put that into a browser it'll work fine.

The exception you are getting is from a requests.ConnectionError:

In the event of a network problem (e.g. DNS failure, refused connection, etc), Requests will raise a ConnectionError exception.

You can try this code snippet in Python which is what is throwing the exception:

import requests

with requests.Session() as req:
    URL_OPENEI_IOU = https://openei.org/doe-opendata/dataset/53490bd4-671d-416d-aae2-de844d2d2738/resource/500990ae-ada2-4791-9206-01dc68e36f12/download/iouzipcodes2017.csv
    http_request = req.get(URL_OPENEI_IOU,)

You'll probably get the exception and probably more detail about what is causing it. I suspect that you will need to supply some arguments to req.get() to get the request to work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants