SQL Power Software Forum

Hi,
The first time installed 1.3.2 under winxp, mysql and was able to do all as narrated in the guide. Able to connect to datasource,cube, xml/a (pentaho). Able to create new workspace and also create new queries (relational and olap).When i try to view through http://localhost:8080/wabit-enterprise/static/thin-client/index.html I am unable to view any contents. Am i missing something here?

Secondly, today when i started the server, it failed to start and am posting the log details. one captured from the tomcat screen display and another taken from under the logs directory.

tomcat screen display

Sep 9, 2010 4:07:12 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performanc
e in production environments was not found on the java.library.path: C:\Java\jdk
1.6.0\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sy
stem32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell
\v1.0
Sep 9, 2010 4:07:13 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 9, 2010 4:07:13 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1520 ms
Sep 9, 2010 4:07:13 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 9, 2010 4:07:13 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Sep 9, 2010 4:07:26 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Sep 9, 2010 4:07:26 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/wabit-enterprise] startup failed due to previous errors
Sep 9, 2010 4:07:26 AM org.apache.catalina.core.StandardContext start
SEVERE: Exception during cleanup after start failed
java.lang.NoClassDefFoundError: edu/emory/mathcs/backport/java/util/concurrent/T
hreadFactory
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at java.sql.DriverManager.getCallerClass(DriverManager.java:477)
at java.sql.DriverManager.getDrivers(DriverManager.java:373)
at org.apache.catalina.loader.WebappClassLoader.clearReferences(WebappCl
assLoader.java:1606)
at org.apache.catalina.loader.WebappClassLoader.stop(WebappClassLoader.j
ava:1524)
at org.apache.catalina.loader.WebappLoader.stop(WebappLoader.java:707)
at org.apache.catalina.core.StandardContext.stop(StandardContext.java:46
11)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
474)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:987)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:909)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:314)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
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:5
16)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710

at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:28

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Sep 9, 2010 4:07:26 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 9, 2010 4:07:26 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Sep 9, 2010 4:07:26 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
Sep 9, 2010 4:07:26 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 13198 ms
--------------------------
This one is from the localhost.log

Sep 9, 2010 4:07:15 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Sep 9, 2010 4:07:15 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Sep 9, 2010 4:07:25 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class ca.sqlpower.wabit.enterprise.ServletContextInitializer
java.lang.RuntimeException: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:217)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
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:526)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
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:722)
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:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
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:28

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:199)
... 24 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.getInstance(WabitJackrabbitRepositoryManager.java:354)
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:197)
... 24 more
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.seedWithDefaultSecuritySettings(WabitJackrabbitRepositoryManager.java:150)
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.<init>(WabitJackrabbitRepositoryManager.java:9

at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.getInstance(WabitJackrabbitRepositoryManager.java:351)
... 25 more
Caused by: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.enterprise.client.SPServerInfo.<init>(SPServerInfo.java:59)
at ca.sqlpower.wabit.WabitSessionContextImpl.readServersFromPrefs(WabitSessionContextImpl.java:366)
at ca.sqlpower.wabit.WabitSessionContextImpl.<init>(WabitSessionContextImpl.java:227)
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.seedWithDefaultSecuritySettings(WabitJackrabbitRepositoryManager.java:115)
... 27 more
Sep 9, 2010 4:07:25 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Sep 9, 2010 4:07:26 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Sep 9, 2010 4:09:01 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
Sep 9, 2010 4:09:01 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
Sep 9, 2010 4:09:31 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Sep 9, 2010 4:09:31 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Sep 9, 2010 4:09:34 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class ca.sqlpower.wabit.enterprise.ServletContextInitializer
java.lang.RuntimeException: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:217)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
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:526)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
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:722)
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:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
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:28

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:199)
... 24 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.getInstance(WabitJackrabbitRepositoryManager.java:354)
at ca.sqlpower.wabit.enterprise.ServletContextInitializer.contextInitialized(ServletContextInitializer.java:197)
... 24 more
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.seedWithDefaultSecuritySettings(WabitJackrabbitRepositoryManager.java:150)
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.<init>(WabitJackrabbitRepositoryManager.java:9

at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.getInstance(WabitJackrabbitRepositoryManager.java:351)
... 25 more
Caused by: java.lang.IllegalArgumentException: path must begin with a /
at ca.sqlpower.enterprise.client.SPServerInfo.<init>(SPServerInfo.java:59)
at ca.sqlpower.wabit.WabitSessionContextImpl.readServersFromPrefs(WabitSessionContextImpl.java:366)
at ca.sqlpower.wabit.WabitSessionContextImpl.<init>(WabitSessionContextImpl.java:227)
at ca.sqlpower.wabit.enterprise.WabitJackrabbitRepositoryManager.seedWithDefaultSecuritySettings(WabitJackrabbitRepositoryManager.java:115)
... 27 more
Sep 9, 2010 4:09:34 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Sep 9, 2010 4:09:35 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Sep 9, 2010 4:09:51 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
Sep 9, 2010 4:09:51 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()

Appreciate your help.
Regards

Hi Bapajan,

The first issue looks like a known issue with the web client in 1.3.2, and should be fixed in the next release which will be coming soon.

As for the second issue, we will have to investigate further.

Hi Bapajan,

From the error logs it appears that an invalid server URL was placed in the Java preferences for the SQL Power Wabit server. I have not found out how the invalid server URL made it to your Java preferences but if you clear out the server's preferences the server should start again. (The method to clear out your Java preferences for the SQL Power Wabit server depends on your operating system.)

Thank you for the replies. I am running on win xp and how do i clear the java preferences?
Regards