I am querying the HDS (Historical Data Server) at a site that has a UCCE system. Looking at the Skill_Group_Half_Hour table, we are seeing some very odd numbers in the AbandonHoldCallsOutToHalf column. The numbers are often correctly zero (0) or small integers, but then we will see numbers in the billions, or negative millions, both of which are not true representations of the Abandon Hold Calls Out.
Can someone tell me what these numbers indicate? Many entries are <NULL> which is fine and expected, but I am unsure what the huge integers mean.
I can't thank you enough for taking the time to read and respond to my post. I truly appreciate it.
In all honesty, this issue is occurring at a remote site on a 3rd party machine. I have no idea of their workflow or how their system is set up.
The majority of the values in the tables we are looking at are fine. The unusual values seem confined to the AbandonHoldCallsOutToHalf column specifically.
Are there any circumstances when this value should be in the billions? Or negative millions? I was wondering if some other value is potentially masked in with the actual value (IE: an error code, which I have seen done before by some programmers).
My initial reaction was to try to simply "filter" values that are blatantly wrong (hard to imagine a skillset going from 0 or 10 Abandoned calls a period to 9,754,234,122) but I didn't want to lose information intentionally.
Again, I want to thank you for taking the time to look into this thread here.
I must admit I am somewhat lacking with respect to the exact nomenclature and specifics in a UCCE installation and administration.
From reading, then re-reading your first sentence, you seem to be implying that the number of Abandoned calls in the field may be correct? I am quite certain the value in the column is not correct. We are getting massive numbers for a skillgroup that otherwise has very little activity. In addition, I will sometimes see this exact number in 2 or 3 separate rows for the same period.
In your second sentence, are you saying that by querying the table, we may be affecting the current call handling environment? We only query historical data tables (the *_Half_Hour ones) that are written to at the end of each half hour period. I don't see how querying this data for previous half hours will have any effect on any current, real time, live systems.
I realize I am the novice and the posters and contributors to this forum at the experts so it's very likely I am asking and phrasing my questions in an unclear manner.
To restate my question in a slightly different manner: We have software that queries the *_Half_Hour tables for historical call center data. A column (AbandonHoldCallsToHalf) in a table (Agent_Skill_Group_Half_Hour) has numbers that are blatantly wrong. These numbers are in the millions, billions or negatives for skillsets that have little or no activity.
Is there anything specific that would cause these blatantly incorrect values?
1) Any query that hasn't a SQL UPDATE statement within will not impact on the data itself.
2) The number might be crazy if negative or cumultative all the calls are timing out on the PG at the same time, if your 3rd Party solution takes the calls out of the ICM monitoring they will remain lingering up until eventually they will expire and timeout, hence a fllod of abandoned events occuring when that value is reached on the PG.
3) Negative would show up expecially in scenarios where the monitoring is lost, are you dequeueing those calls to another system/ACD? If so your call should possibly be marked as disconnected on the ICM side.
From reading the various responses, it seems like the perception is that we are looking at real time data, or we are actively involved in the call routing process.
We are specifically looking at the *_Half_Hour tables on the HDS (Historical Data Server), for example, the Call_Type_Half_Hour table. My understanding is that at the end of every half hour period, the statistics for the previous half hour are accumulated and deposited in the table.
I may be wrong in my assumption, but I can't imagine our reading from this table having an effect. This is a table detailing what has happened in the past.
So, phrasing another way. I am quite certain that -469753344 (that's a negative there) calls were not Abandoned from a Skill_Group during a half hour period when nothing else was happening in that group. Any ideas?
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.