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

[Abhiram Kramadhati (akramadh)]

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<mailto:cisco-voip-bounces at puck.nether.net>> on behalf of Erick Bergquist <erickbee at gmail.com<mailto:erickbee at gmail.com>>
Date: Tuesday, 13 September 2016 at 7:30 AM
To: Lelio Fulgenzi <lelio at uoguelph.ca<mailto:lelio at uoguelph.ca>>
Cc: "cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>" <cisco-voip at puck.nether.net<mailto: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<mailto: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<javascript:_e(%7B%7D,'cvml','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<http://cisco.com> soon as well if you don't mind waiting.

More discussion- https://supportforums.cisco.com/discussion/13118806/cuic-uccx-dataset-status-failed-database-error
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<javascript:_e(%7B%7D,'cvml','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/20160913/8c1015bd/attachment.html>