Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error SQL in Activiti Explorer

jcosano
Champ in-the-making
Champ in-the-making

‎06-04-2010 03:27 AM

Activiti Alpha 2 in ubuntu works fine… but in windows i have an error inside Activiti Explorer.
Only with this queries… other queries seem run ok

09:20:20,062 FIN  | org.activiti.impl.interceptor.CommandContextInterceptor | === starting command org.activiti.impl.cmd.FindGroupsByUserCmd@a998c1 ===========================================
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | Created connection 7055953.
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | ooo Connection Opened
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | ==>  Executing: select g.* from ACT_ID_GROUP g, ACT_ID_MEMBERSHIP membership where g.ID_ = membership.GROUP_ID_ and membership.USER_ID_ = ? and g.TYPE_ = ? 
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | ==> Parameters: kermit(String), security-role(String)
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | <==    Columns: ID_, REV_, NAME_, TYPE_
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | <==        Row: admin, 1, System administrator, security-role
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | <==        Row: manager, 1, Manager, security-role
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | xxx Connection Closed
09:20:20,077 FIN  | org.apache.ibatis.logging.jdk14.Jdk14LoggingImpl | Closed connection 7055953.
‍‍‍‍‍‍‍‍‍‍‍

04-jun-2010 9:20:20 org.springframework.extensions.webscripts.AbstractRuntime executeScript
GRAVE: Exception from executeScript - redirecting to status template error: 05040000 Wrapped Exception (with status template): 
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: 05040000 Wrapped Exception (with status template): 
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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: Error de Sintaxis en sentencia SQL "Â[*]   SELECT DISTINCT(T.*)
       
    FROM ACT_TASK T
     
     WHERE  T.ASSIGNEE_ = ? 
   
    ORDER BY ID_
   "
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.GeneratedMethodAccessor64.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.GeneratedMethodAccessor64.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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
Labels:
0 Kudos
10 REPLIES 10

jcosano
Champ in-the-making
Champ in-the-making

‎06-08-2010 11:18 AM

I think you should download activiti-modeler-5.0.alpha2.war again… (maybe war is corrupted…)

then… for reinstall all maybe you can do this:

ant demo.teardown
delete <activiti folder>\setup\build\activiti-modeler-5.0.alpha2.war
delete <activiti folder>\apps\apache-tomcat-6.0.26\webapps\activiti-modeler.war
delete <activiti folder>\apps\apache-tomcat-6.0.26\webapps\activiti-modeler    (folder)
ant demo.setup

the size of this war is 33.9 mb, so, time to download this file can be high…
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2026 Khoros, LLC