nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Login error in Activiti Explorer (alpha2)

jcosano

I install alpha2…
Probe works fine for me but activiti explorer throws an error in authentication phase…

Tomcat windows said:

03-jun-2010 17:36:31 org.apache.commons.httpclient.HttpMethodDirector processWWW
AuthChallenge
INFO: No credentials available for BASIC 'Activiti'@localhost:8080
============================================

Into logs….

03-jun-2010 17:36:31 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() para servlet default lanzó excepción
org.springframework.extensions.surf.exception.UserFactoryException: Unable to create user - failed to retrieve user info:
   at org.activiti.surf.ActivitiUserFactory.loadUser(ActivitiUserFactory.java:186)
   at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:165)
   at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:99)
   at org.springframework.extensions.surf.RequestContextUtil.initialiseUser(RequestContextUtil.java:201)
   at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:174)
   at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:129)
   at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.populateRequestContext(AbstractWebFrameworkView.java:243)
   at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:105)
   at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
   at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
   at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
   at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
   at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
   at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
   at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Thread.java:619)

can you work with explorer?

thank you!

Find more posts tagged with

Comments

jcosano

Ubuntu works fine….

Windows throws an error (previous post…)

gary1

Windows failed for me too. But after rebooting, it worked.

However, logging in to activiti-explorer works but writes errors to tomcat log:

Jun 4, 2010 2:55:13 PM org.springframework.extensions.webscripts.AbstractRuntime executeScript<br>SEVERE: Exception from executeScript - redirecting to status template error: 05040002 Wrapped Exception (with status template): <br>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br>### The error may exist in org/activiti/db/ibatis/task.mapping.xml<br>### The error may involve org.activiti.persistence.dynamicSelectTask<br>### The error occurred while executing a query<br>### SQL: &Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)&nbsp; &Acirc;&nbsp; &Acirc;&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; &Acirc;&nbsp; &Acirc;&nbsp;order by ID_&nbsp; &Acirc;&nbsp;<br>### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br>org.springframework.extensions.webscripts.WebScriptException: 05040002 Wrapped Exception (with status template): <br>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br>### The error may exist in org/activiti/db/ibatis/task.mapping.xml<br>### The error may involve org.activiti.persistence.dynamicSelectTask<br>### The error occurred while executing a query<br>### SQL: &Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)&nbsp; &Acirc;&nbsp; &Acirc;&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; &Acirc;&nbsp; &Acirc;&nbsp;order by ID_&nbsp; &Acirc;&nbsp;<br>### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br> at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:731)<br> at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:167)<br> at org.springframework.extensions.webscripts.PresentationContainer.executeScript(PresentationContainer.java:69)<br> at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:307)<br> at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:178)<br> at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:116)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<br> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<br> at java.lang.Thread.run(Thread.java:619)<br>Caused by: org.apache.ibatis.exceptions.IbatisException: <br>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br>### The error may exist in org/activiti/db/ibatis/task.mapping.xml<br>### The error may involve org.activiti.persistence.dynamicSelectTask<br>### The error occurred while executing a query<br>### SQL: &Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)&nbsp; &Acirc;&nbsp; &Acirc;&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; &Acirc;&nbsp; &Acirc;&nbsp;order by ID_&nbsp; &Acirc;&nbsp;<br>### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br> at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)<br> at org.activiti.impl.persistence.IbatisPersistenceSession.dynamicFindTasks(IbatisPersistenceSession.java:406)<br> at org.activiti.impl.task.TaskQueryImpl.executeList(TaskQueryImpl.java:81)<br> at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery.java:63)<br> at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery.java:60)<br> at org.activiti.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:26)<br> at org.activiti.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)<br> at org.activiti.impl.query.AbstractListQuery.paginatedList(AbstractListQuery.java:60)<br> at org.activiti.rest.api.tasks.TasksGet.executeWebScript(TasksGet.java:59)<br> at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScript.java:68)<br> at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)<br> &hellip; 17 more<br>Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "&Acirc;[*]&nbsp; &Acirc;&nbsp;SELECT DISTINCT(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;ORDER BY ID_<br> &Acirc;&nbsp; "; SQL statement:<br>&Acirc;&nbsp; &Acirc;&nbsp;select distinct(T.*)<br> &Acirc;&nbsp; &Acirc;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; from ACT_TASK T<br>&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? <br>&nbsp;&nbsp; <br> &Acirc;&nbsp; &Acirc;&nbsp;order by ID_<br> &Acirc;&nbsp; [42000-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.message.DbException.getSyntaxError(DbException.java:179)<br> at org.h2.command.Parser.getSyntaxError(Parser.java:474)<br> at org.h2.command.Parser.parsePrepared(Parser.java:433)<br> at org.h2.command.Parser.parse(Parser.java:278)<br> at org.h2.command.Parser.parse(Parser.java:254)<br> at org.h2.command.Parser.prepareCommand(Parser.java:222)<br> at org.h2.engine.Session.prepareLocal(Session.java:420)<br> at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)<br> at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)<br> at java.lang.Thread.run(Unknown Source)<br><br> at org.h2.engine.SessionRemote.done(SessionRemote.java:505)<br> at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)<br> at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)<br> at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)<br> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)<br> at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)<br> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)<br> at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:225)<br> at $Proxy5.prepareStatement(Unknown Source)<br> at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:35)<br> at $Proxy5.prepareStatement(Unknown Source)<br> at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50)<br> at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64)<br> at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39)<br> at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55)<br> at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)<br> at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)<br> at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)<br> &hellip; 27 more

jcosano

Yes, I reboot and works.. but I don't known why, after a while, error appears again.

thanks!

tombaeyens

i believe this might be a known error that will be fixed in the next release. it had to do with some whitespace that windows can't handle in the file that creates the schema in the db.

wir33658

If you get Garys problem check out this http://forums.activiti.org/en/viewtopic.php?f=4&t=71&p=225&hilit=org.h2.jdbc.JdbcSQLException#p225

If you run tomcat you can add this to the catalina.bat at the 4 %_EXECJAVA%-lines (pretty much the last ones) like this

%_EXECJAVA% %JAVA_OPTS% … -Dfile.encoding=UTF-8 …

I hope this helps.