topic Error SQL in Activiti Explorer in Alfresco Archive

Error SQL in Activiti Explorer

jcosano — Fri, 04 Jun 2010 07:27:39 GMT

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 ok09:20:20,062 FIN | org.activiti.impl.interceptor.CommandContextInterceptor | === starting command org.activiti.impl.cmd.FindGroupsByUserCmd@a998c1 ========

Re: Error SQL in Activiti Explorer

jbarrez — Fri, 04 Jun 2010 12:05:26 GMT

I tried running Explorer on Ubuntu (latest) here, but I didn't see any error.
What functionality did you use in Explorer?

Re: Error SQL in Activiti Explorer

jcosano — Fri, 04 Jun 2010 12:09:04 GMT

In Ubuntu works fine all….

But in other machine with Windows SO, activi explorer can't load task list… I have sql error attached before…

Re: Error SQL in Activiti Explorer

jbarrez — Fri, 04 Jun 2010 12:28:17 GMT

Sorry, I misread 🙂
I've just tried it on Windows and indeed the task list fails. If I see the logs, it looks like an encoding problem…which must have slipped in there pretty recently I'm afraid. I'll investigate what's the cause.

Re: Error SQL in Activiti Explorer

stefanklose — Fri, 04 Jun 2010 13:53:08 GMT

You can explicitly set the encoding in the tomcat startup.bat file.
Inser as first line:
set JAVA_OPTS=-Dfile.encoding=UTF-8

Re: Error SQL in Activiti Explorer

jcosano — Fri, 04 Jun 2010 21:26:42 GMT

I'll try next monday… (I have Ubuntu at home)

Re: Error SQL in Activiti Explorer

ccappuccino — Sun, 06 Jun 2010 16:12:26 GMT

Cause should be here:
in this File: org/activiti/db/ibatis/task.mapping.xml.
in this Line: 74 – 78, the select statement's id is "dynamicSelectTask".
there are some error "space" format here.(On Windows Platform Running)
How: you should revise this statement (i.e. in Editplus or UltraEdit to adjust these format), and put this file into the "activiti-engine-5.0.alpha2.jar" again(file should be located at org/activiti/db/ibatis), and put this jar file into the Tomcat's "lib" directory according. Restart tomcat, it should work well.

Re: Error SQL in Activiti Explorer

benny1 — Mon, 07 Jun 2010 09:09:34 GMT

The solution is OK now BUT would it not be easier to correct the download-file of alpha2 !

Re: Error SQL in Activiti Explorer

jcosano — Mon, 07 Jun 2010 09:22:38 GMT

I modified startup.bat (setting UTF-8 encoding) and now works fine!

thank You!!

Re: Error SQL in Activiti Explorer

activiti-admin — Tue, 08 Jun 2010 11:25:22 GMT

Hi, Thanks for the tip of changing encoding. I am just starting the tool for the very first time and also faced this error. Also when starting the demo again it overrides tomcat and everything in case default target used - could there be some other default target? Or could it check if the tomcat is already there? Also when starting Tomcat this kind of exception occurs (I am not sure if it affects anywhere, but is a bit suspicious..). Thanks.

SEVERE: Exception fixing docBase for context [/activiti-modeler]
java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:114)
at java.util.jar.JarFile.<init>(JarFile.java:133)
at java.util.jar.JarFile.<init>(JarFile.java:70)
at sun.net.www.protocol.jar.URLJarFile.<init>(URLJarFile.java:72)
at sun.net.www.protocol.jar.URLJarFile.getJarFile(URLJarFile.java:48)
at sun.net.www.protocol.jar.JarFileFactory.get(JarFileFactory.java:80)
at sun.net.www.protocol.jar.JarURLConnection.connect(JarURLConnection.java:104)
at sun.net.www.protocol.jar.JarURLConnection.getJarFile(JarURLConnection.java:71)
at org.apache.catalina.startup.ExpandWar.expand(ExpandWar.java:148)
at org.apache.catalina.startup.ContextConfig.fixDocBase(ContextConfig.java:882)
at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:1017)
at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:279)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.StandardContext.init(StandardContext.java:5439)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4215)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
8.6.2010 14:21:25 org.apache.catalina.core.StandardContext resourcesStart
SEVERE: Error starting static Resources
java.lang.IllegalArgumentException: Invalid or unreadable WAR file : error in opening zip file
at org.apache.naming.resources.WARDirContext.setDocBase(WARDirContext.java:135)
at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:4086)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4255)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Re: Error SQL in Activiti Explorer

jcosano — Tue, 08 Jun 2010 15:18:38 GMT

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…