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

[Jose Colon II]

Hi Gurpreet, I have a similar issue where a user is running a report and
the report is running for a considerable amount of time. When I run the
below sql query I get the following ouput

run sql select
id,scheduledreportname,lastruntime,lastrunstatus,operationflag from
cuic_data:cuicscheduledreports

id                               scheduledreportname
    lastruntime             lastrunstatus operationflag
================================
============================================= =======================
============= =============
8ADBECC8100001500002B0C93F5722E9 YTD CSQ Activity
   2015-10-22 06:30:00.04  RUN:2         READY

This report shows that it is running in the CUIC browser. Howerver when I
run the sql statement from CLI its operationflag shows "Ready" but what
does the "lastrunstatus" of "RUN:2" actually mean? all the other reports on
the system show "RUN:1"

I am concerdned with this as the report has been running for the last 4
hours. It is a big report but the user has told me this usually is done a
long time before this.


Thank you in advance


On Thu, Oct 22, 2015 at 2:17 AM, Gurpreet Singh Kukreja <
tycoononway1987 at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/61ad4cc2/attachment.html>