Details
-
Bug
-
Resolution: Fixed
-
Highest
-
5.5-beta1
-
None
Description
Steps to Reproduce
- Setup Confluence 5.5-RC1 hooked to an Oracle DB / MS SQL
- Assign tasks to a particular user
- Logout and login as this user, and navigate to mytasks.action
Notice that your tasks page will be empty:
Error in the logs:
2014-04-18 22:27:26,516 ERROR [http-bio-8550-exec-5] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
- minor version:2
- major version:11
Driver:
- name:Oracle JDBC driver
- version:11.2.0.2.0
java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
-- referer: http://localhost:8550/c55/plugins/inlinetasks/mytasks.action | url: /c55/rest/inlinetasks/1/my-task-report/ | userName: test
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
- minor version:2
- major version:11
Driver:
- name:Oracle JDBC driver
- version:11.2.0.2.0
java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
Error is MS SQL:
[Error Code: 156, SQL State: S1000] Incorrect syntax near the keyword 'is'. with the sql statement:
select distinct t."GLOBAL_ID" , t."CONTENT_ID", t."DUE_DATE" is null, t."DUE_DATE", t."CREATE_DATE" is null, t."CREATE_DATE" from "AO_BAF3AA_AOINLINE_TASK" t join CONTENT c on t."CONTENT_ID" = c.CONTENTID join SPACES s on c.SPACEID = s.SPACEID WHERE s.SPACESTATUS <> 'ARCHIVED' AND c.CONTENT_STATUS <> 'deleted' ORDER BY t."DUE_DATE" is null ASC, t."DUE_DATE" ASC, t."CREATE_DATE" is null ASC, t."CREATE_DATE" DESC
