Details
-
Bug
-
Resolution: Fixed
-
Medium
-
6.0.2
-
1
-
Severity 1 - Critical
-
Description
Summary
Unable to copy page hierarchy when using start Start titles with and Replace title text options
Environment
- Confluence 6.0.2
- SQL Server 11.00.6020
Steps to Reproduce
- Install confluence 6.0.2 and configure it with SQL server 11.00.6020 according to Database Setup for SQL Server
- Create a space with pages that contains child pages
- Click on the (...) and then pick copy
- Check "Include child pages" then hit next
- In the Start titles with put some random text, in my case new
- In the Replace title text put some random text, in my case ion
- In the With this text put some random text, in my case aaa
- Hit copy
ps: see video for more details http://recordit.co/fIquIjx70V
Expected Results
Pages should be copied and text should be replaced
Actual Results
Error is showing "Something went wrong." and pages are not copied
The below exception is thrown in the atlassian-confluence.log file:
2016-12-30 14:48:52,346 ERROR [http-nio-8090-exec-3] [engine.jdbc.spi.SqlExceptionHelper] logExceptions The replace function requires 3 argument(s).
-- referer: http://ec2-54-194-5-4.eu-west-1.compute.amazonaws.com:8090/display/OMAR/back-end+leverage+networks+-+1483105629502 | url: /rest/page-hierarchy/copy | traceId: b1d95ef835705392 | userName: admin
2016-12-30 14:48:52,347 ERROR [http-nio-8090-exec-3] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Incorrect syntax near ')'.
-- referer: http://ec2-54-194-5-4.eu-west-1.compute.amazonaws.com:8090/display/OMAR/back-end+leverage+networks+-+1483105629502 | url: /rest/page-hierarchy/copy | traceId: b1d95ef835705392 | userName: admin
2016-12-30 14:48:52,358 ERROR [http-nio-8090-exec-3] [rest.api.model.ExceptionConverter] convertServiceException No status code found for exception, converting to internal server error :
-- referer: http://ec2-54-194-5-4.eu-west-1.compute.amazonaws.com:8090/display/OMAR/back-end+leverage+networks+-+1483105629502 | url: /rest/page-hierarchy/copy | traceId: b1d95ef835705392 | userName: admin
net.sf.hibernate.HibernateException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1407)
at com.atlassian.hibernate.adapter.adapters.query.QueryV2Adapter.list(QueryV2Adapter.java:201)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
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:79)
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.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1426)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1398)
... 290 more
Caused by: java.sql.SQLException: The replace function requires 3 argument(s).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
... 305 more
caused by:
java.sql.SQLException: Incorrect syntax near ')'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:677)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: Transaction already active
at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:52)
at org.hibernate.internal.AbstractSharedSessionContract.beginTransaction(AbstractSharedSessionContract.java:387)
at com.atlassian.hibernate.util.TransactionHelper.beginTransactionCommitNested(TransactionHelper.java:28)
at com.atlassian.hibernate.adapter.adapters.session.SessionV2Adapter.beginTransaction(SessionV2Adapter.java:507)
at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:441)
... 177 more
Notes
This is working fine with other database