<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div>This impacts agent based reports and not just CUIC (can attempt 8.x as well). Reports we know:</div>
<div>Agent Sumary</div>
<div>Agent Not Ready State</div>
<div>CAD email reports</div>
<div><br>
</div>
<div>Best way to confirm if the report error is due to this issue is by running the corresponding SQL query on the UCCX CLI and verifying the error:</div>
<div>
<div><b>admin:run uccx sql db_cra {call sp_agent_summary('2016-09-10 07:00:00','2016-09-11 06:59:59','0',null,'John Doe,Dan Marino','Support',null,null,null,null,null,null,null,null,null,null,null)}</b></div>
<div><b><br>
</b></div>
<div><b>Internal CLI Error: java.sql.SQLException: Overflow occurred on a datetime or interval operation.</b></div>
</div>
<div><b><br>
</b></div>
<div>The issue is triggered when the date is 8th September and later. </div>
<div><b><br>
</b></div>
<div>
<div>
<div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="Calibri">Regards,</font></font></div>
<div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="Calibri">Abhiram Kramadhati</font></font></div>
<div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" face="Calibri">Technical Solutions Manager, CCBU</font></font></div>
<div>CCIE Collaboration # 40065</div>
</div>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<span id="OLK_SRC_BODY_SECTION" style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:bmeade90@gmail.com">bmeade90@gmail.com</a>> on behalf of Brian Meade <<a href="mailto:bmeade90@vt.edu">bmeade90@vt.edu</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, 13 September 2016 at 11:50 AM<br>
<span style="font-weight:bold">To: </span>Anthony Holloway <<a href="mailto:avholloway+cisco-voip@gmail.com">avholloway+cisco-voip@gmail.com</a>><br>
<span style="font-weight:bold">Cc: </span>akramadh <<a href="mailto:akramadh@cisco.com">akramadh@cisco.com</a>>, "<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>" <<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date<br>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Agent Not Ready State report was the big one that hit our clients. It's any report/stored procedure that utilizes the datediff function.
<div><br>
</div>
<div>Anything including a date after September 8th seemed to be an issue.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 12, 2016 at 9:44 PM, Anthony Holloway <span dir="ltr">
<<a href="mailto:avholloway+cisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">So, should this be impacting every CUIC install in the world? Does this impact all reports or just some? For the reports which are impacted, is only when certain date filters are applied, or any filters? Are there any instances where a system
wouldn't be impacted by reportgate? I just ran one random report on a 10.6(1)SU1 system, and I don't see a problem.</div>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 12, 2016 at 7:57 PM, Abhiram Kramadhati (akramadh)
<span dir="ltr"><<a href="mailto:akramadh@cisco.com" target="_blank">akramadh@cisco.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>Hi all, </div>
<div><br>
</div>
<div>There is a cop already available which has been provided to TAC. Only the CAD email reports are yet to be fixed, so we have a fix already there but just formalising it as a cop. We will have one cop released externally which will fix all the reports –
the cop currently available fixes everything apart from CAD email reports. For that, please ask TAC for a manual workaround (there will be one cop very soon with all the fixes). </div>
<div><br>
</div>
<div>A bit of context: </div>
<div>There is a <b>datediff </b>function which calculates the time difference between today’s date and reference date. The reference date hardcoded is 1985-01-01 00:00:00 and starting from 8th September 2016, this difference is coming out to be a length that
cannot be handled by the variable supposed to be storing it. </div>
<div><br>
</div>
<div>This will be fixed and cop will be available. This cop should be installed on both the nodes via CLI and requires no restarts. </div>
<div><br>
</div>
<div>Apologies, I am on travel – was meaning to send a heads-up when this got highlighted. Please feel free to reach out in case you are having challenges. Thank you. </div>
<div><br>
</div>
<div>
<div>
<div><font color="#000000"><font face="Calibri">Regards,</font></font></div>
<div><font color="#000000"><font face="Calibri">Abhiram Kramadhati</font></font></div>
<div><font color="#000000"><font face="Calibri">Technical Solutions Manager, CCBU</font></font></div>
<div>CCIE Collaboration # 40065</div>
</div>
</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:11pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>cisco-voip <<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nethe<wbr>r.net</a>> on behalf of Erick Bergquist <<a href="mailto:erickbee@gmail.com" target="_blank">erickbee@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, 13 September 2016 at 7:30 AM<br>
<span style="font-weight:bold">To: </span>Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>" <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><span><br>
<span style="font-weight:bold">Subject: </span>Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date<br>
</span></div>
<div>
<div>
<div><br>
</div>
<div>
<div>Ran into this Friday. One client reported it then a few others and knew something weird was going on. Called it the 9/9 bug and worked with TAC and they had workaround ready to apply.
<div><span></span><br>
<br>
On Monday, September 12, 2016, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto">
<div>Yup. Affecting our installation of historical reporting. Not just cuic. <br>
<br>
Sent from my iPhone</div>
<div><br>
On Sep 12, 2016, at 3:25 PM, Brian Meade <<a>bmeade90@vt.edu</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div dir="ltr">This issue seems to be affecting everyone.
<div><br>
</div>
<div>Bug ID is <span style="font-family:cambria,serif;font-size:11pt">CSCvb27878 but not publicly visible yet.</span></div>
<div><span style="font-family:cambria,serif;font-size:11pt"><br>
</span></div>
<div><span style="font-family:cambria,serif;font-size:11pt">There is a COP file fix available from TAC that doesn't require a reboot or anything.</span></div>
<div><br>
</div>
<div>I'm sure there's a field notice coming soon. I'm guessing the COP file will be on
<a href="http://cisco.com" target="_blank">cisco.com</a> soon as well if you don't mind waiting.</div>
<div><br>
</div>
<div>More discussion- <a href="https://supportforums.cisco.com/discussion/13118806/cuic-uccx-dataset-status-failed-database-error" target="_blank">https://supportfor<wbr>ums.cisco.com/discussion/13118<wbr>806/cuic-uccx-dataset-status-<wbr>failed-database-error</a></div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>______________________________<wbr>_________________</span><br>
<span>cisco-voip mailing list</span><br>
<span><a>cisco-voip@puck.nether.net</a></span><br>
<span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailma<wbr>n/listinfo/cisco-voip</a></span><br>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</span></div>
<br>
______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailma<wbr>n/listinfo/cisco-voip</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/<wbr>mailman/listinfo/cisco-voip</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</span>
</body>
</html>