how can i stop?

[anilkumar]

Hi  all

when i cancelled the report , report will close  but query(data) is running backend Server.

how can i stop this



Thanks & Regards
ANIL K.MARRI

[Sreeni P]

Hi  all

when i cancelled the report , report will close  but query(data) is running backend Server.

how can i stop this



Thanks & Regards
ANIL K.MARRI

it happens all the time, bcoz ur running the report at presentation layer, when u going to Canceling /Terminating  the report from web interface,it can't stop the report query firing on data sources.bcoz that request is parsed through the dispatcher to execute on the data sources

all this happens because  dispatcher acts asynchronous when the requests & responses submitted at a atime.

Guru's correct me if i'm wrong

[anilkumar]

is there any way to stop

[blom0344]

Yes, at the backend itself. You do not state what database you are using , but in general each database will have Governor settings that allow for a certain degree of control

[anilkumar]

 Hi blom0344

Thank u  for help  iam using sybase database, in database where we can set governance,
we can set in framework manager



Thanks & Regards
ANIL K.MARRI

[blom0344]

From a DB perspective your DBA would need to look up on:

http://www.databasejournal.com/features/sybase/article.php/3866671/Using-the-Sybase-ASE-Resource-Governor.htm