<div dir="ltr">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<div><br></div><div>run sql select id,scheduledreportname,lastruntime,lastrunstatus,operationflag from cuic_data:cuicscheduledreports<br></div><div><br></div><div><div>id scheduledreportname lastruntime lastrunstatus operationflag</div><div>================================ ============================================= ======================= ============= =============</div><div>8ADBECC8100001500002B0C93F5722E9 YTD CSQ Activity 2015-10-22 06:30:00.04 RUN:2 READY</div></div><div><br></div><div>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"</div><div><br></div><div>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.</div><div><br></div><div><br></div><div>Thank you in advance</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 22, 2015 at 2:17 AM, Gurpreet Singh Kukreja <span dir="ltr"><<a href="mailto:tycoononway1987@gmail.com" target="_blank">tycoononway1987@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div>Hi Ed,<br><br></div>Not sure if this has already been resolved for you or not, but here's what i recommend:<br><br></div>- 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:<br><br><b><span style="background-color:rgb(255,255,0)">run sql select id, scheduledreportname, operationflag from cuic_data:cuicscheduledreports</span><br><br></b></div><div>This is sample output for how it should look under the command;<br><br>admin:run sql select id, scheduledreportname, operationflag from cuic_data:cuicscheduledreports<br>id scheduledreportname operationflag<br>================================ =================== =============<br>8E5B3E93100001500000000B0AC5BFE7 TEST READY<br><b><br></b></div><div><b><br></b></div><b>- </b>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:<br><br><b>run sql delete from cuic_data:cuicscheduledreports where id = 'xxx'<br><br></b></div><b><br></b></div>HTH<br></div>Gurpreet<b><br></b><div><div><div><div><div><b><br></b><div><br><br></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 3, 2015 at 9:30 AM, Ed Leatherman <span dir="ltr"><<a href="mailto:ealeatherman@gmail.com" target="_blank">ealeatherman@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello<div><br></div><div>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</div><div><br></div><div>UCCX 10.6(1)</div><div><br></div><div>Thanks!</div><span><font color="#888888"><div><br></div><div>Ed<span class="HOEnZb"><font color="#888888"><br><div><div><br></div>-- <br><div>Ed Leatherman<br></div>
</div></font></span></div></font></span></div><span class="HOEnZb"><font color="#888888">
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></font></span></blockquote></div><br></div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>