Description

This article explains how to fix the access issue to the Job management tab. We will get the below error from UI while accessing the Job management tab

Job Managment - error.GIF

Symptoms

We will get the below error from server.log:
  
2024-05-29 10:02:24,537 ERROR [org.jboss.as.ejb3.invocation] (default task-182) WFLYEJB0034: EJB Invocation failed on component cmp.JobManagerEJB for method public abstract net.juniper.jmp.PagingResult net.juniper.jmp.cmp.jobManager.JobManager.getAllJobInstances(net.juniper.jmp.cmp.jobManager.TimeZoneLocaleHelper,net.juniper.jmp.PagingContext) throws java.lang.Exception: javax.ejb.EJBException: javax.persistence.EntityNotFoundException: Unable to find net.juniper.jmp.cmp.jobManager.jpa.Schedule with id 21812240

According to the error, the table Job is trying to find the entry with id 21812240 from the table schedule. However, the entry is not found

Solution

To fix the issue, we need to delete the stale entries from the Job table with respect to the schedule table.

Here are the steps to achieve this:

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db

SET FOREIGN_KEY_CHECKS=0;

delete from Job where schedule_id not in (select id from Schedule);

SET FOREIGN_KEY_CHECKS=1;

 

 

 

Modification History

2024-05-31 : Article Created