Error after update from 5.6 to 6.5

Question

Hello. After upgrade from 5.6 to 6.5 i have meet some errors.

When i try open tablespace -

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:224)

caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

caused by: java.sql.SQLSyntaxErrorException: ORA-01719: оператор внешнего соединения (+) не разрешен в операндах OR или IN
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

Jeroen Overbeeke · Answer

How did you upgrade?

Did you follow the upgrade steps of Atlassian or did you went from 5.6 to 6.5 in one step?

What is the database Collate?

zakirov_em · Answer

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
 at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:2123)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1911)
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1887)
 at org.hibernate.loader.Loader.doQuery(Loader.java:932)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
 at org.hibernate.loader.Loader.doList(Loader.java:2615)
 at org.hibernate.loader.Loader.doList(Loader.java:2598)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2430)
 at org.hibernate.loader.Loader.list(Loader.java:2425)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:370)
 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1481)
 at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1441)
 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1410)
 at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.lambda$findNamedQueryStringParams$5(HibernateObjectDao.java:468)
 at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:359)
 ... 496 more

zakirov_em · Answer

Caused by: java.sql.SQLSyntaxErrorException: ORA-01719: оператор внешнего соединения (+) не разрешен в операндах OR или IN

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:71)
 ... 513 more