scheduler not working ..
scheduler job Log is done every minutes ..
But Last Successful Run: Never
I see your updates about this issue. Did you have chance to check your PHP Error log?
ttuemer wrote:Hi Mehul, What do you see in PHP Error log? Best RegardsTevfik TümerDeveloper Support Engineer
What do you see in PHP Error log?
Developer Support Engineer
In case if you don't see any error log. Please check your php.ini to have error_log file and error_reporting on with E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED.
Here is the documentation for this. PHP: Runtime Configuration - Manual
When you get that error message you have to have a log line in php_error logs. (Not in sugarcrm.log) That has to give you the problem.
I will be waiting your message.
I would check is cron job working/setup correctly. In addition to that, i would also double check conditions you have entered in your workflow.
There are multiple reason you might get this message. I would recommend you go through Workflow Management - Administration Guide.
It would better if you could mention about what is your workflow type, settings and conditions to understand.
Hi Tevfik Tümer
Same for Process Workflow Task schduler
I understand. Just I need more informations in order to check or test for identifying. Here are more things you could check;
In addition these maybe you can try to trigger cron using terminal. Navigate to: #bwc/index.php?module=Schedulers&action=index and in the below you would see a tab called; To Setup Crontab.
You will see a line like;
cd /<path_to>/<your_sugarcrm>/; php -f cron.php > /dev/null 2>&1
Try to run this in your server, see it works.
You can also check our Scheduler - Knowledge Base documentation. Maybe you can catch something missing.
My all Job Logs are done ..
cron is also running ..
But Last successful is Never and not firing any workflow..
What are the status of logs? How are they finish?
Yes all log status done
Okay, Lets clarify this. If you see status from UI, you will see done but that doesn't mean it is done with success.
Note your scheduler id and modify on query below with <SCHEDULER_ID>.
SELECT * FROM `job_queue` WHERE scheduler_id = '<SCHEDULER_ID>' AND `resolution` != 'success' AND message IS NOT NULL
Then run in your database and see message field. That should give you what is going on on that scheduler.
Thanks for reply ..
message is Unexpected failure, please check PHP logs and sugarcrm.log
i have check logs , its showing
Sat Jun 18 11:35:02 2016 [1be12921-1281-a1d1-30ad-503c788923c3][FATAL] Job 96d8d4c9-193d-a175-7cb9-5764e4121c2f (Process Workflow Tasks) failed in CRON run
what can i do ??
Did you run the query I told you? If you run that against this Workflow ~ 96d8d4c9-193d-a175-7cb9-5764e4121c2f (Process Workflow Tasks) ~ You will see the error message in the DB.
So, If the ID is correct try to run this query in your DB;
SELECT * FROM `job_queue` WHERE scheduler_id = '96d8d4c9-193d-a175-7cb9-5764e4121c2f' AND `resolution` != 'success' AND message IS NOT NULL
Yes i have run query and all job log resolution = failure
and message is Unexpected failure, please check PHP logs and sugarcrm.log
i have check in sugarcrm.log then its showing like
You may try this tutorial at How to set up cron job for SugarCRM , easy to find issue.
Hi Essie li
I have tried but status is Succeeded only
which SugarCRM Version (Edition and Version number) are you running? On which Webserver and PHP version?
Hi Mark Willert Tevfik Tümer
Sugar Professional 6.5
webserver - apache
Sugarcrm.log not showing any problem .. only showing error like below.
there you have the problem - your PHP version is not supported by SugarCRM 6.5 (see http://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_6.5.x_Supported_Platforms/index.html ), and while SugarCRM's WebGUI is running mostly without problems with higher versions, under-the-hood functionality like scheduler jobs can fail.
Please move to a supported platform and test again.
Hi Mark Willert
Thanks for reply .. but another instance with same version is running successfully .
any other solution ??
it might run one way or the other, but you cannot take anything for granted unless you use the supported stack.
next step is to verify file access rights and owner/group. Under which user do you run the Cronjob? It should be the same the webserver is running with (apache on RPM distributions and www-data on DEB-based ones as a rule of thumb).
Alternatively, if you are using Sugar Pro, you can always rise a support case at https://support.sugarcrm.com (they also will require you to stay in the supported stack as requirement to receive support).
Retrieving data ...