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!

[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
SEVERE: Exception from executeScript - redirecting to status template error: 05040002 Wrapped Exception (with status template):
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

### The error may exist in org/activiti/db/ibatis/task.mapping.xml
### The error may involve org.activiti.persistence.dynamicSelectTask
### The error occurred while executing a query
### SQL:    select distinct(T.*)             from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?          order by ID_   
### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

org.springframework.extensions.webscripts.WebScriptException: 05040002 Wrapped Exception (with status template):
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

### The error may exist in org/activiti/db/ibatis/task.mapping.xml
### The error may involve org.activiti.persistence.dynamicSelectTask
### The error occurred while executing a query
### SQL:    select distinct(T.*)             from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?          order by ID_   
### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:731)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:167)
at org.springframework.extensions.webscripts.PresentationContainer.executeScript(PresentationContainer.java:69)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:307)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:178)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:116)
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.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)
Caused by: org.apache.ibatis.exceptions.IbatisException:
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

### The error may exist in org/activiti/db/ibatis/task.mapping.xml
### The error may involve org.activiti.persistence.dynamicSelectTask
### The error occurred while executing a query
### SQL:    select distinct(T.*)             from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?          order by ID_   
### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
at org.activiti.impl.persistence.IbatisPersistenceSession.dynamicFindTasks(IbatisPersistenceSession.java:406)
at org.activiti.impl.task.TaskQueryImpl.executeList(TaskQueryImpl.java:81)
at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery.java:63)
at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery.java:60)
at org.activiti.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:26)
at org.activiti.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
at org.activiti.impl.query.AbstractListQuery.paginatedList(AbstractListQuery.java:60)
at org.activiti.rest.api.tasks.TasksGet.executeWebScript(TasksGet.java:59)
at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScript.java:68)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
… 17 more
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â[*]   SELECT DISTINCT(T.*)
     
    FROM ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   ORDER BY ID_
  "; SQL statement:
   select distinct(T.*)
     
    from ACT_TASK T
    
     WHERE  T.ASSIGNEE_ = ?
  
   order by ID_
  [42000-132]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:474)
at org.h2.command.Parser.parsePrepared(Parser.java:433)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
at org.h2.command.Parser.prepareCommand(Parser.java:222)
at org.h2.engine.Session.prepareLocal(Session.java:420)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
at java.lang.Thread.run(Unknown Source)

at org.h2.engine.SessionRemote.done(SessionRemote.java:505)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)
at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:225)
at $Proxy5.prepareStatement(Unknown Source)
at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:35)
at $Proxy5.prepareStatement(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:50)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:64)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:39)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:55)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
… 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.