[xwiki-users] HELP: Cannot save new panel layout and preferences while logged in as Admin
Hi XWiki Users, I try to start a new thread about this problem, because the problem is very urgent. This matter has been a topic around April this year as I found at jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while logged in as Admin), but wasn't really solved if I understand it all well! I experience problems saving both my layout and preferences, getting the following message: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:314) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:100) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:94) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Unknown Source) Wrapped Exception: java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set XWD_ARCHIVE=head ..... Our consideration using xwiki for our institute's wiki site is in danger because of this error! Currently I'm unable to continue configuring it properly. I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, TomCat 5.5 and jdk-6u2! The strange thing is that it has been working properly at the beginning. Setting up the layout, preferences, and saving it all wasn't a problem! Thanks! Regards, Gerard ========================================== Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken. This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
Hi Gerard, I thought I had already answered you about this this morning... I'll repeat my suggestion: try tweaking the HBM file for PostGreSQL. Alternatively try using a different database (like MYSQL) if you can as I believe the problem is why PostGreSQL. Last, check the online mail archives since several people got XWiki working with PostGreSQL with some tweakings. Thanks -Vincent On Sep 6, 2007, at 12:08 PM, Geert Verhaag wrote:
Hi XWiki Users,
I try to start a new thread about this problem, because the problem is very urgent.
This matter has been a topic around April this year as I found at jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while logged in as Admin), but wasn't really solved if I understand it all well!
I experience problems saving both my layout and preferences, getting the following message:
Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc (XWikiHibernateStore.java:314) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:100) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:94) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149) at org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process (RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java: 1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:685) at java.lang.Thread.run(Unknown Source)
Wrapped Exception:
java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set XWD_ARCHIVE=head .....
Our consideration using xwiki for our institute's wiki site is in danger because of this error! Currently I'm unable to continue configuring it properly.
I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, TomCat 5.5 and jdk-6u2!
The strange thing is that it has been working properly at the beginning. Setting up the layout, preferences, and saving it all wasn't a problem!
Thanks!
Regards, Gerard
==========================================
Dit bericht is uitsluitend bestemd voor de geadresseerde. Het bericht kan vertrouwelijke informatie bevatten. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht onmiddellijk de afzender te informeren. Ook verzoeken wij u het bericht te vernietigen en de inhoud niet onder derden te verspreiden of te gebruiken.
This message is intended exclusively for the addressee. It may contain information that is confidential. If you are not the intended recipient, we request that you notify the sender immediately. In that case, we also request that you destroy the message and that you neither use the contents nor disclose them in any manner to third parties. ==========================================
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (2)
-
Geert Verhaag -
Vincent Massol