Our business users just started using the SQL Scratchpad in Viewpoint for their adhoc queries and I've noticed that their sessions remain in the responding state after they run a query. I am not sure why they don't go to the idle state but since they are in responding they never go away. Has anyone else run into this situation?
Thanks in advance for any help.
The request would stay in responding state when the result set contains more than one page of data. This allows the user to access subsequent pages of data without having to execute the query again.
Me too in similar dilemma..Its not going away and stays back in RESPONDING state!!
Appreciate your valuable Inputs.