Archiver: Fixing 30* or D* in Interval columns of Archiver tables
From DocWiki
(Difference between revisions)
(New page: {| border="1" |- ! '''Problem Summary''' | CUIC does not show data for the last interval period |- ! '''Error Message''' | Not applicable. |- ! '''Possible Cause''' | Interval tables such ...) |
|||
| Line 21: | Line 21: | ||
|- | |- | ||
! '''Associated CDETS #''' | ! '''Associated CDETS #''' | ||
| - | | | + | | CSCtn22768 |
|- | |- | ||
|} | |} | ||
[[Category:Unified IS, Release 7.5]] | [[Category:Unified IS, Release 7.5]] | ||
Latest revision as of 12:36, 11 February 2011
| Problem Summary | CUIC does not show data for the last interval period |
|---|---|
| Error Message | Not applicable. |
| Possible Cause | Interval tables such as [archiver].[dbo].[t_AgentSkillGroupInterval], [archiver].[dbo].[t_CallTypeInterval] has interval value D* or 30* for the last interval period instead of D or 30.
When Archiver pulls data, it groups data based on interval period. For e.g. there could be multiple 30 min interval groups on a given day if the interval is '30'. The last interval period is called as 'Part Interval'. Such rows has interval data '30*' or 'D*' instead of '30' or 'D'. |
| Recommended Action | If you would like to view part interval data, then change the setting LoadPartInterval=true in archiver.t_Parameter table.
Note: This is a global setting that would affect all interval tables |
| Releases | Release 7.5(x) |
| Associated CDETS # | CSCtn22768 |
