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

[Prabhat Jha (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Prabhat Jha reassigned JBPORTAL-2258:
-------------------------------------

    Assignee: Viliam Rockai  (was: Sohil Shah)


> 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}language, <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}language, <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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira