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: <bmead...@gmail.com<mailto:bmead...@gmail.com>> on behalf of Brian Meade
<bmead...@vt.edu<mailto:bmead...@vt.edu>>
Date: Tuesday, 13 September 2016 at 11:50 AM
To: Anthony Holloway
<avholloway+cisco-v...@gmail.com<mailto:avholloway+cisco-v...@gmail.com>>
Cc: akramadh <akram...@cisco.com<mailto:akram...@cisco.com>>,
"cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>"
<cisco-voip@puck.nether.net<mailto:cisco-voip@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-v...@gmail.com<mailto:avholloway+cisco-v...@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)
<akram...@cisco.com<mailto:akram...@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-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>>
on behalf of Erick Bergquist <erick...@gmail.com<mailto:erick...@gmail.com>>
Date: Tuesday, 13 September 2016 at 7:30 AM
To: Lelio Fulgenzi <le...@uoguelph.ca<mailto:le...@uoguelph.ca>>
Cc: "cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>"
<cisco-voip@puck.nether.net<mailto:cisco-voip@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
<le...@uoguelph.ca<mailto:le...@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 <bmead...@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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
