Activity-explorer 'my tasks' fail to load

[gary1]

New install on Windows XP. Two errors:

404 error getting http://localhost:8080/activiti-explorer/res/js/activiti-form.js.

and

500 error getting tasks, appears to be a bad SQL statement, maybe a code page problem? (I would attach a log of the complete REST response, but every filename I try, it says "The extension is not allowed.") Here's the start of the it though:

{
    "status" : 
  {
    "code" : 500,
    "name" : "Internal Error",
    "description" : "An error inside the HTTP server which prevented it from fulfilling the request."
  },  
  
  "message" : "05040012 Wrapped Exception (with status template): \r\n### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    FROM ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    from ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0order by ID_\n \u00c2\u00a0 [42000-132]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:316)\r\n\tat org.h2.message.DbException.get(DbException.java:167)\r\n\tat org.h2.message.DbException.get(DbException.java:144)\r\n\tat org.h2.message.DbException.getSyntaxError(DbException.java:179)\r\n\tat org.h2.command.Parser.getSyntaxError(Parser.java:474)\r\n\tat org.h2.command.Parser.parsePrepared(Parser.java:433)\r\n\tat org.h2.command.Parser.parse(Parser.java:278)\r\n\tat org.h2.command.Parser.parse(Parser.java:254)\r\n\tat org.h2.command.Parser.prepareCommand(Parser.java:222)\r\n\tat org.h2.engine.Session.prepareLocal(Session.java:420)\r\n\tat org.h2.server.TcpServerThread.process(TcpServerThread.java:224)\r\n\tat org.h2.server.TcpServerThread.run(TcpServerThread.java:135)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n\r\n### The error may exist in org\/activiti\/db\/ibatis\/task.mapping.xml\r\n### The error may involve org.activiti.persistence.dynamicSelectTask\r\n### The error occurred while executing a query\r\n### SQL: \u00c2\u00a0 \u00c2\u00a0select distinct(T.*)  \u00c2\u00a0 \u00c2\u00a0        from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?       \u00c2\u00a0 \u00c2\u00a0order by ID_  \u00c2\u00a0\r\n### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    FROM ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    from ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0order by ID_\n \u00c2\u00a0 [42000-132]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:316)\r\n\tat org.h2.message.DbException.get(DbException.java:167)\r\n\tat org.h2.message.DbException.get(DbException.java:144)\r\n\tat org.h2.message.DbException.getSyntaxError(DbException.java:179)\r\n\tat org.h2.command.Parser.getSyntaxError(Parser.java:474)\r\n\tat org.h2.command.Parser.parsePrepared(Parser.java:433)\r\n\tat org.h2.command.Parser.parse(Parser.java:278)\r\n\tat org.h2.command.Parser.parse(Parser.java:254)\r\n\tat org.h2.command.Parser.prepareCommand(Parser.java:222)\r\n\tat org.h2.engine.Session.prepareLocal(Session.java:420)\r\n\tat org.h2.server.TcpServerThread.process(TcpServerThread.java:224)\r\n\tat org.h2.server.TcpServerThread.run(TcpServerThread.java:135)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n",  
  "exception" : "org.springframework.extensions.webscripts.WebScriptException - 05040012 Wrapped Exception (with status template): \r\n### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    FROM ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    from ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0order by ID_\n \u00c2\u00a0 [42000-132]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:316)\r\n\tat org.h2.message.DbException.get(DbException.java:167)\r\n\tat org.h2.message.DbException.get(DbException.java:144)\r\n\tat org.h2.message.DbException.getSyntaxError(DbException.java:179)\r\n\tat org.h2.command.Parser.getSyntaxError(Parser.java:474)\r\n\tat org.h2.command.Parser.parsePrepared(Parser.java:433)\r\n\tat org.h2.command.Parser.parse(Parser.java:278)\r\n\tat org.h2.command.Parser.parse(Parser.java:254)\r\n\tat org.h2.command.Parser.prepareCommand(Parser.java:222)\r\n\tat org.h2.engine.Session.prepareLocal(Session.java:420)\r\n\tat org.h2.server.TcpServerThread.process(TcpServerThread.java:224)\r\n\tat org.h2.server.TcpServerThread.run(TcpServerThread.java:135)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n\r\n### The error may exist in org\/activiti\/db\/ibatis\/task.mapping.xml\r\n### The error may involve org.activiti.persistence.dynamicSelectTask\r\n### The error occurred while executing a query\r\n### SQL: \u00c2\u00a0 \u00c2\u00a0select distinct(T.*)  \u00c2\u00a0 \u00c2\u00a0        from ACT_TASK T            WHERE  T.ASSIGNEE_ = ?       \u00c2\u00a0 \u00c2\u00a0order by ID_  \u00c2\u00a0\r\n### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    FROM ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    from ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0order by ID_\n \u00c2\u00a0 [42000-132]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:316)\r\n\tat org.h2.message.DbException.get(DbException.java:167)\r\n\tat org.h2.message.DbException.get(DbException.java:144)\r\n\tat org.h2.message.DbException.getSyntaxError(DbException.java:179)\r\n\tat org.h2.command.Parser.getSyntaxError(Parser.java:474)\r\n\tat org.h2.command.Parser.parsePrepared(Parser.java:433)\r\n\tat org.h2.command.Parser.parse(Parser.java:278)\r\n\tat org.h2.command.Parser.parse(Parser.java:254)\r\n\tat org.h2.command.Parser.prepareCommand(Parser.java:222)\r\n\tat org.h2.engine.Session.prepareLocal(Session.java:420)\r\n\tat org.h2.server.TcpServerThread.process(TcpServerThread.java:224)\r\n\tat org.h2.server.TcpServerThread.run(TcpServerThread.java:135)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n",
  
  "callstack" : 
  [ 
       ""      ,"org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    FROM ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0   \n    from ACT_TASK T\n     \n     WHERE  T.ASSIGNEE_ = ? \n   \n \u00c2\u00a0 \u00c2\u00a0order by ID_\n \u00c2\u00a0 [42000-132]\r\n\tat org.h2.message.DbException.getJdbcSQLException(DbException.java:316)\r\n\tat org.h2.message.DbException.get(DbException.java:167)\r\n\tat org.h2.message.DbException.get(DbException.java:144)\r\n\tat org.h2.message.DbException.getSyntaxError(DbException.java:179)\r\n\tat org.h2.command.Parser.getSyntaxError(Parser.java:474)\r\n\tat org.h2.command.Parser.parsePrepared(Parser.java:433)\r\n\tat org.h2.command.Parser.parse(Parser.java:278)\r\n\tat org.h2.command.Parser.parse(Parser.java:254)\r\n\tat org.h2.command.Parser.prepareCommand(Parser.java:222)\r\n\tat org.h2.engine.Session.prepareLocal(Session.java:420)\r\n\tat org.h2.server.TcpServerThread.process(TcpServerThread.java:224)\r\n\tat org.h2.server.TcpServerThread.run(TcpServerThread.java:135)\r\n\tat java.lang.Thread.run(Unknown Source)\r\n"
      ,"org.h2.engine.SessionRemote.done(SessionRemote.java:505)"
      ,"org.h2.command.CommandRemote.prepare(CommandRemote.java:70)"
      ,"org.h2.command.CommandRemote.<init>(CommandRemote.java:48)"
      ,"org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)"
      ,"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)"
      ,"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)"
      ,"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)"
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[jcosano]

Probably is the same that:
http://forums.activiti.org/en/viewtopic.php?f=3&t=66