topic Activity-explorer 'my tasks' fail to load in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activity-explorer-my-tasks-fail-to-load/m-p/27952#M14121 <HTML><HEAD></HEAD><BODY><SPAN>New install on Windows XP. Two errors:</SPAN><BR /><BR /><SPAN>404 error getting </SPAN><A href="http://localhost:8080/activiti-explorer/res/js/activiti-form.js" rel="nofollow noopener noreferrer">http://localhost:8080/activiti-explorer/res/js/activiti-form.js</A><SPAN>.</SPAN><BR /><BR /><SPAN>and</SPAN><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>{<BR />&nbsp;&nbsp;&nbsp; "status" : <BR />&nbsp; {<BR />&nbsp;&nbsp;&nbsp; "code" : 500,<BR />&nbsp;&nbsp;&nbsp; "name" : "Internal Error",<BR />&nbsp;&nbsp;&nbsp; "description" : "An error inside the HTTP server which prevented it from fulfilling the request."<BR />&nbsp; },&nbsp; <BR />&nbsp; <BR />&nbsp; "message" : "05040012 Wrapped Exception (with status template): \r\n### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; FROM ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; from ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \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.*)&nbsp; \u00c2\u00a0 \u00c2\u00a0&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; \u00c2\u00a0 \u00c2\u00a0order by ID_&nbsp; \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&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; FROM ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; from ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \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",&nbsp; <BR />&nbsp; "exception" : "org.springframework.extensions.webscripts.WebScriptException - 05040012 Wrapped Exception (with status template): \r\n### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; FROM ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; from ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \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.*)&nbsp; \u00c2\u00a0 \u00c2\u00a0&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; \u00c2\u00a0 \u00c2\u00a0order by ID_&nbsp; \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&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; FROM ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; from ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \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",<BR />&nbsp; <BR />&nbsp; "callstack" : <BR />&nbsp; [ <BR />&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; ""&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement \"\u00c2[*]\u00a0 \u00c2\u00a0SELECT DISTINCT(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; FROM ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \n \u00c2\u00a0 \u00c2\u00a0ORDER BY ID_\n \u00c2\u00a0 \"; SQL statement:\n\u00c2\u00a0 \u00c2\u00a0select distinct(T.*)\n \u00c2\u00a0 \u00c2\u00a0&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp; from ACT_TASK T\n&nbsp;&nbsp;&nbsp;&nbsp; \n&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; T.ASSIGNEE_ = ? \n&nbsp;&nbsp; \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"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.engine.SessionRemote.done(SessionRemote.java:505)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.command.CommandRemote.prepare(CommandRemote.java:70)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.command.CommandRemote.&lt;init&gt;(CommandRemote.java:48)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.jdbc.JdbcPreparedStatement.&lt;init&gt;(JdbcPreparedStatement.java:71)"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)"<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Fri, 04 Jun 2010 19:46:19 GMT gary1 2010-06-04T19:46:19Z Activity-explorer 'my tasks' fail to load https://connect.hyland.com/t5/alfresco-archive/activity-explorer-my-tasks-fail-to-load/m-p/27952#M14121 New install on Windows XP. Two errors:404 error getting http://localhost:8080/activiti-explorer/res/js/activiti-form.js.and500 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 "Th Fri, 04 Jun 2010 19:46:19 GMT https://connect.hyland.com/t5/alfresco-archive/activity-explorer-my-tasks-fail-to-load/m-p/27952#M14121 gary1 2010-06-04T19:46:19Z Re: Activity-explorer 'my tasks' fail to load https://connect.hyland.com/t5/alfresco-archive/activity-explorer-my-tasks-fail-to-load/m-p/27953#M14122 <HTML><HEAD></HEAD><BODY><SPAN>Probably is the same that:</SPAN><BR /><A href="http://forums.activiti.org/en/viewtopic.php?f=3&amp;t=66" rel="nofollow noopener noreferrer">http://forums.activiti.org/en/viewtopic.php?f=3&amp;t=66</A></BODY></HTML> Fri, 04 Jun 2010 21:28:26 GMT https://connect.hyland.com/t5/alfresco-archive/activity-explorer-my-tasks-fail-to-load/m-p/27953#M14122 jcosano 2010-06-04T21:28:26Z