How do I kill a HUGE ODBC query from Vantage / Progress 8.03

Yahoo Archive
1
It sounds like you're stuck letting these users go to town on ODBC - ouch, glad I don't have to support that! If they are developing, hopefully you have them going against a test environment that can be restarted without impacting your LIVE users.

If this is going on in LIVE, there was a solution out here a while back about how to put users on a separate server (if not here, then Epicor can provide it). So if you have an Epicor9ODBCUser app server you can just stop / start that one and they only take out their own group.

IMHO - ODBC connections should only be done via read only SQL views (replicated server if you're progress). The people writing those views should be knowledgeable enough about indexes, joining, proper data to use, etc. I had a report here that a user would kick off Friday night before leaving so she had the data Monday morning, took about 20 hours to run. I put in the proper joining, used grouping on the server and she was able to run it interactively. Just because people can get a report out of the system doesn't mean it's efficient...


[Non-text portions of this message have been removed]
2
Vantage gurus,

I've got a few people creating Vantage ODBC Crystal reports that occasionally the users will attempt an ODBC query against our database that appears to be too strenuous or complex that it causes our server to slow down to a crawl and most of the time crashing Crystal Reports. I'd like to know that when this occurs, is there an easy way to "cancel" the ODBC request against the server or reset something that can quickly fix this? Normally, we've been downing the server completely and bringing it back up which fixes it but I'd like to not have to do that if at all possible. Any help would be appreciated. Thanks...

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...




[Non-text portions of this message have been removed]
3
Forgive me for not knowing how, but if you're SQL I've seen it done.
Progress I'm not sure.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Wed, Jan 9, 2013 at 12:43 PM, Mike Abell <mabell@...> wrote:

> **
>
>
> Vantage gurus,
>
> I've got a few people creating Vantage ODBC Crystal reports that
> occasionally the users will attempt an ODBC query against our database that
> appears to be too strenuous or complex that it causes our server to slow
> down to a crawl and most of the time crashing Crystal Reports. I'd like to
> know that when this occurs, is there an easy way to "cancel" the ODBC
> request against the server or reset something that can quickly fix this?
> Normally, we've been downing the server completely and bringing it back up
> which fixes it but I'd like to not have to do that if at all possible. Any
> help would be appreciated. Thanks...
>
> Mike Abell
> Systems Analyst / Network Administrator
> Flexial - BOA Group - Cookeville, Tennessee
> Office: 931.432.1853 ext 302
> Mobile: 615.418.3055
> email: MAbell@...
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]