Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 879670

Summary: DBInitializerException When starting portal on oracle DBs
Product: [JBoss] JBoss Enterprise Portal Platform 6 Reporter: vramik
Component: PortalAssignee: Default User <jbpapp-maint>
Status: CLOSED CURRENTRELEASE QA Contact: vramik
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: bdawidow, epp-bugs, hfnukal
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-04-16 08:55:50 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description vramik 2012-11-23 16:16:34 UTC 
Description of problem:
Portal doesn't start with all oracle databases (R1, R1-RAC, R2, R2-RAC).

There are links to logs:

https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/6.0/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR2RAC/25/consoleText

https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/6.0/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR2/19/consoleText

https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/6.0/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR1RAC/35/consoleText

https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/6.0/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR1/27/consoleText
Comment 1 Viliam Rockai 2012-11-26 17:34:48 UTC 
The problem is caused by Oracle DB constrain - the name of identifier can't be longer then 30 characters. If the isolated JCR mode is set (gatein.jcr.db-structure-type=isolated in configuration.properties), the JCR tries to create objects with identifiers longer then 30 chars, i.e.: JCR_IDX_IPORTALSYSTEM_PARENT_FK, which leads to the "ORA-00972: identifier is too long" error.

I can think of 3 different ways to resolve this problem:
1. (Prefered) Turn off the "isolated" mode and use "single" as in the previous EPP/JPP versions. The isolated mode can be a feature of JPP, which is not turned on by default.

2. Rename the JPP workspaces to much shorter names, like "portal-system"-"p-sys", "portal-work"->"p-work". 

3. Reconfigure databases in the lab. I'm not sure if this is possible to do.
Comment 2 Viliam Rockai 2012-11-28 15:14:37 UTC 
The problem is in the datasouce configuration. You are disabling the JTA (setting jta=false), but the default value in gatein/jpp is jta=true. Deleting jta=false from the datasouce configuration (true is the default value) resolves this problem.