topic Error happend when I try to get tasks!Please help me. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194486#M147616 <HTML><HEAD></HEAD><BODY><SPAN>Error message:</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; </SPAN><BR /><SPAN>check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LIMIT 2147483647 OFFSET 0' at line 15</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Task.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select distinct RES.* from ACT_RU_TASK RES&nbsp; WHERE&nbsp; RES.ASSIGNEE_ = ?&nbsp; order by&nbsp; order by RES.ID_ asc&nbsp; LIMIT ? OFFSET ?</SPAN><BR /><SPAN>### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;&nbsp; </SPAN><BR /><SPAN>check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LIMIT 2147483647 OFFSET 0' at line 15</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:426)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:417)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.TaskEntityManager.findTasksByQueryCriteria(TaskEntityManager.java:135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:1189)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:158)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at net.sinocredit.fitp.workflow.WorkFlowServiceActivitiImpl.fetchTaskByUserid(WorkFlowServiceActivitiImpl.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at net.sinocredit.fitp.workflow.WorkflowWaoTest.testFetchTaskByUserid(WorkflowWaoTest.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.junit.runners.ParentRunner.run(ParentRunner.java:300)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)</SPAN><BR /><SPAN>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; </SPAN><BR /><SPAN>check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LIMIT 2147483647 OFFSET 0' at line 15</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:384)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 41 more</SPAN><BR /><BR /></BODY></HTML> Wed, 29 Jul 2015 07:11:04 GMT looyli 2015-07-29T07:11:04Z Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194486#M147616 Error message<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'orde Wed, 29 Jul 2015 07:11:04 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194486#M147616 looyli 2015-07-29T07:11:04Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194487#M147617 <HTML><HEAD></HEAD><BODY><SPAN>below is the code:</SPAN><BR /><BR /><SPAN>taskService.createTaskQuery().taskAssignee(userid).list()</SPAN></BODY></HTML> Wed, 29 Jul 2015 07:12:34 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194487#M147617 looyli 2015-07-29T07:12:34Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194488#M147618 <HTML><HEAD></HEAD><BODY><SPAN>I found that "### SQL: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? order by order by RES.ID_ asc LIMIT ? OFFSET ?".</SPAN><BR /><BR /><SPAN>Why there are two "order by"?</SPAN></BODY></HTML> Wed, 29 Jul 2015 07:20:53 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194488#M147618 looyli 2015-07-29T07:20:53Z Re: Error happend when I try to get tasks!Please help me. https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194489#M147619 <HTML><HEAD></HEAD><BODY><SPAN>I have resolved the problem. The version of mybatis is wrong. I downgraded the version to 3.2.5 and it works.</SPAN></BODY></HTML> Wed, 29 Jul 2015 08:00:22 GMT https://connect.hyland.com/t5/alfresco-archive/error-happend-when-i-try-to-get-tasks-please-help-me/m-p/194489#M147619 looyli 2015-07-29T08:00:22Z