topic Error running alpha2 examples FinanicalReportProcessTest!!!! in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-running-alpha2-examples-finanicalreportprocesstest/m-p/28036#M14175 <HTML><HEAD></HEAD><BODY><SPAN>FinancialReportProcessTest(TestCase).runTest() line: 171&nbsp;&nbsp;&nbsp;</SPAN><BR /><BR /><BR /><BR /><BR /><SPAN>12:35:23,084 SEV&nbsp; | org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl | Error calling Connection.prepareStatement:</SPAN><BR /><SPAN>org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "Â</SPAN><LI>Â&nbsp;SELECT DISTINCT(T.*)</LI><SPAN> Â&nbsp; Â&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; FROM ACT_TASK T</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.USER_ID_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) </SPAN><BR /><SPAN>&nbsp;&nbsp; </SPAN><BR /><SPAN> Â&nbsp; Â&nbsp;ORDER BY ID_</SPAN><BR /><SPAN> Â&nbsp; "; SQL statement:</SPAN><BR /><SPAN>Â&nbsp; Â&nbsp;select distinct(T.*)</SPAN><BR /><SPAN> Â&nbsp; Â&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ACT_TASK T</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.USER_ID_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><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 /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) </SPAN><BR /><SPAN>&nbsp;&nbsp; </SPAN><BR /><SPAN> Â&nbsp; Â&nbsp;order by ID_</SPAN><BR /><SPAN> Â&nbsp; [42000-132]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144)</SPAN></BODY></HTML> Sat, 05 Jun 2010 07:06:15 GMT activiti-admin 2010-06-05T07:06:15Z Error running alpha2 examples FinanicalReportProcessTest!!!! https://connect.hyland.com/t5/alfresco-archive/error-running-alpha2-examples-finanicalreportprocesstest/m-p/28036#M14175 FinancialReportProcessTest(TestCase).runTest() line: 171&nbsp;&nbsp;&nbsp;12:35:23,084 SEV&nbsp; | org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl | Error calling Connection.prepareStatement<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ÂÂ&nbsp;SELECT DISTINCT(T.*) Â&nbsp; Â&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; FROM ACT_TASK T&nbsp;&nbsp;&nbsp;&nbsp; Sat, 05 Jun 2010 07:06:15 GMT https://connect.hyland.com/t5/alfresco-archive/error-running-alpha2-examples-finanicalreportprocesstest/m-p/28036#M14175 activiti-admin 2010-06-05T07:06:15Z Re: Error running alpha2 examples FinanicalReportProcessTest!!!! https://connect.hyland.com/t5/alfresco-archive/error-running-alpha2-examples-finanicalreportprocesstest/m-p/28037#M14176 <HTML><HEAD></HEAD><BODY><SPAN>Set an explicit encoding in the JUNIT Run Configuration for this processs</SPAN><BR /><SPAN>–&gt; VM Agument: -Dfile.encoding=UTF-8 (or -Dfile.encoding=ISO-8859-1)</SPAN></BODY></HTML> Sun, 06 Jun 2010 07:17:01 GMT https://connect.hyland.com/t5/alfresco-archive/error-running-alpha2-examples-finanicalreportprocesstest/m-p/28037#M14176 stefanklose 2010-06-06T07:17:01Z