Forum

This content is now out of date.

Visit Our Community

An error occurred while saving your details to the database

Hi Support,

Currently running Yellowfin 6.1. We encountered the following error while trying to edit a View via Cloning.


Forum image




Forum image


Can you help please?

This is a snippet from the "stdout" log
------------------------------------

Caused by: java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1699)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.createStatement(ConnectionJDBC2.java:2315)
at com.hof.util.i4Connection.createStatement(i4Connection.java:150)
at com.hof.util.DBAction.A(DBAction.java:340)
... 27 more
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1699)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getAutoCommit(ConnectionJDBC2.java:2123)
at com.hof.util.i4Connection.getAutoCommit(i4Connection.java:110)
at com.hof.util.DBAction.rollback(DBAction.java:486)
at com.hof.util.DBAction.disconnect(DBAction.java:425)
at com.hof.mi.process.MIReportExportImportProcess.cloneView(MIReportExportImportProcess.java:275)
at com.hof.mi.web.action.MIViewEditTypeAction.execute(MIViewEditTypeAction.java:121)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Hi,

Unfortunately the error from the logs is simply stating that the connection has been closed, though does not give us any indication as to why it's closed.

Does this only occur with this particular view?
If you can also note the time this occurred and email across the following log files (you can send them to support@yellowfin.bi) ;
-JDBC.log
-Stdout..log
-Yellowfin.log
-Catalina.out (if you have it)

Once we have these files we should be able to identify the issue.

Thanks,
David