Temp Projects

Rijas P wrote:

Unable to load Balance sheet month wise. almost 10 mins screen was in loading after that came the blank report as attached picture... Downloaded CSV sheet also but only showing the headings.

PS: This is for a submitting month wise balance sheet, so if it will take time to fix kindly provide the Balance Sheet month wise for Financial year 2017-18 to 2020-21.

PFA for complete server error log

Noufal K   Sharil Ali   Please check

-----------> ConnectionPool.abandon: Connection has been abandoned PooledConnection[org.postgresql.jdbc.PgConnection@57d1fe34]:java.lang.Exception
at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1104)

...

org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.; State=08006; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:339)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)

.......

caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method)

.....

java.sql.SQLException: Connection has already been closed.
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)

......

Sharil, Please update the sql time to 30 minutes or 60 to tomcate settings.

Noufal

Can we close this ticket?

Sharil