Troubleshooting
Problem
We are getting an "Unexpected error has occurred. Please contact your System Administrator." when scheduling a policy.
Diagnosing The Problem
support must_gather app_issues - Application issues
support must_gather scheduler_issues - Scheduler issues
support must_gather scheduler_issues - Scheduler issues
debug.log
==============Tue Jul 25 15:38:53 EDT 2023===================
Thread: https-jsse-nio-8443-exec-7 - java.lang.NullPointerException
at com.guardium.scheduler.util.SchedulerUtils.createJob(SchedulerUtils.java:731)
at com.guardium.rest.core.JobSchedulerCore.createScheduler(JobSchedulerCore.java:483)
at com.guardium.rest.core.JobSchedulerCore.createScheduler(JobSchedulerCore.java:463)
at com.guardium.rest.util.ScheduleRESTProcessor.doPost(ScheduleRESTProcessor.java:361)
at com.guardium.rest.RestController.handleRequest(RestController.java:68)
==============Tue Jul 25 15:39:41 EDT 2023===================
Thread: https-jsse-nio-8443-exec-8 - java.lang.NullPointerException
at com.guardium.scheduler.util.SchedulerUtils.removeJob(SchedulerUtils.java:364)
at com.guardium.analytic.AnalyticPostProcess.unschedule(AnalyticPostProcess.java:94)
at com.guardium.management.util.RemoteRegistrationHelper.setManaged(RemoteRegistrationHelper.java:449)
at com.guardium.management.util.ManagementServlet.doPost(ManagementServlet.java:315)
==============Tue Jul 25 15:41:31 EDT 2023===================
Thread: https-jsse-nio-8443-exec-1 - java.lang.NullPointerException
at com.guardium.rest.core.JobSchedulerCore.getSchedule(JobSchedulerCore.java:383)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:317)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:348)
at com.guardium.rest.util.ScheduleRESTProcessor.doGet(ScheduleRESTProcessor.java:121)
at com.guardium.rest.RestController.handleRequest(RestController.java:65)
catalina.out
==============Tue Jul 25 15:38:53 EDT 2023===================
Thread: https-jsse-nio-8443-exec-7 - java.lang.NullPointerException
at com.guardium.scheduler.util.SchedulerUtils.createJob(SchedulerUtils.java:731)
at com.guardium.rest.core.JobSchedulerCore.createScheduler(JobSchedulerCore.java:483)
at com.guardium.rest.core.JobSchedulerCore.createScheduler(JobSchedulerCore.java:463)
at com.guardium.rest.util.ScheduleRESTProcessor.doPost(ScheduleRESTProcessor.java:361)
at com.guardium.rest.RestController.handleRequest(RestController.java:68)
==============Tue Jul 25 15:39:41 EDT 2023===================
Thread: https-jsse-nio-8443-exec-8 - java.lang.NullPointerException
at com.guardium.scheduler.util.SchedulerUtils.removeJob(SchedulerUtils.java:364)
at com.guardium.analytic.AnalyticPostProcess.unschedule(AnalyticPostProcess.java:94)
at com.guardium.management.util.RemoteRegistrationHelper.setManaged(RemoteRegistrationHelper.java:449)
at com.guardium.management.util.ManagementServlet.doPost(ManagementServlet.java:315)
==============Tue Jul 25 15:41:31 EDT 2023===================
Thread: https-jsse-nio-8443-exec-1 - java.lang.NullPointerException
at com.guardium.rest.core.JobSchedulerCore.getSchedule(JobSchedulerCore.java:383)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:317)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:348)
at com.guardium.rest.util.ScheduleRESTProcessor.doGet(ScheduleRESTProcessor.java:121)
at com.guardium.rest.RestController.handleRequest(RestController.java:65)
catalina.out
Guardium Scheduling Error: (in SchedulerUtils.getScheduler) Unexpected Quartz Error --Failure occured during job recovery.
at com.guardium.scheduler.util.SchedulerUtils.getScheduler(SchedulerUtils.java:1086)
at com.guardium.rest.core.JobSchedulerCore.getSchedule(JobSchedulerCore.java:382)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:317)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:348)
at com.guardium.rest.util.ScheduleRESTProcessor.doGet(ScheduleRESTProcessor.java:121)
at com.guardium.rest.RestController.handleRequest(RestController.java:65)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired [See nested exception: java.sql.SQLException: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:606)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:59)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1225)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1376)
at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerFactory.java:1392)
at com.guardium.scheduler.util.SchedulerUtils.getScheduler(SchedulerUtils.java:1082)
... 211 more
at com.guardium.scheduler.util.SchedulerUtils.getScheduler(SchedulerUtils.java:1086)
at com.guardium.rest.core.JobSchedulerCore.getSchedule(JobSchedulerCore.java:382)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:317)
at com.guardium.rest.core.JobSchedulerCore.getScheduler(JobSchedulerCore.java:348)
at com.guardium.rest.util.ScheduleRESTProcessor.doGet(ScheduleRESTProcessor.java:121)
at com.guardium.rest.RestController.handleRequest(RestController.java:65)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired [See nested exception: java.sql.SQLException: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:606)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:59)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1225)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1376)
at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerFactory.java:1392)
at com.guardium.scheduler.util.SchedulerUtils.getScheduler(SchedulerUtils.java:1082)
... 211 more
Resolving The Problem
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired [See nested exception: java.sql.SQLException: Table 'QRTZ_FIRED_TRIGGERS' is marked as crashed and should be repaired]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:606)
Resolution:
Run the following cli command:
support repair crashed_table TURBINE QRTZ_FIRED_TRIGGERS
To verify, run:
support find crashed_tables
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0YAAS","label":"JOBS"}],"ARM Case Number":"TS013711909","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
28 November 2023
UID
ibm17084150