<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
I manage to find the error that cause the schedule reports to be
always running. The cron dies at ReportRun.php around line 3008 <br>
<pre>if($columnlength > 14400) {</pre>
<pre> die("<br><br><center>".$app_strings['LBL_PDF']." <a href='<a class="moz-txt-link-freetext" href="javascript:window.history.back()">javascript:window.history.back()</a>'>".$app_strings['LBL_GO_BACK'].".</a></center>");</pre>
<pre> }</pre>
<br>
Apparently the column length of the report is bigger than the max
allow for a PDF report. These <i>go back </i>make sense using
the UI to generate the report but when the function is call from
$scheduledReport->sendEmail(); it dies an do not go ahead with
the script. I do not have time to solve this so I disable the PDF
output for now.<br>
<br>
Is this a bug or Am I the only one that found this error?<br>
<br>
Regards,<br>
Conrado<br>
<br>
<br>
<br>
On 10/23/2012 11:08 AM, MAGGI Conrado RE-INGENIA wrote:<br>
</div>
<blockquote cite="mid:5086A4C1.5060409@reingenia.com.ar" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Filippo, <br>
<br>
Thanks a lot for the answer. <br>
<br>
I try to increase the cron frecuency to 15 min. I also include
the end time manually in the database to force to start over but
after the first run is stuck again in running status..<br>
<br>
Anyone else is experience this issue? Has any idea how to solve
it?<br>
<br>
Thanks a lot,<br>
<br>
Best Regards,<br>
<br>
Conrado<br>
<br>
On 10/23/2012 06:41 AM, filippo spera wrote:<br>
</div>
<blockquote
cite="mid:CAErRt5nQK-jRWeo+SCEp8EtqiReVrVRBJa9bMo6qgKWv-t-FSg@mail.gmail.com"
type="cite">Hi<br>
<br>
look here <br>
<br>
<a moz-do-not-send="true"
href="https://forums.vtiger.com/viewtopic.php?f=139&t=53311&p=166341&hilit=schedulereports#p166341">https://forums.vtiger.com/viewtopic.php?f=139&t=53311&p=166341&hilit=schedulereports#p166341</a><br>
<br>
<br>
<br>
<div class="gmail_quote">2012/10/23 MAGGI Conrado RE-INGENIA <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:conrado@reingenia.com.ar" target="_blank">conrado@reingenia.com.ar</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi,<br>
<br>
I Have an issue with schedule reports. In schedule manager
is stuck in<br>
running and the emails do not came out. If I run the cron
manually I get<br>
the following notice:<br>
<br>
[INFO]: ScheduleReports - not ready to run as the time to
run again is<br>
not completed. -> Its been like this for the last 5 hours<br>
<br>
Same as here:<br>
<a moz-do-not-send="true"
href="https://forums.vtiger.com/viewtopic.php?f=139&t=54025&start=10#p168299"
target="_blank">https://forums.vtiger.com/viewtopic.php?f=139&t=54025&start=10#p168299</a><br>
<br>
Any ideas where to look?<br>
<br>
Thanks,<br>
<br>
Conrado<br>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>