Scheduling Reports using Zucker Reports

[Binu Manickkam]

Hi,

I am facing the following issues while scheduling reports using zucker reports. Designing part using ireport and adding it to zuckerreport, preiviewing etc, all are fine. But when i try to run the report -- saving the report for later execution -- and schedule the report daily, it doesn't work. I put the scheduled start date as 10/06/2009 and the interval as daily. But in the next window the scheduled next date always comes as 01/01/2000 12:00am.

I made changes to the following file as given below:-

/var/www/sugarcrm/modules/Schedulers/_AddJobsHere.php

6 => 'ZuckerReportsScheduler', -----> to the jobstrings array

function-----

/* Job 6
*
*/
function ZuckerReportsScheduler() {
require_once("modules/ZuckerRunnableReport/RunnableReport.php");
RunnableReport::scheduler_run_all();
return true;
}

Further I restarted sugar and login as admin. selected 'Scheduler'. Click on 'Create Scheduler' and fill in the details, the job will be 'ZuckerReportsScheduler'. Interval was for everyday.
The following changes were also made to the /etc/crontab

My crontab file is as given below:-

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.
--------------------
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

cd /var/www/sugarcrm; php -f cron.php > /dev/null 2>&1

# m h dom mon dow user command
17 * * * * root cd / && run-parts --report /etc/cron.hourly
25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
#

---------------

After making all the above changes, the schedulers report - Next Run is like -- 01/01/2000 12:00am.

Please help me out to solve this..


Thanks

Binu Manickkam.

[Binu Manickkam]

My Sugarcrm.log file shows the following:-

Tue Oct 6 08:26:39 2009,706 [5204] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Tue Oct 6 08:28:03 2009,496 [5510] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Tue Oct 6 08:32:02 2009,663 [5202] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by



Thanks

Binu Manickkam.

[Binu Manickkam]

Hi All,

Can anyone help me out to solve this.


Thanks

Binu Manickkam

[gazza73]

There is another articlke that deals with this.

1. in the /etc/crontab file you have to have 'root' as the priviledged user, to actually permit the cron to run at all.

2. Until the Zucker Report runs at least one time, then the NEXT DATE will alsways show 1/1/xxxx.

3. The other trick, is that the NEXT RUN date, despite whatever you put into the ADMIN setup of Sugar in respect to your locale (ie: date format: mm/dd/yyyy versus dd/mm/yyyy), the way that the Zucker Scheduler actually works (under 5.2.0g), is that it expects the next run parameter to be entered initially in USA date format: mm/dd/yyyy.

I'm in Australia, where I prefer to have dates appear as dd/mm/yyyy, but to setup any new scheduled reports, I have to initially enter the next run date in the USA format (mm/dd/yyyy). ONce the Scheduler has run at least once, and if I go back to see when the 'next time' will be, it properly displays the dates in my LOCAL setting of dd/mm/yyyyy even though I had to put it in backwards to get the reports running in the first place!

I've just adopted that PROCEDURE of inverse date entry, to run production fine.

I initially had the same problem, reported at:
http://www.sugarcrm.com/forums/showthread.php?t=45987
**** but finally solved at article: *****
http://www.sugarcrm.com/forums/showt...660#post180660

AND an enhancement to let you specify TIME as well as next date to, in article:
http://www.sugarcrm.com/forums/showthread.php?t=58440




Gaz