http://docwiki.cisco.com/w/index.php?title=Archiver:_Fixing_30*_or_D*_in_Interval_columns_of_Archiver_tables&feed=atom&action=history 2013-05-22T02:47:19Z Revision history for this page on the wiki MediaWiki 1.16.0 http://docwiki.cisco.com/w/index.php?title=Archiver:_Fixing_30*_or_D*_in_Interval_columns_of_Archiver_tables&diff=37960&oldid=prev 2011-02-11T12:36:45Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 12:36, 11 February 2011</td> </tr><tr><td colspan="2" class="diff-lineno">Line 21:</td> <td colspan="2" class="diff-lineno">Line 21:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>! '''Associated CDETS #'''</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>! '''Associated CDETS #'''</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>| <del class="diffchange diffchange-inline">None</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>| <ins class="diffchange diffchange-inline">CSCtn22768</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|-</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>|}</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Unified IS, Release 7.5]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Unified IS, Release 7.5]]</div></td></tr> </table>

Pperiasa http://docwiki.cisco.com/w/index.php?title=Archiver:_Fixing_30*_or_D*_in_Interval_columns_of_Archiver_tables&diff=37951&oldid=prev 2011-02-10T11:33:39Z

<p>New page: {| border=&quot;1&quot; |- ! &#39;&#39;&#39;Problem Summary&#39;&#39;&#39; | CUIC does not show data for the last interval period |- ! &#39;&#39;&#39;Error Message&#39;&#39;&#39; | Not applicable. |- ! &#39;&#39;&#39;Possible Cause&#39;&#39;&#39; | Interval tables such ...</p> <p><b>New page</b></p><div>{| border=&quot;1&quot;<br /> |-<br /> ! '''Problem Summary'''<br /> | CUIC does not show data for the last interval period<br /> |-<br /> ! '''Error Message'''<br /> | Not applicable.<br /> |-<br /> ! '''Possible Cause'''<br /> | 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.<br /> When Archiver pulls data, it groups data based on interval period. <br /> For e.g. there could be multiple 30 min interval groups on a given day if the interval is '30'. <br /> The last interval period is called as 'Part Interval'. Such rows has interval data '30*' or 'D*' instead of '30' or 'D'.<br /> |-<br /> ! '''Recommended Action'''<br /> | If you would like to view part interval data, then change the setting LoadPartInterval=true in archiver.t_Parameter table.<br /> Note: This is a global setting that would affect all interval tables<br /> |-<br /> ! '''Releases'''<br /> | Release 7.5(x)<br /> |-<br /> ! '''Associated CDETS #'''<br /> | None<br /> |-<br /> |}<br /> <br /> [[Category:Unified IS, Release 7.5]]</div>

Pperiasa