topic Error running VacationRequest in explorer - after Submit - in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-running-vacationrequest-in-explorer-after-submit/m-p/31483#M16261 <HTML><HEAD></HEAD><BODY><SPAN>Strange characters in sql query!</SPAN><BR /><BR /><SPAN>===========================</SPAN><BR /><SPAN>&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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.getSyntaxError(Parser.java:474)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parsePrepared(Parser.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:254)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.prepareCommand(Parser.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.Session.prepareLocal(Session.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Unknown Source)</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.AbstractWebScript.createSta</SPAN><BR /><SPAN>tusException(AbstractWebScript.java:731)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.DeclarativeWebScript.execut</SPAN><BR /><SPAN>e(DeclarativeWebScript.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.PresentationContainer.execu</SPAN><BR /><SPAN>teScript(PresentationContainer.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.AbstractRuntime.executeScri</SPAN><BR /><SPAN>pt(AbstractRuntime.java:307)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.AbstractRuntime.executeScri</SPAN><BR /><SPAN>pt(AbstractRuntime.java:178)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.servlet.WebScriptServlet.se</SPAN><BR /><SPAN>rvice(WebScriptServlet.java:116)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl</SPAN><BR /><SPAN>icationFilterChain.java:290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF</SPAN><BR /><SPAN>ilterChain.java:206)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV</SPAN><BR /><SPAN>alve.java:233)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV</SPAN><BR /><SPAN>alve.java:191)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j</SPAN><BR /><SPAN>ava:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j</SPAN><BR /><SPAN>ava:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal</SPAN><BR /><SPAN>ve.java:109)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav</SPAN><BR /><SPAN>a:298)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java</SPAN><BR /><SPAN>:852)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce</SPAN><BR /><SPAN>ss(Http11Protocol.java:588)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48</SPAN><BR /><SPAN>9)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:619)</SPAN><BR /><SPAN>Caused by: org.apache.ibatis.exceptions.IbatisException:</SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error</SPAN><BR /><SPAN>in SQL statement "┬</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;&nbsp; INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ IS NULL</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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;&nbsp; inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ is null</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.getSyntaxError(Parser.java:474)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parsePrepared(Parser.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:254)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.prepareCommand(Parser.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.Session.prepareLocal(Session.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Unknown Source)</SPAN><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;&nbsp; inn</SPAN><BR /><SPAN>er join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE</SPAN><BR /><SPAN>_ is null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and I.TYPE_ = 'candidate'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ┬á ┬áorder by ID_&nbsp; ┬á</SPAN><BR /><SPAN>### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "┬</SPAN><LI>á ┬á</LI><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;&nbsp; INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ IS NULL</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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;&nbsp; inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ is null</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.getSyntaxError(Parser.java:474)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parsePrepared(Parser.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:254)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.prepareCommand(Parser.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.Session.prepareLocal(Session.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Unknown Source)</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(Exception</SPAN><BR /><SPAN>Factory.java:8)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Defau</SPAN><BR /><SPAN>ltSqlSession.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.persistence.IbatisPersistenceSession.dynamicFindTas</SPAN><BR /><SPAN>ks(IbatisPersistenceSession.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.task.TaskQueryImpl.executeList(TaskQueryImpl.java:8</SPAN><BR /><SPAN>1)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery</SPAN><BR /><SPAN>.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery</SPAN><BR /><SPAN>.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.interceptor.CommandExecutorImpl.execute(CommandExec</SPAN><BR /><SPAN>utorImpl.java:26)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.interceptor.CommandContextInterceptor.execute(Comma</SPAN><BR /><SPAN>ndContextInterceptor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.impl.query.AbstractListQuery.paginatedList(AbstractListQ</SPAN><BR /><SPAN>uery.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.rest.api.tasks.TasksGet.executeWebScript(TasksGet.java:5</SPAN><BR /><SPAN>9)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScrip</SPAN><BR /><SPAN>t.java:68)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.webscripts.DeclarativeWebScript.execut</SPAN><BR /><SPAN>e(DeclarativeWebScript.java:64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 17 more</SPAN><BR /><SPAN>Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "┬</SPAN><LI>á ┬á</LI><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;&nbsp; INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ IS NULL</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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;&nbsp; inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ is null</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and I.TYPE_ = 'candidate'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><BR /><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.getSyntaxError(Parser.java:474)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parsePrepared(Parser.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:278)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.parse(Parser.java:254)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.Parser.prepareCommand(Parser.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.Session.prepareLocal(Session.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Unknown Source)</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.SessionRemote.done(SessionRemote.java:505)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.command.CommandRemote.&lt;init&gt;(CommandRemote.java:48)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.jdbc.JdbcPreparedStatement.&lt;init&gt;(JdbcPreparedStatement.java:7</SPAN><BR /><SPAN>1)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledCon</SPAN><BR /><SPAN>nection.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy5.prepareStatement(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces</SPAN><BR /><SPAN>sorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogg</SPAN><BR /><SPAN>er.java:35)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy5.prepareStatement(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.PreparedStatementHandler.instant</SPAN><BR /><SPAN>iateStatement(PreparedStatementHandler.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(Bas</SPAN><BR /><SPAN>eStatementHandler.java:64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(</SPAN><BR /><SPAN>RoutingStatementHandler.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExec</SPAN><BR /><SPAN>utor.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java</SPAN><BR /><SPAN>:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java</SPAN><BR /><SPAN>:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Defau</SPAN><BR /><SPAN>ltSqlSession.java:59)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 27 more</SPAN></BODY></HTML> Tue, 15 Jun 2010 10:29:32 GMT activiti-admin 2010-06-15T10:29:32Z Error running VacationRequest in explorer - after Submit - https://connect.hyland.com/t5/alfresco-archive/error-running-vacationrequest-in-explorer-after-submit/m-p/31483#M16261 Strange characters in sql query!===========================&nbsp; at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.get(DbException.java:167)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.get(DbException.java:144)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.h2.message.DbException.getS Tue, 15 Jun 2010 10:29:32 GMT https://connect.hyland.com/t5/alfresco-archive/error-running-vacationrequest-in-explorer-after-submit/m-p/31483#M16261 activiti-admin 2010-06-15T10:29:32Z Re: Error running VacationRequest in explorer - after Submit - https://connect.hyland.com/t5/alfresco-archive/error-running-vacationrequest-in-explorer-after-submit/m-p/31484#M16262 <HTML><HEAD></HEAD><BODY><SPAN>If you run tomcat you can add this to the catalina.bat at the 4 %_EXECJAVA%-lines (pretty much the last ones) like this</SPAN><BR /><BR /><SPAN>%_EXECJAVA% %JAVA_OPTS% … -Dfile.encoding=UTF-8 …</SPAN></BODY></HTML> Tue, 15 Jun 2010 10:59:44 GMT https://connect.hyland.com/t5/alfresco-archive/error-running-vacationrequest-in-explorer-after-submit/m-p/31484#M16262 activiti-admin 2010-06-15T10:59:44Z