Hide Forgot
Date of First Response: 2008-12-10 10:48:01 project_key: JBEPP Please look at the failures at http://hudson.qa.jboss.com/hudson/view/EPP/job/epp-db-compat-selenium-tests/. For each db, run the test manually and verify if it's the problem with tests or problem with portal + DB combination.
It's good to see yellow stats message for runs against all DBs (http://hudson.qa.jboss.com/hudson/view/EPP/job/epp-db-compat-selenium-tests/28/). Now for each failing test with each DB, please run just that test and see the status. Before we work more on it, we need to verify that it's not setup/cleanup issue.
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when trying to create file, an error page (HTTP Status 500 - ) appears. with info like this (for oracle db): 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) ----------------------------- when i press the back button on my browser, and try to create the file again, i've got new error page then with info like this: 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 problem is very similiar with postgres db. the interesting part is that i.e. you can create a directory in cms, but once you try to create file, you have this exception and you cannot create even the folder anymore.
Link: Added: This issue depends JBPORTAL-2258