Active MQ pod fails to create database tables

In some circumstances, the activemq pod fails to create the required tables in the cases database for IBM® Security Case Management.

Symptoms

  • Adding a case from IBM Security Threat Intelligence Insights appears to fail, but a case is created with no artifacts and a Case error message is displayed on the user interface.
  • When you close a case, a generic error message is displayed.
  • Manually adding artifacts to a case fails and a generic error message is displayed.

Diagnosing the problem

Search for the following error in the cases-application-client-log-tailer log file:

ERROR: relation \“activemq_msgs\” does not exist\n

Resolving the problem

Delete the isc-cases-activemq pod to force a restart of the pod and set the CP4S_NAMESPACE variable to the name of the namespace that IBM Security QRadar® Suite Software is running in:
CP4S_NAMESPACE=""
oc delete pod -l app.kubernetes.io/name=isc-cases-activemq -n $CP4S_NAMESPACE