Sometimes after an upgrade or under certain conditions, the Merge and Load task in the LUNA Publisher will disappear or won't run successfully and will result in errors in the publisher's task log.
Do the following to recreate the merge and load task.
- Backup your LUNA Publisher Database
- Run the following queries to remove any remaining elements of your original Merge and Load task. (harmless)
delete from QRTZ_FIRED_TRIGGERS where trigger_name = 'Merge and Load';delete from QRTZ_CRON_TRIGGERS where trigger_name = 'Merge and Load';delete from QRTZ_TRIGGERS where trigger_name = 'Merge and Load';delete from QRTZ_JOB_DETAILS where Job_Name = 'Merge and Load';delete from LAS_TASK_LOGS where task_id in (select task_id from LAS_TASKS where task_type = 'loader');delete from LAS_TASKS where task_type = 'loader';
- Restart your LUNA service (Tomcat5.5 or JBoss depending on which one you're using to serve your LUNA site)