[JBoss JIRA] Created: (JBPORTAL-2258) Create file in CMS not working for several databases
by Viliam Rockai (JIRA)
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}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.
--
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
15 years, 3 months