topic Alfresco log Error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-log-error/m-p/273884#M227014 <HTML><HEAD></HEAD><BODY><SPAN>Hi to all,</SPAN><BR /><BR /><SPAN>i found some errors in my alfresco log file…due to which my web page getting effected..i gone through some articles in google&nbsp; but i am not get rid of it..if any solution would be appreciated.. </SPAN><BR /><BR /><SPAN>12:29:48,694 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.&nbsp; N</SPAN><BR /><SPAN>ormal retry behaviour will resume.</SPAN><BR /><SPAN>org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot release connection</SPAN><BR /><SPAN>; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Already closed.; ne</SPAN><BR /><SPAN>sted exception is java.sql.SQLException: Already closed.</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Already closed.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingData</SPAN><BR /><SPAN>Source.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(L</SPAN><BR /><SPAN>ocalDataSourceConnectionProvider.java:95)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTra</SPAN><BR /><SPAN>nsactionManager.java:594)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRoll</SPAN><BR /><SPAN>back(AbstractPlatformTransactionManager.java:753)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(Ab</SPAN><BR /><SPAN>stractPlatformTransactionManager.java:730)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransacti</SPAN><BR /><SPAN>onAfterThrowing(TransactionAspectSupport.java:332)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrow</SPAN><BR /><SPAN>ing(SpringAwareUserTransaction.java:561)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:531)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.repository.User.getUserPreferencesRef(User.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.repository.User.getPreferences(User.java:206)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.bean.repository.PreferencesService.getPreferences(PreferencesService.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.Application.getLanguage(Application.java:688)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:185)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.BaseServlet.servletAuthenticate(BaseServlet.java:156)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.BaseServlet.servletAuthenticate(BaseServlet.java:126)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.servlet.DownloadContentServlet.doGet(DownloadContentServlet.java:100)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChai</SPAN><BR /><SPAN>n.java:290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:2</SPAN><BR /><SPAN>06)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)</SPAN><BR /><SPAN> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol</SPAN><BR /><SPAN>.java:583)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:619)</SPAN><BR /><SPAN>12:32:47,016 INFO&nbsp; [org.alfresco.web.app.servlet.DownloadContentServlet] Client aborted stream re</SPAN><BR /><SPAN>ad:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node: workspace://SpacesStore/f2a87b91-2210-4739-94dc-ce18565901d5</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; content: ContentAccessor[ contentUrl=store://2012/6/23/11/26/98e77cf9-cecf-4c23-bfe9-3e34</SPAN><BR /><SPAN>7ab8a8b0.bin, mimetype=application/pdf, size=190197, encoding=UTF-8, locale=en_US]</SPAN><BR /><SPAN>12:33:30,578 INFO&nbsp; [org.alfresco.web.app.servlet.DownloadContentServlet] Client aborted stream re</SPAN><BR /><SPAN>ad:</SPAN><BR /><SPAN>node: workspace://SpacesStore/7a61f56c-c584-4a8e-8b9e-b490364e5bfd</SPAN></BODY></HTML> Mon, 06 Aug 2012 12:43:02 GMT paramesh 2012-08-06T12:43:02Z Alfresco log Error https://connect.hyland.com/t5/alfresco-archive/alfresco-log-error/m-p/273884#M227014 Hi to all,i found some errors in my alfresco log file…due to which my web page getting effected..i gone through some articles in google&nbsp; but i am not get rid of it..if any solution would be appreciated.. 12:29:48,694 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.&nbsp; Mon, 06 Aug 2012 12:43:02 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-log-error/m-p/273884#M227014 paramesh 2012-08-06T12:43:02Z Re: Alfresco log Error https://connect.hyland.com/t5/alfresco-archive/alfresco-log-error/m-p/273885#M227015 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>unfortunately, to solve this issue, you would need to get at the root cause of the rollback itself. This you could to by elevating the logger settings of the RetryingTransactionHelper leg level in the log4j.properties file.</SPAN><BR /><BR /><SPAN>By the way, it is interesting to see the same error reporting by an (alleged) alternative user via </SPAN><A href="https://forums.alfresco.com/en/viewtopic.php?f=7&amp;t=45817" rel="nofollow noopener noreferrer">https://forums.alfresco.com/en/viewtopic.php?f=7&amp;t=45817</A><SPAN> - any relation to you?</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Mon, 06 Aug 2012 22:17:24 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-log-error/m-p/273885#M227015 afaust 2012-08-06T22:17:24Z