Debug 'NotificationPersistenceService' exceptions in the VNA gateway.log

Products

• CA Spectrum
• DX NetOps
• CA Virtual Network Assurance

Issue/Introduction

In the VNA gateway.log we see notification persistence exceptions:

2022-05-20 07:53:20,898 ERROR (Thread-1108 (ActiveMQ-client-global-threads)) [NOTIFICATION_PERSISTENCE_SERVICE] NotificationPersistenceService 413 Unable to complete notification persistence action. Reason: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement , For more details enable the TRACE mode

Environment

Release : 21.2

Component : Virtual Network Assurance For CA Spectrum

Resolution

To troubleshoot, enable the notification persistence service debugs as follows:

1) Go to: <VNA_HOME>/wildfly/bin directory (e.g. /opt/CA/VNA//wildfly/bin)

2) Run:  ./jboss-cli.sh

3) Enter:  connect

or do:   <VNA_HOME>/wildfly/bin/jboss-cli.sh --connect

4) Run the following command to set the debug level for the category:
/subsystem=logging/logger=NOTIFICATION_PERSISTENCE_SERVICE:write-attribute(name=level,value=TRACE)

5) Wait for 2-3 polls and collect the folders generated in step 4.

Also collect logs folder from 
<VNA_HOME>/wildfly/standalone

6) After collecting the logs revert back the log level to INFO.