scheduler Problem - Last successful never

Hi Mehul,

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.

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

Same for Process Workflow Task schduler

Hi Mehul,

I understand. Just I need more informations in order to check or test for identifying. Here are more things you could check;

• Is your admin (user_id = 1) is still exist and active? (There were a bug in the past about this)
• Do you see anything in job_queue?
• Are we sure about cron running?

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.

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

My all Job Logs are done ..

cron is also running ..

But Last successful is Never and not firing any workflow..

Hi Mehul,

What are the status of logs? How are they finish?

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

Yes all log status done

But Last successful is Never and not firing any workflow..

Hi Mehul,

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.

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

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 [8437][1be12921-1281-a1d1-30ad-503c788923c3][FATAL] Job 96d8d4c9-193d-a175-7cb9-5764e4121c2f (Process Workflow Tasks) failed in CRON run

what can i do ??

Hi Mehul,

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 

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Mehul,

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 

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

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

Sat Jun 18 11:35:02 2016 [8437][1be12921-1281-a1d1-30ad-503c788923c3][FATAL] Job 96d8d4c9-193d-a175-7cb9-5764e4121c2f (Process Workflow Tasks) failed in CRON run

what can i do ??

Hi Mehul,

What do you see in PHP Error log?

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Mehul,

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 Regards

Tevfik Tümer

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.

Best Regards

Tevfik Tümer

Developer Support Engineer