Fixing the Infor CRM Job Manager when all Jobs are Stuck “Paused”

In Infor CRM version 8.3.06 the Job Service can get stuck in Paused Mode. This is Fixed in version 8.3.08 and higher.

If you run into this issue where all the jobs are stuck you can follow these steps to fix it:

  • Shut down the Saleslogix Cache service
  • Shut down the Saleslogix Job service
  • Run these scripts
DELETE FROM sysdba.QRTZ_BLOB_TRIGGERS

DELETE FROM sysdba.QRTZ_CALENDARS

DELETE FROM sysdba.QRTZ_CRON_TRIGGERS

DELETE FROM sysdba.QRTZ_FIRED_TRIGGERS

DELETE FROM sysdba.QRTZ_JOB_DETAILS

DELETE FROM sysdba.QRTZ_LOCKS

DELETE FROM sysdba.QRTZ_PAUSED_TRIGGER_GRPS

DELETE FROM sysdba.QRTZ_SCHEDULER_STATE

DELETE FROM sysdba.QRTZ_SIMPLE_TRIGGERS

DELETE FROM sysdba.QRTZ_SIMPROP_TRIGGERS

DELETE FROM sysdba.QRTZ_TRIGGERS
  • Start Cache Service
  • Start Job Service
ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

1 Comment

  1. You should say that any trigger created in the web client not application architect will be lost. Triggers / schedules created in the web client are not synced to the model so after deleting the tables this is lost and needs to be recreated manually.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!