Watch4Net APG: Schedule report showing blank PDF

Products

• VMware

Issue/Introduction

Symptoms:




Watch4net APG Schedule report showing blank PDF.

Environment

VMware Smart Assurance - Watch4Net/M&R

Cause

/opt/APG/Tools/Frontend-Report-Generator/Default/conf/report-generation-config.xml  was missing the entry for database.

Resolution

1. Modify /opt/APG/Tools/Frontend-Report-Generator/Default/conf/report-generation-config.xml

Example:

<datasource id="FLOW-CISCO-CDR: { mapping-FLOW-CISCO-CDR.xml, table=cisco_cdr }" driverClassName="com.mysql.jdbc.Driver" url=jdbc.myslq://xxx.xxx.xxx.xxx:53307/events?autoReconnect=true" username="xxxx" password="xxxx" maxActive="30" maxIdle="5" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" minEvicktableIdleTimeMillis="60000" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>

2. Restart tomcat after the change is made.

/opt/APG/bin/apg-tomcat-default stop

/opt/APG/bin/apg-tomcat-default start