Hide Forgot
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.
Attachment: Added: oracle_db_error
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.
Issues is related to JCR 1.14.0.GA, EXOJCR-1521
Link: Added: This issue is related to EXOJCR-1521
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}
Should be fixed by upgrading to eXo JCR 1.14.1
Release Notes Docs Status: Added: Not Required