It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error after update from 5.6 to 6.5 Edited

zakirov_em Nov 13, 2017

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)

2 answers

0 votes
Nic Brough [Adaptavist] Community Leader Nov 13, 2017

Could you look through more of the stack trace please?

It looks to me like there's something issuing invalid SQL to the database, which implies a broken add-on or bug in Confluence, and the only way to determine which one of those is to look at all of the error.

0 votes
zakirov_em Nov 13, 2017

Stack Trace:[hide]

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)
 at org.springframework.orm.hibernate5.HibernateTemplate.doExecute(HibernateTemplate.java:366)
 at org.springframework.orm.hibernate5.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:326)
 at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:444)
 at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:360)
 at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:125)
 at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPageWithComments(HibernatePageDao.java:144)
 at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$2.getBySpaceAndTitle(CachingPageDao.java:106)
 at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.loadPage(CachingPageDao.java:118)
 at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.getPageWithComments(CachingPageDao.java:98)
 at com.atlassian.confluence.pages.DefaultPageManager.getPageWithComments(DefaultPageManager.java:452)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 
zakirov_em Nov 13, 2017
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
zakirov_em Nov 13, 2017
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
Jeroen Overbeeke Nov 17, 2017

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?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

1,057 views 7 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you