-
Bug
-
Resolution: Duplicate
-
Highest
-
None
-
3.5.1
-
None
-
Using Confluence 3.5.1 and SQL server 2008 or 2005
When using SQL server 2008 or 2005 and trying to move a page to another place or other space gives an error:
2011-04-06 14:37:19,123 ERROR [http-8081-9] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not
execute action url: /pages/movepage.action | userName: xxxxx | referer: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: error performing findBySQL; uncategorized SQLException
for SQL []; SQL state [S1000]; error code [421]; The ntext data type cannot be selected as DISTINCT because it is not
comparable.; nested exception is java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not
comparable.
Caused by: java.sql.SQLException: The ntext data type cannot be selected as DISTINCT because it is not comparable.
Workaround Available
See CONF-22164 for details.
- duplicates
-
CONFSERVER-22164 Many page operations: move, restricting, deleting, etc. fail with Oracle, DB2 or SQL Server
- Closed
- is caused by
-
CONFSERVER-21371 Page move fails with deep page hierarchy
- Closed