topic request error when trying to get own task using the explorer in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39325#M20945 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I start the h2 server</SPAN><BR /><SPAN>I start the tomcat server.</SPAN><BR /><BR /><SPAN>I have launched the demo.setup ant script.</SPAN><BR /><BR /><SPAN>I connect to activiti-explorer using the "fozzie" user.</SPAN><BR /><SPAN>I got a lot of sql error in the error log of tomcat windows like this:</SPAN><BR /><BR /><BR /><SPAN>### The error may exist in org/activiti/db/ibatis/task.mapping.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.persistence.dynamicSelectTask</SPAN><BR /><SPAN>### The error occurred while executing a query</SPAN><BR /><SPAN>### SQL: ┬á ┬áselect distinct(T.*)&nbsp; ┬á ┬á&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_TASK T&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ┬á ┬áorder</SPAN><BR /><SPAN>D_&nbsp; ┬á</SPAN><BR /><SPAN>### Cause: org.h2.jdbc.JdbcSQLException: </SPAN><STRONG>Syntax error in SQL statement</STRONG><SPAN> "┬</SPAN><LI>á ┬áSELECT DISTINCT(T.*)</LI><SPAN> ┬á ┬á</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ?</SPAN><BR /><BR /><SPAN> ┬á ┬áORDER BY ID_</SPAN><BR /><SPAN> ┬á "; SQL statement:</SPAN><BR /><SPAN>┬á ┬áselect distinct(T.*)</SPAN><BR /><SPAN> ┬á ┬á</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ACT_TASK T</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ?</SPAN><BR /><BR /><SPAN> ┬á ┬áorder by ID_</SPAN><BR /><SPAN> ┬á [42000-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.get(DbException.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.get(DbException.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.getSyntaxError(DbException.java:179)</SPAN><BR /><BR /><SPAN>any idea ? </SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 15 Jul 2010 14:03:49 GMT livingst 2010-07-15T14:03:49Z request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39325#M20945 Hi,I start the h2 serverI start the tomcat server.I have launched the demo.setup ant script.I connect to activiti-explorer using the "fozzie" user.I got a lot of sql error in the error log of tomcat windows like this:### The error may exist in org/activiti/db/ibatis/task.mapping.xml### The error may Thu, 15 Jul 2010 14:03:49 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39325#M20945 livingst 2010-07-15T14:03:49Z Re: request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39326#M20946 <HTML><HEAD></HEAD><BODY><SPAN>We are blocked. any one for help ? Many thanks.</SPAN></BODY></HTML> Fri, 16 Jul 2010 08:52:42 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39326#M20946 livingst 2010-07-16T08:52:42Z Re: request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39327#M20947 <HTML><HEAD></HEAD><BODY><SPAN>This error was in alpha 2…. and solution:</SPAN><BR /><BR /><SPAN>——————————————————————</SPAN><BR /><SPAN>You can explicitly set the encoding in the tomcat startup.bat file.</SPAN><BR /><SPAN>Insert as first line:</SPAN><BR /><SPAN>set JAVA_OPTS=-Dfile.encoding=UTF-8</SPAN></BODY></HTML> Fri, 16 Jul 2010 10:17:50 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39327#M20947 jcosano 2010-07-16T10:17:50Z Re: request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39328#M20948 <HTML><HEAD></HEAD><BODY><SPAN>It works now ! Thanks.</SPAN></BODY></HTML> Fri, 16 Jul 2010 12:55:35 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39328#M20948 livingst 2010-07-16T12:55:35Z Re: request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39329#M20949 <HTML><HEAD></HEAD><BODY><SPAN>The bug should be removed in alpha 3? Can you confirm that you were using alpha 2?</SPAN></BODY></HTML> Fri, 16 Jul 2010 16:17:57 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39329#M20949 jbarrez 2010-07-16T16:17:57Z Re: request error when trying to get own task using the explorer https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39330#M20950 <HTML><HEAD></HEAD><BODY><SPAN>I confirm : I'm using activiti-5.0.alpha2</SPAN></BODY></HTML> Mon, 19 Jul 2010 09:17:14 GMT https://connect.hyland.com/t5/alfresco-archive/request-error-when-trying-to-get-own-task-using-the-explorer/m-p/39330#M20950 livingst 2010-07-19T09:17:14Z