[cisco-voip] CUIC/UCCX 10.6 Report Scheduler message

[Gurpreet Singh Kukreja]

Hi Ed,

Not sure if this has already been resolved for you or not, but here's what
i recommend:

- Run the following command on your CCX node and find out if there are any
reports for which the status does not show as READY, They will all be in
either DELETE, ADD or UPDATE state. If yes, then you'd need to delete those
specific entries, but first, here's the sql command to check the status:



*run sql select id, scheduledreportname, operationflag from
cuic_data:cuicscheduledreports*
This is sample output for how it should look under the command;

admin:run sql select id, scheduledreportname, operationflag from
cuic_data:cuicscheduledreports
id                               scheduledreportname operationflag
================================ =================== =============
8E5B3E93100001500000000B0AC5BFE7 TEST                READY


*- *Now, to remove the unnecessary entries, use the below syntax where
"xxx" is the "id" from the output as shown above, but run it only for those
scheduled reports which show status other then READY:



*run sql delete from cuic_data:cuicscheduledreports where id = 'xxx'*

HTH
Gurpreet




On Thu, Sep 3, 2015 at 9:30 AM, Ed Leatherman <ealeatherman at gmail.com>
wrote:

> Hello
>
> I'm having some reports of CUIC not allowing scheduled reports to be
> changed or added for a long time. I'm still trying to reproduce the issue
> myself, but I have a reports user that keeps getting "Scheduler is
> currently being updated" for long periods of time. I haven't been able to
> find a bug related to this one, I'm curious if anyone else has seen this
> type of thing
>
> UCCX 10.6(1)
>
> Thanks!
>
> Ed
>
> --
> Ed Leatherman
>
> _______________________________________________
> 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/20151022/6fb271f3/attachment.html>