[Vtigercrm-developers] Schedule Reports always running - Partially SOLVED

[MAGGI Conrado RE-INGENIA]

Hi,

I manage to find the error that cause the schedule reports to be always 
running. The cron dies at ReportRun.php around line 3008

if($columnlength > 14400) {

             die("<br><br><center>".$app_strings['LBL_PDF']." <a href='javascript:window.history.back()'>".$app_strings['LBL_GO_BACK'].".</a></center>");

         }


Apparently the column length of the report is bigger than the max allow 
for a PDF report. These /go back /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.

Is this a bug or Am I the only one that found this error?

Regards,
Conrado



On 10/23/2012 11:08 AM, MAGGI Conrado RE-INGENIA wrote:
> Filippo,
>
> Thanks a lot for the answer.
>
> 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..
>
> Anyone else is experience this issue? Has any idea how to solve it?
>
> Thanks a lot,
>
> Best Regards,
>
> Conrado
>
> On 10/23/2012 06:41 AM, filippo spera wrote:
>> Hi
>>
>> look here
>>
>> https://forums.vtiger.com/viewtopic.php?f=139&t=53311&p=166341&hilit=schedulereports#p166341
>>
>>
>>
>> 2012/10/23 MAGGI Conrado RE-INGENIA <conrado at reingenia.com.ar 
>> <mailto:conrado at reingenia.com.ar>>
>>
>>     Hi,
>>
>>     I Have an issue with schedule reports. In schedule manager is
>>     stuck in
>>     running and the emails do not came out. If I run the cron
>>     manually I get
>>     the following notice:
>>
>>     [INFO]: ScheduleReports - not ready to run as the time to run
>>     again is
>>     not completed. -> Its been like this for the last 5 hours
>>
>>     Same as here:
>>     https://forums.vtiger.com/viewtopic.php?f=139&t=54025&start=10#p168299
>>
>>     Any ideas where to look?
>>
>>     Thanks,
>>
>>     Conrado
>>
>>     _______________________________________________
>>     http://www.vtiger.com/
>>
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20121024/50d3d27c/attachment-0001.html