CEM Reports encounter: "Could not connect to SQLite Databaseorg.sqlite.JDBC".

Products

• Compliance Event Manager

Issue/Introduction

After the application of maintenance to Compliance Event manager (CEM),  CEM Reports encounter the error:  "Could not connect to SQLite Databaseorg.sqlite.JDBC".  

Environment

Release : 6.0 +

Cause

The CEMETOM CFGLIB member was missing the following:

CLASSPATH="$CLASSPATH":"${CEM_USSPATH}/cai/cacem/cem/cem-sqlite-jdbc.jar"

 

Resolution

Adding the necessary CLASSPATH statement to CEM's  CEMETOM CFGLIB member and then cycling the CEMETOM STC proved successful in resolving the  "Could not connect to SQLite Databaseorg.sqlite.JDBC" error.