AnsweredAssumed Answered

Delay Server Response during Scoreboard Loading

Question asked by Balram.Deswal on Jan 15, 2016
Latest reply on Jan 21, 2016 by Balram.Deswal

Hi Team,


Whenever I log in to the Service Desk 14.1 console for the first time everyday, my scoreboard do not load properly and it gives delay server response time msg for a long time. When I switch between the tabs to load it again, It gives the message as displayed in the following screenshot:




After log out and log in again, it loads properly and does not give delay server response either.


When I check my logs, I see the following log:

A FETCH for the following statement took 102219 milliseconds: SELECT call_req.open_date,, call_req.ref_num, FROM call_req WHERE ( call_req.assignee IS NOT NULL OR call_req.group_id IS NOT NULL ) AND ( call_req.type = N'R' OR call_req.type = N'' OR call_req.type IS NULL ) AND call_req.active_flag = 1 ORDER BY call_req.open_date DESC NULLS LAST



What can I do to load my scoreboard properly everytime?



Balram Singh Deswal