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 moreCaused by: java.net.SocketException: Socket closedat 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
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).
