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

[Viliam Rockai (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12442201#action_12442201 ] 

Viliam Rockai commented on JBPORTAL-2258:
-----------------------------------------

this is what i've found discovering http://www.jboss.com/index.html?module=bb&op=viewtopic&t=147155
maybe it can help...

when you create or upload file, you got errors as written above, but the file is there in cms, you can see it in directory structure - seems like the system thought the file was created correctly and has remember it in some inner representation, but after you restart jboss, the file is gone. 

i think this can be another error, that system doesn't know correctly when database insert fails (maybe due the http error)

> 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: Sohil Shah
>             Fix For: 2.7.1 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