We were having trouble downloading BusinessConnect payload from BusinessConnect logs in Tibco Administrator. The payload shows as "xxxx bytes", but the file downloaded is 0 bytes (empty) and the following error is seen in the Admin log file.

===========

2016 Jul 06 14:16:43:342 GMT +0200 : java.sql.SQLRecoverableException: Closed Statement
 at oracle.jdbc.driver.OracleClosedStatement.setString(OracleClosedStatement.java:734)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:282)
 at com.tibco.ax.fw.db.JDBCUtil.setStatementValue(JDBCUtil.java:534)
 at com.tibco.ax.fw.db.DbAccess$3.query(DbAccess.java:872)
 at com.tibco.ax.fw.db.DbAccess$DBQueryMaker.execute(DbAccess.java:2546)
 at com.tibco.ax.fw.db.DbAccess.executeQueryStatement(DbAccess.java:889)
 at com.tibco.ax.fw.db.LogViewTransactionSummary.getResendableIndexes(LogViewTransactionSummary.java:75)
 at com.tibco.ax.fw.db.LogViewTransactionSummary.getTransactionDetails(LogViewTransactionSummary.java:48)
 at com.tibco.ax.fw.db.LogViewTransactionSummary.getTransactionDetails(LogViewTransactionSummary.java:39)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.AuditLogEntityAdapter.getTransactionValues(AuditLogEntityAdapter.java:352)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.AuditLogEntityAdapter.getNativeCollection(AuditLogEntityAdapter.java:254)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.LogTableModel.fetchData(LogTableModel.java:74)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.AuditLog.getFirstLevelDetailPage(AuditLog.java:317)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.AuditLog.showDetailTab(AuditLog.java:245)
 at com.tibco.ax.gui.bcwebadmin.consoles.logviewer.AuditLog$1.actionPerformed(AuditLog.java:98)
 at com.tibco.administrator.EntityCollectionViewer.notifyEntityClickListeners(EntityCollectionViewer.java:343)
 at com.tibco.administrator.EntityCollectionViewer$4.actionPerformed(EntityCollectionViewer.java:326)
 at com.tibco.wfc.AbstractComponent.notifyListeners(AbstractComponent.java:143)
 at com.tibco.wfc.AbstractComponent.fireActionPerformed(AbstractComponent.java:133)
 at com.tibco.wfc.AbstractComponent.processCommand(AbstractComponent.java:157)
 at com.tibco.wfc.AbstractFrame.processCommand(AbstractFrame.java:115)
 at com.tibco.wfc.FrameManager.a(FrameManager.java:259)
 at com.tibco.wfc.FrameManager.service(FrameManager.java:147)
 at com.tibco.administrator.AdministratorServlet.service(AdministratorServlet.java:958)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at com.tibco.administrator.AdministratorServletFilter.doFilter(AdministratorServletFilter.java:56)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:745)
===============

This issue happens because BC on Admin GUI will cache some connections for performance reasons. As a workaround you can click the  "BusinessConnect-Manage-Save" button. This will force BC to recreate the connections.