[cisco-voip] UCCX CUIC Reports Stopped Working After Certain Date

Mon Sep 26 10:53:10 EDT 2016

Just to follow up on this, Cisco released a field notice on this with a
link to the updated COP file-
http://www.cisco.com/c/en/us/support/docs/field-notices/642/fn64203.html

On Wed, Sep 14, 2016 at 8:47 PM, Abhiram Kramadhati (akramadh) <
akramadh at cisco.com> wrote:

> Team,
>
> The final cop has been posted and is available with TAC, will be on CCO as
> well. The primary issue is on the UCCX DB and therefore, has the potential
> to impact reporting clients (not just CUIC). If you have any questions or
> challenges, let me know.
>
> Regards,
> Abhiram Kramadhati
> Technical Solutions Manager, CCBU
> CCIE Collaboration # 40065
>
> From: Erick Bergquist <erickbee at gmail.com>
> Date: Tuesday, 13 September 2016 at 12:26 PM
> To: akramadh <akramadh at cisco.com>
> Cc: Brian Meade <bmeade90 at vt.edu>, Anthony Holloway <
> avholloway+cisco-voip at gmail.com>, "cisco-voip at puck.nether.net" <
> cisco-voip at puck.nether.net>
>
> Subject: Re: [cisco-voip] UCCX CUIC Reports Stopped Working After Certain
> Date
>
>
> Also, if you have any scheduled reports those may be stuck or failed (red
> x).  If you rerun the scheduled reports after the fix that are stuck it
> fixes them.
>
> Wallboard servers or dashboards using the report functions effected will
> also be impacted.
>
>
> On Monday, September 12, 2016, Abhiram Kramadhati (akramadh) <
> akramadh at cisco.com> wrote:
>
>> This impacts agent based reports and not just CUIC (can attempt 8.x as
>> well). Reports we know:
>> Agent Sumary
>> Agent Not Ready State
>> CAD email reports
>>
>> 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:
>> *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)}*
>>
>> *Internal CLI Error: java.sql.SQLException: Overflow occurred on a
>> datetime or interval operation.*
>>
>> The issue is triggered when the date is 8th September and later.
>>
>> Regards,
>> Abhiram Kramadhati
>> Technical Solutions Manager, CCBU
>> CCIE Collaboration # 40065
>>
>> From: <bmeade90 at gmail.com> on behalf of Brian Meade <bmeade90 at vt.edu>
>> Date: Tuesday, 13 September 2016 at 11:50 AM
>> To: Anthony Holloway <avholloway+cisco-voip at gmail.com>
>> Cc: akramadh <akramadh at cisco.com>, "cisco-voip at puck.nether.net" <
>> cisco-voip at puck.nether.net>
>> Subject: Re: [cisco-voip] UCCX CUIC Reports Stopped Working After
>> Certain Date
>>
>> Agent Not Ready State report was the big one that hit our clients.  It's
>> any report/stored procedure that utilizes the datediff function.
>>
>> Anything including a date after September 8th seemed to be an issue.
>>
>> On Mon, Sep 12, 2016 at 9:44 PM, Anthony Holloway <
>> avholloway+cisco-voip at gmail.com> wrote:
>>
>>> 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.
>>>
>>> On Mon, Sep 12, 2016 at 7:57 PM, Abhiram Kramadhati (akramadh) <
>>> akramadh at cisco.com> wrote:
>>>
>>>> Hi all,
>>>>
>>>> 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).
>>>>
>>>> A bit of context:
>>>> There is a *datediff *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.
>>>>
>>>> This will be fixed and cop will be available. This cop should be
>>>> installed on both the nodes via CLI and requires no restarts.
>>>>
>>>> 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.
>>>>
>>>> Regards,
>>>> Abhiram Kramadhati
>>>> Technical Solutions Manager, CCBU
>>>> CCIE Collaboration # 40065
>>>>
>>>> From: cisco-voip <cisco-voip-bounces at puck.nether.net> on behalf of
>>>> Erick Bergquist <erickbee at gmail.com>
>>>> Date: Tuesday, 13 September 2016 at 7:30 AM
>>>> To: Lelio Fulgenzi <lelio at uoguelph.ca>
>>>> Cc: "cisco-voip at puck.nether.net" <cisco-voip at puck.nether.net>
>>>> Subject: Re: [cisco-voip] UCCX CUIC Reports Stopped Working After
>>>> Certain Date
>>>>
>>>> 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.
>>>>
>>>>
>>>> On Monday, September 12, 2016, Lelio Fulgenzi <lelio at uoguelph.ca>
>>>> wrote:
>>>>
>>>>> Yup. Affecting our installation of historical reporting. Not just
>>>>> cuic.
>>>>>
>>>>> Sent from my iPhone
>>>>>
>>>>> On Sep 12, 2016, at 3:25 PM, Brian Meade <bmeade90 at vt.edu> wrote:
>>>>>
>>>>> This issue seems to be affecting everyone.
>>>>>
>>>>> Bug ID is CSCvb27878 but not publicly visible yet.
>>>>>
>>>>> There is a COP file fix available from TAC that doesn't require a
>>>>> reboot or anything.
>>>>>
>>>>> I'm sure there's a field notice coming soon.  I'm guessing the COP
>>>>> file will be on cisco.com soon as well if you don't mind waiting.
>>>>>
>>>>> More discussion- https://supportforums.cisco.com/discussion/13118
>>>>> 806/cuic-uccx-dataset-status-failed-database-error
>>>>>
>>>>> _______________________________________________
>>>>> cisco-voip mailing list
>>>>> cisco-voip at puck.nether.net
>>>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>>>
>>>>>
>>>> _______________________________________________
>>>> cisco-voip mailing list
>>>> cisco-voip at puck.nether.net
>>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>>
>>>>
>>>
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160926/76fde114/attachment.html>