Bug 794126 (JBEPP-1192)

Summary:

Unable to start portal with oracle databases

Product:

[JBoss] JBoss Enterprise Portal Platform 5

Reporter:

vramik

Component:

unspecified

Assignee:

Default User <jbpapp-maint>

Status:

CLOSED NEXTRELEASE

QA Contact:

Severity:

high

Docs Contact:

Priority:

high

Version:

5.2.0.ER01

CC:

epp-bugs, mvanco, vrockai

Target Milestone:

---

Target Release:

5.2.0.ER02

Hardware:

Unspecified

OS:

Unspecified

URL:

http://jira.jboss.org/jira/browse/JBEPP-1192

Whiteboard:

Fixed In Version:

Doc Type:

Bug Fix

Doc Text:

Story Points:

---

Clone Of:

Environment:

Last Closed:

2011-10-03 22:18:12 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:

Attachments:

Description	Flags
oracle_db_error	none

Description vramik 2011-09-20 11:44:40 UTC

project_key: JBEPP

An error occurs when EPP is starting with oracle databases (oracle10gR2, oracle11gR1, oracle11gR1-RAC, oracle11gR2, oracle11gR2-RAC).

Same accounts and settings were used as for EPP5.1.1.

Comment 1 vramik 2011-09-20 11:45:08 UTC

Attachment: Added: oracle_db_error

Comment 2 Michal Vanco 2011-09-20 15:26:53 UTC

Important note:
Portal doesn't start only with clean database. When I checked DB backward compatibility (start 5.1.1 GA, stop, start 5.2.0 ER01 with same datasource), it works fine.

Comment 3 Michal Vanco 2011-09-20 15:57:01 UTC

Issues is related to JCR 1.14.0.GA, EXOJCR-1521

Comment 4 Michal Vanco 2011-09-20 16:25:21 UTC

Link: Added: This issue is related to EXOJCR-1521

Comment 5 Viliam Rockai 2011-09-22 12:03:48 UTC

I'm also unable to run the exo-jcr testsuite with oracle databases. The error I'm getting is:
{noformat} 
Caused by: java.io.IOException: Error indexing workspace
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex.createInitialIndex(MultiIndex.java:510)
	at org.exoplatform.services.jcr.impl.core.query.lucene.SearchIndex.reindex(SearchIndex.java:707)
	at org.exoplatform.services.jcr.impl.core.query.lucene.SearchIndex.doInit(SearchIndex.java:671)
	at org.exoplatform.services.jcr.impl.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:114)
	at org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter.<init>(DefaultChangesFilter.java:68)
	... 68 more
Caused by: javax.jcr.RepositoryException: ORA-00918: column ambiguously defined
: ORA-00918: column ambiguously defined

	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.getNodesAndProperties(JDBCStorageConnection.java:1164)
	at org.exoplatform.services.jcr.impl.storage.jdbc.indexing.JdbcNodeDataIndexingIterator.next(JdbcNodeDataIndexingIterator.java:123)
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1904)
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex.access$2500(MultiIndex.java:101)
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex$9.call(MultiIndex.java:1968)
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex$9.call(MultiIndex.java:1965)
	at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex$MultithreadedIndexing$2.run(MultiIndex.java:3497)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
	at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.OracleSingleDbJDBCConnection.findNodesAndProperties(OracleSingleDbJDBCConnection.java:123)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.getNodesAndProperties(JDBCStorageConnection.java:1107)
	... 7 more
{noformat}

Comment 6 Thomas Heute 2011-10-03 22:18:12 UTC

Should be fixed by upgrading to eXo JCR 1.14.1

Comment 7 Thomas Heute 2011-10-03 22:18:12 UTC

Release Notes Docs Status: Added: Not Required