CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Scheduled Jobs have disappeared
Pages: [1]

Author Topic: Scheduled Jobs have disappeared  (Read 618 times)

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Scheduled Jobs have disappeared
February 03, 2014, 06:51:02 am

I just upgraded the site and apart from correcting some resource urls everything appears to be working fine 

However when I go to scheduled jobs there are now only three listed

  • Disable expired relationships
    Rebuild Smart Group Cache
    Validate Email Address from Mailings

I've checked the page source to exclude any sort of wrapping/hidden block issues
I've run the jobs manually from the link at the top of the page (cron is not configured properly) with a test mailing set-up - although the log shows 'Finishing scheduled jobs execution.' the mailing is not sent.
I've enabled the debugging tools etc and no errors are showing.
It seems like the other jobs are simply not being found.
Any ideas?

Other info
upgraded from 4.1.5 (I think) to 4.4.3
Running Drupal 7.26
I had to run the database schemata integrity process to get the upgrade to work
upgrade reported no errors

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: Scheduled Jobs have disappeared
February 03, 2014, 10:45:06 am
ok started having a look at the civicrm_job table and comparing the upgraded site with pre-update database

In the original all the entries have domain_id=1. In the new table the ones visible on the site to me at the moment are all given domain_id 2 (it is a multisite installation). Strangely the ones visible are also marked as is_active = 0 which I would have assumed mean’t they were disabled.

I’ll do some more work on this but am assuming changing the domain_id of other jobs (duplicating entries with different domains)  will make them visible but I don’t understand where this behaviour has come from. Also whilst I can see how you could want separate jobs for each domain its not obvious if you can configure any as universal jobs?

Does this make sense to anyone?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Scheduled Jobs have disappeared
February 03, 2014, 12:44:41 pm
Hi, in general it would be good if domain_id offered universal (0 for domain). However we don't have that pattern anywhere.

Some, probably most, jobs are by their nature universal - so they don't need to run once for each domain - just once on any domain. The jobs that are NOT universal are the Civimail send and bounce processing jobs - actually I'm not even sure about bounce processing. But, send has to be per domain to get the correct urls embedded.

Processing scheduled reminders is not by domain but in 4.4.4 there is a ticket to allow params such as id to be passed to that job - allowing you to run some from one domain & some for another. That picks up the default from address for that domain. However, we have gone down the path of a small extension to allow you to set the from address (probably won't run on less that 4.4.4 or possibly 4.2.15 - both of which are due out.)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jclemo

  • I’m new here
  • *
  • Posts: 15
  • Karma: 1
  • CiviCRM version: 4.1
  • CMS version: Drupal 7
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: Scheduled Jobs have disappeared
February 10, 2014, 06:12:33 am
Thanks to Eileen for comments
Just to add in case someone else has this problem:

Correcting the domain_id in the table civicrm_job corrected this problem. As far as I can tell you need an entry for each scheduled job for each domain for this to work as expected.

A copy of the full scheduled job data (in case you want to do a clean import) is in the civicrm_generated.mysql file located in the sql folder in your civicrm installation folder

I don't know if this was caused by a bug in the update script but was easy to solve.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Scheduled Jobs have disappeared

This forum was archived on 2017-11-26.