search cancel

Debug NOTIFICATION PERSISTENCE exceptions in the VNA gateway.log

book

Article ID: 242333

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

In the 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, please enabled notification persistence debug as follows:

1) Go to <VNA_HOME>/wildfly/bin.

2) Run ./jboss-cli.sh

3) Enter *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 upload logs folder from 
/opt/CA/VNA/wildfly/standalone

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