Netflow scheduled reports show no data while manual reports are fine

Products

• VMware Smart Assurance

Issue/Introduction

Netflow scheduled reports run but show no data.   Reports run manually are fine.  No errors are shown in the taskRun logs.

Environment

• VMware Smart Assurance - Watch4Net/M&R
• Watch4Net, ViPR SRM

Cause

This is due to the datasource id for the connection to the datastore in the APG/Tools/Frontend-Report-Generator/Default/conf/report-generation-config.xml file not matching the ones in the APG/Web-Servers/Tomcat/Default/conf/server.xml file.

Resolution

Make sure that the datastore ids in the APG/Tools/Frontend-Report-Generator/Default/conf/report-generation-config.xml file match the ones in the APG/Web-Servers/Tomcat/Default/conf/server.xml file.

For example in server.xml:

    <Resource name="jdbc/FLOW-TF-DATA" auth="Container" type="javax.sql.DataSource" maxActive="10"
                maxIdle="10" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true"
                timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" maxWait="10000"
                username="admin" password="######" driverClassName="com.watch4net.x100.jdbc.Driver"
                removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
                url="jdbc:x100://localhost:48443/Databases/APG-Datastore" />

While in frontend-report-generator.xml it should correspond with:

                <datasource id="FLOW-TF-DATA:{ mapping=FLOW-TF-DATA.xml, table=FLOW_RAW_DATA__SEQ_0_4__}"
                        maxActive="10" maxIdle="10" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true"
                        validationQueryTimeout="5" timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000"
                        maxWait="10000" username="flow" password="########"
                        driverClassName="com.watch4net.x100.jdbc.Driver"
                        removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
                        url="jdbc:x100://localhost:48443/Databases/APG-Datastore" />

The datasource id in frontend-report-generator.xml has to match a resource name value in server.xml.