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

Enhance error when connection is broken by a SQL Server issue during import #143

Open
PiJoCoder opened this issue Mar 17, 2022 · 1 comment

Comments

@PiJoCoder
Copy link
Contributor

Enhancement: When SQL Nexus runs and hits an AV on the SQL Server side, the connection may be broken and SQL Nexus will get this type of error.

ExecuteReader requires an open and available connection. The connection's state is closed

image

Could there be possible ways to improve the error (bubble some more information from SQL Server up) so that it is clear to the user what happened .

@gambit9009
Copy link
Contributor

When we start looking into this, consider also timeout exceptions. Some SQL Nexus might run a long time and then timeout, probably during the end crunch stages. The data is in the tables. Is there a good/esay way to restart the analysis after import? Is there a better way to catch timeouts, and maybe with a switch or Settings, retry the query that got the timeout? Either by swtich or Settings or with an error messagebox, offer to extend the execution timeout and retry instead of just dying?

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

No branches or pull requests

2 participants