Bug 792947 (JBEPP-25)

Summary:	fix selenium tests running with multiple DBs
Product:	[JBoss] JBoss Enterprise Portal Platform 4	Reporter:	Prabhat Jha <prabhat.jha>
Component:	Portal	Assignee:	Viliam Rockai <vrockai>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3.0.GA	CC:	epp-bugs, theute
Target Milestone:	---
Target Release:	4.3.0.GA
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/JBEPP-25
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-02-02 16:01:30 UTC	Type:	Task
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Prabhat Jha 2008-12-01 21:52:17 UTC

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.

Comment 1 Prabhat Jha 2008-12-09 15:08:52 UTC

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.

Comment 2 Viliam Rockai 2008-12-10 15:48:01 UTC

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.

Comment 3 Viliam Rockai 2008-12-10 16:15:51 UTC

Link: Added: This issue depends JBPORTAL-2258