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

[Brian Meade]

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/20160912/dcb82d90/attachment.html>