CABI Audit Report fails to open - Could not create resource instance

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Audit Report fails to open on new CABI 8.02 instance

Environment

CABI 8.00+

Resolution

1. The "jdbc/jasperserverAudit" resource entry is not included in the context.xml with a fresh install of cabi version 8.00 and above.

Add entry below in the X:\Nimsoft\probes\service\wasp\webapps\cabijs\META-INF\context.xml.

Replace password, url, databasename and username fields with your database connection properties

<Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserverAudit" password="<ENCRYTEDPASSWORD>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:sqlserver://<system>:1433;databaseName=<databasename>;sendTimestampEscapeAsString=false" username="<user>" validationQuery="SELECT 1"/>    

2. Enable Audit data collection per below link

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v630/configuring-auditing-and

Edit the .../WEB-INF/js.config.properties file

# enable or disable auditing monitoring feature
feature.audit_monitoring.enabled=true

# Enable or disable Auditing
audit.records.enabled=true

# Enable or disable Monitoring
monitoring.records.enabled=true

3. Deactivate/Activate the wasp probe on the cabi robot