Smarts NCM: RA report fails with error msg: An I/O error occurred while sending to the backend.

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


RA report returns with no information and an error message of " I/O error occurred while sending to the backend" is found in the /usr/tomcat/apache<version>/logs/catalina.out or /usr/tomcat/apache<version>/logs/Voyence.log. (See examples below)

Caused by: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at com.voyence.reporting.reportpacks.audittrail.AuditTrailResultSet.prepare(AuditTrailResultSet.java:388)
at com.voyence.reporting.common.resultset.ResultSetProvider.getResultSet(ResultSetProvider.java:109)
at com.voyence.reporting.common.framework.impl.VoyenceReportEngine.publishReportToDisk(VoyenceReportEngine.java:213)
... 7 more
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:145)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:114)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:274)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1660)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 14 more

Environment

VMware Smart Assurance - NCM

Cause

These errors indicate that the report is pulling too much information to properly complete a report.

Resolution

The administrator must scale down the amount of data being pulled (e.i. number of networks or devices included in the report).