SugarChimp

Hello,

I've moved the case over to SugarChimp so that you can get the help that you need from SugarChimp support. Can you also post the complete error that is in your Sugar log? Can you also confirm that you have a cron set up and that your other Scheduler Jobs are running?

-Jason

Hi there, would you be able to post the complete error from the logs? And can you confirm the cron is setup and your other Scheduler Jobs are running?

Also, I noticed in our license logs that your host was set as 'localhost'. If that's not correct, you may want to make sure your site_url and host_name are set properly in your config.php or config_override.php files.

Thanks!

Here's the data. I can email you the files if it helps:

config.php: 'site_url' => 'http://crm.mpacksystems.com/crmcom', host_name not present in config.php.

config_override.php: Neither present.

Log: Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='SugarChimp',date_modified='2014-07-01 07:00:01',scheduler_id='93f36a1b-bf54-4230-fbc9-53ada8879fef',execute_time='2014-07-01 06:55:00',status='running',resolution='queued',message=NULL,target='function::SugarChimp',data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client='CRONcf5593db331e674a56a3364cadc5b768:13451',percent_complete=NULL WHERE job_queue.id = '531e96b8-1e7f-4c64-f358-53b25b657452' AND deleted=0 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.01293683052063 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Jul 1 00:00:03 2014 [13451][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] ----->SchedulersJob calling function: SugarChimp Tue Jul 1 00:00:03 2014 [13451][1][INFO] Resolving job 531e96b8-1e7f-4c64-f358-53b25b657452 as failure: Cannot call function: SugarChimp Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::job_failure Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Loading Preferences DB Patrick Eidemiller Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='1' AND category = 'global' AND deleted = 0 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.00060796737670898 Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] Formatting correction: SchedulersJobs->failure_count had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='SugarChimp',date_modified='2014-07-01 07:00:01',scheduler_id='93f36a1b-bf54-4230-fbc9-53ada8879fef',execute_time='2014-07-01 06:55:00',status='done',resolution='failure',message='Cannot call function: SugarChimp\n',target='function::SugarChimp',data=NULL,requeue=0,retry_count=NULL,failure_count=1,job_delay=0,client='CRONcf5593db331e674a56a3364cadc5b768:13451',percent_complete=NULL WHERE job_queue.id = '531e96b8-1e7f-4c64-f358-53b25b657452' AND deleted=0 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.0077600479125977 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Jul 1 00:00:03 2014 [13451][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php Tue Jul 1 00:00:03 2014 [13451][1][FATAL] Job 531e96b8-1e7f-4c64-f358-53b25b657452 (SugarChimp) failed in CRON run Tue Jul 1 00:00:03 2014 [13451][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= '2014-07-01 07:00:01' AND status = 'queued' ORDER BY date_entered ASC| Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Limit Query:SELECT id FROM job_queue WHERE execute_time <= '2014-07-01 07:00:01' AND status = 'queued' ORDER BY date_entered ASC Start: 0 count: 1 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= '2014-07-01 07:00:01' AND status = 'queued' ORDER BY date_entered ASC LIMIT 0,1 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.0002589225769043 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::before_retrieve Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Retrieve SchedulersJob : SELECT job_queue.* FROM job_queue WHERE job_queue.id = '39043c99-61be-811e-62b3-53b25c3480c5' AND job_queue.deleted=0 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Limit Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = '39043c99-61be-811e-62b3-53b25c3480c5' AND job_queue.deleted=0 Start: 0 count: 1 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = '39043c99-61be-811e-62b3-53b25c3480c5' AND job_queue.deleted=0 LIMIT 0,1 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.00027203559875488 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::after_retrieve Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:UPDATE job_queue SET status='running', date_modified='2014-07-01 07:00:01', client='CRONcf5593db331e674a56a3364cadc5b768:13451' WHERE id='39043c99-61be-811e-62b3-53b25c3480c5' AND status='queued' Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.0058708190917969 Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::before_save Tue Jul 1 00:00:03 2014 [13451][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query:UPDATE job_queue SET assigned_user_id='1',name='Check Inbound Mailboxes',date_modified='2014-07-01 07:00:01',scheduler_id='388a5cd0-d78e-4bb3-f64b-52214fe44fbe',execute_time='2014-07-01 07:00:00',status='running',resolution='queued',message=NULL,target='function::pollMonitoredInboxes',data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client='CRONcf5593db331e674a56a3364cadc5b768:13451',percent_complete=NULL WHERE job_queue.id = '39043c99-61be-811e-62b3-53b25c3480c5' AND deleted=0 Tue Jul 1 00:00:03 2014 [13451][1][INFO] Query Execution Time:0.012682914733887 Tue Jul 1 00:00:03 2014 [13451][1][DEBUG] Hook called: SchedulersJobs::after_save Tue Jul 1 00:00:03 2014 [13451][1][ERROR] Unable to load custom logic file: include/Su

Hi again, I wanted to check-in on this. Were you able to get around the installation issues?

If you're still having issues and still interested in the integration, we may need to setup a screenshare to see what's going on here.

Just let me know how you'd like to proceed. Thanks!

Hi, not resolved. Love to get it fixed, let me know when we can do a screen share.

Closing this case. We were able to resolve the issue. For some reason on install the Scheduler Extension file was not rebuilt properly. After correcting this, everything started syncing.

Thanks Patrick!