ZuckerReports Scheduler failure

[MGregson]

Hi all,

I have been having a bit of difficulty configuring the ZuckerReports Scheduler. Before I launch into my problem, here's what I am running on my development server:

O/S: SLES10
Sugar version: 5.0.0b (in production environment, Sugar version is 5.0.0f)
(Please note that my Sugar installation was performed using the 5.0.0b FastStack installer)

Whilst I was on leave, ZuckerReports has been implemented into SugarCRM at my workplace. Once I returned, I have been using it to generate simple listing reports in our dev environment (yet to try iReport), and my boss would like me to configure it to run scheduled reporting ASAP. I have configured the Sugar Scheduler correctly, as I have seen that it successfully checks for inbound mail every minute, but as yet I have been unsuccessful in configuring the ZuckerReports Scheduler. Thus far, the only documentation I have found on setting up the scheduler is this:

http://dl.sugarforge.org/zuckerrepor...stingGuide.txt

Report Scheduler Setup
======================
In order for the report scheduler to work, you have to make manual chances in a Sugar file.
* open modules/Schedulers/_AddJobsHere.php
* round line 65, add the following line to the "$job_strings"-array:
8 => 'ZuckerReportsScheduler',
* somewhere below add the following function:

function ZuckerReportsScheduler() {
require_once("modules/ZuckerRunnableReport/RunnableReport.php");

RunnableReport::scheduler_run_all();
return true;
}

Afterwards log in to Sugar as admin user, open the Admin panel, select the "Scheduler" option and add
a new "ZuckerReportsScheduler" task to the scheduler, running every minute (the "ZuckerReportsScheduler" task
should be available in the dropdown list there).
Please be sure to configure the Sugar scheduler correctly, calling the "cron.php" script - otherwise
the ZuckerReports scheduler won't work either.

The only exception I made in following these instructions was that I gave the scheduler number 6 instead of 8 (seeing as there were only five other default Sugar Scheduler jobs). I configured the "ZuckerReportsScheduler" task with the following options:

Interval: */1 * * * * <--- I actually entered * * * * *, but it was automatically changed when I checked the task
Execute if missed: True
Date & Time Start: 01/01/2005 00:00
Date & Time End: 31/12/2020 23:59

I've configured a pretty standard listing report to be run every hour and emailed as an HTML file to my email address. It works when I select "Test Schedule", but not when I try and schedule it to run automatically. The ZuckerReports Scheduler seemingly runs for an hour (Status is 'In Progress'), fails, then runs again. This is a sample of the output that I am getting from my sugarcrm.log file:

Thu Jul 31 09:20:02 2008,246 [28309] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:21:02 2008,021 [28585] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:22:01 2008,837 [28861] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:23:02 2008,628 [29138] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:24:02 2008,398 [29415] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:25:02 2008,233 [29694] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 09:26:01 2008,964 [29968] FATAL SugarCRM - If you see a whole string of these, there is a chance someone is attacking your system.
Thu Jul 31 10:20:13 2008,359 [3128] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Jul 31 12:46:31 2008,206 [3126] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Jul 31 12:46:40 2008,066 [3124] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by

Anybody have an idea as to why the scheduler is not working? I'm not sure if it's something to do with the version of Sugar, or maybe the fact that I used the FastStack installer (i.e. MySQL, Apache, PHP all in the /opt/sugarcrm-5.0.0b directory). If there's anything I should include in my problem description, just let me know. I need this to be up and running ASAP, so any help would be greatly appreciated. Thanks!

[MGregson]

Just to clarify, I have ensured that the apache user has full permissions to the relationships.cache.php and that schedulers_created_by actually exists in there.

[MGregson]

Sorry to do this, but another bump of this thread. I've determined that ZuckerReports Scheduler runs successfully only if there are no reports scheduled to run (handy, I know). However, as soon as a scheduled report is due to run, it hangs on 'In Progress' and fails an hour later.

Any ideas?

[quixote1024]

Sorry to do this, but another bump of this thread. I've determined that ZuckerReports Scheduler runs successfully only if there are no reports scheduled to run (handy, I know). However, as soon as a scheduled report is due to run, it hangs on 'In Progress' and fails an hour later.

Any ideas?

Hello all,

I had the same issue and have since been able to get it to work - albeit not an ideal situation. The first issue is the "Error fetching relationship from cache schedulers_created_by" error message. Either the ZuckerReportsScheduler needs a fix or the SugarCRM system needs a new relationship set.

The following wiki file was my first clue: Error fetching relationship from cache.

Steps:
1. I created the missing entry in the Relationships table: there was a record for "schedulers_created_by_rel" but not "schedulers_created_by". I created a duplicate entry from "schedulers_created_by_rel" except I called it "schedulers_created_by".

2. I edited the file cache/modules/Relationships/relationships.cache.php: Once again, there was an entry for "schedulers_created_by_rel" but not "schedulers_created_by". I created a duplicate entry from "schedulers_created_by_rel" except I called it "schedulers_created_by".

3. Do NOT run "Repair Relationships" - this overwrites the table and cache modifications.

4. Set up a new report and schedule a time for later execution.

5. Trigger the scheduler cron job.

This worked for me - it generated the scheduled report.

I am now going to go back and look at the Zucker Scheduler to see if the right way to fix this is by fixing Zucker to look for "schedulers_created_by_rel" instead of "schedulers_created_by".

I hope this helps with the troubleshooting,

[MGregson]

Thanks for the tip. I haven't been getting that error message in a while now, but I don't have the "schedulers_created_by" record. I might give that a try.

Anyway, I have another update to this issue: the ZuckerReports Scheduler job in Sugar Scheduler successfully runs, even when a scheduled report is set to run (no more hanging for an hour). However, it still doesn't actually generate the report and email it to me. The "Next Run" value on the test report I've scheduled to run hourly increments by one hour, which would suggest a successful report, but it does not actually generate and mail the report.

Any more suggestions would be great. =)

[zeezhao]

Hi. Please what was the eventual solution to this issue?

[Binu Manickkam]

Hi,

I too have a similar issue. I have installed sugarcrm on ubuntu 8.04. Except creating scheduler.bat all others were done. When I try to run the report using Zuckerreport at a later stage, the next run date always comes as 01-01-2000. I had mentioned to run the report daily with the start date as 05-10-2009, but still the next run date comes as 01-01-2000.

Please help me to solve this issue.

Thanks

Binu Manickkam.

[Binu Manickkam]

Hi,

I too have a similar issue. I have installed sugarcrm on ubuntu 8.04. Except creating scheduler.bat all others were done. When I try to run the report using Zuckerreport at a later stage, the next run date always comes as 01-01-2000. I had mentioned to run the report daily with the start date as 05-10-2009, but still the next run date comes as 01-01-2000.

Please help me to solve this issue.

Thanks

Binu Manickkam.

Hi

Can anyone help me out to solve this


Binu Manickkam.