[jboss-jira] [JBoss JIRA] Resolved: (JBPORTAL-2258) Create file in CMS not working for several databases

Create file in CMS not working for several databases ---------------------------------------------------- Key: JBPORTAL-2258 URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258 Project: JBoss Portal Issue Type: Bug Security Level: Public(Everyone can see) Components: Portal CMS Affects Versions: 2.7.0 Final Reporter: Viliam Rockai Assignee: Viliam Rockai Fix For: 2.7.2 Final there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these steps on clean database. create file with: 1. login as admin 2. click admin->cms 3. select create file and create file with these parameters FileName:"testfile" Description:"testdesc" Title:"testtitle" Language: English and type "test content" into the content textarea. 4. click create after clicking create you see and error page dependent on used database. for oracle 9i: exception javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085) violated org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) root cause java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085) violated oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620) ----- for oracle 10g: exception javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442) violated org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) root cause java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442) violated oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620) ----------- for postgres: exception javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream of 28 bytes>, 33) was aborted. Call getNextException to see the cause. org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) root cause java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values (6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream of 28 bytes>, 33) was aborted. Call getNextException to see the cause. org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350) ------------ when the browsers back button is pressed, trying to click the create button again lead into new error (same for each db): ERROR Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException StackTrace: javax.portlet.PortletException: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException at org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879) at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392) at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557) at org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109) ------------------------------ the interesting part is that i.e. creation of a directory in cms is working fine at the start, but once you try to create file, you have this exception and you cannot create even the folder anymore.