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:

 

Scoreboard.png

 

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.id, call_req.ref_num, call_req.id 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?

 

Regards,

Balram Singh Deswal

Outcomes