000038370 - Reporting Engine restarts After upgrade  to RSA NetWitness Platform 11.4

1. Check which database files are corrupted by checking the Reporting Engine log (/var/netwitness/reserver/rsa/soc/reporting-engine/logs/reportingengine.log/var/netwitness/reserver/rsa/soc/reporting-engine/logs/reportingengine.log) and looking for the log blocks: 

• If the live charts db file is corrupted, the following logs are displayed.

Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed 
more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

org.h2.jdbc.JdbcSQLException: File corrupted while reading record: null. Possible solution: use the recovery tool
[90030-196]

     at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)

     at org.h2.message.DbException.get(DbException.jva:168)

org.springframework.beans.factory.BeanCreationException: Error creating bean with name
'chartSummaryDAOImpl': Invocation of init method failed; nested exception is
com.rsa.soc.re.exception. ReportingException: java.sql.SQLException: Connections could not be acquired from the
underlying database!

• If the alert status db file is corrupted, the following logs are displayed:

Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed 
more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

org.h2.jdbc.JdbcSQLException: File corrupted while reading record: null. Possible solution: use the recovery tool
[90030-196]

     at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)

     at org.h2.message.DbException.get(DbException.jva:168)

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name
'alertStatusHandler': Unsatisfied dependency expressed through field 'alertExecutionStatsDAO'; nested exception
is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name
'alertExecutionStatsDAOImpl': Unsatisfied dependency expressed through field
'presustedAlertExecutionStatsDAO'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean with name
'presistedAlertExecutionStatsDAOImpl'

• If the report status db file is corrupted, the following logs are displayed:

org.h2.jdbc.JdbcSQLException: File corrupted while reading record: null.
Possible solution: use the recovery tool [90030-196]

2. To resolve the live charts database file corruption, perform the following steps:

Warning: Some live charts data may be lost after performing these steps.

1. Stop the Reporting Engine service.
2. Move the livechart.mv.db file from /var/netwitness/reserver/rsa/soc/reporting-engine/livecharts folder to a temporary location.
3. Restart the Reporting Engine service.

3. To resolve the alert status or report status database file corruption, perform the following steps:

1. Stop the Reporting Engine service.
2. Replace the corrupted db file with the latest alertstatusmanager.mv.db or reportstatusmanager.mv.db from the /var/netwitness/reserver/rsa/soc/reporting-engine/archives folder.
3. Restart the Reporting Engine service.