Author Topic: Realtime Report-Calls Waiting - Showing negative time values, cannot clear them  (Read 5144 times)

smileyphase

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
I'm experiencing an odd issue - we had to briefly change a system clock at one point, and there may be some calls which have not been removed.

The system is not running in DB mode, so I don't think I can clear it from the queue_log table. How should this be cleared?

thx,
SP

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Do you have such values in the reports or in the realtime screen?

smileyphase

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
It's in the realtime screen

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Ok so just leave as they are. it may be that some calls that were active wehn you changes the clock may have incorrect timestamps, but they should be a very small number.

smileyphase

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
So it doesn't affect reports?
This is very annoying for everyone to see all the time, is there no way to remove those records?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
But did you change the clock JUST ONCE or do you change it all the time?

smileyphase

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
Time was changed once, and then changed back. This is not a routine occurence, and has happened a handful of times in the past few years. We can restrict time changes to after-hours.

SP

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
I think this would be a better choice :-)
I mean, deleting calls leads to improper reporting in any case.

smileyphase

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
    • View Profile
What would be the better choice? Leaving 3 dead calls on permanent display on the supervisor screens and wallboards for all time to come, or removing 3 erroneous calls among the thousands processed daily? I can guarantee those three calls won't affect any business decisions.

Is there no way to remove those calls? Where does the data come from?

Thx!

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Yes absolutely - find the uniqueid of the calls (click on the call detail) and delete all calls with that  uniqueid from the queue_log table.