|Attention: DocWiki has reached EOL and will be decommissioned January 25, 2019.|
Archiver: Fixing 30* or D* in Interval columns of Archiver tables
|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
|Associated CDETS #||CSCtn22768|