ReportServer Forum

scorpio001

Member

Registered: 2014-03-21

Installation issue

I have followed the instructions and running on a 32 bit windows OS.

I am able to connect to the database. However I am getting an error

01:24:33,375  INFO TableMetadata:65 - HHH000261: Table found: reportserver.rs_blatext_param_inst_a
01:24:33,375  INFO TableMetadata:66 - HHH000037: Columns: [id, rev]
01:24:34,859  INFO TableMetadata:65 - HHH000261: Table found: reportserver.rs_column
01:24:34,859  INFO TableMetadata:66 - HHH000037: Columns: [position, null_handling, name_field, subtotal_group, alias, hidden, entity_version, order_field, aggregate_function, filter_id, format_id, type, entity_id, null_replacement_format]
21-Mar-2014 01:24:34.875 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Error filterStart
21-Mar-2014 01:24:34.875 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/ReportServer] startup failed due to previous errors
21-Mar-2014 01:24:36.859 WARNING [localhost-startStop-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile datasources/internaldb.cf could not be loaded. Default values are in effect.
com.google.inject.ProvisionException: Guice provision errors:

1) Error in custom provider, java.lang.NullPointerException
  while locating com.google.inject.persist.jpa.JpaPersistService
  while locating javax.persistence.EntityManager

1 error
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
        at net.datenwerke.rs.utils.simplequery.byatt.QueryByAttProcessor.process(QueryByAttProcessor.java:62)
        at net.datenwerke.rs.utils.simplequery.byatt.QueryByAttInterceptor.invoke(QueryByAttInterceptor.java:25)
        at net.datenwerke.rs.terminal.service.terminal.vfs.hooks.TreeBasedVirtualFileSystem.getNodeByLocation(TreeBasedVirtualFileSystem.java:107)
        at net.datenwerke.rs.terminal.service.terminal.vfs.hooks.TreeBasedVirtualFileSystem.getLocation(TreeBasedVirtualFileSystem.java:60)
        at net.datenwerke.rs.terminal.service.terminal.vfs.VirtualFileSystemDeamon.getLocation(VirtualFileSystemDeamon.java:142)
        at net.datenwerke.rs.terminal.service.terminal.vfs.VirtualFileSystemDeamon.getAbsoluteLocation(VirtualFileSystemDeamon.java:104)
        at net.datenwerke.rs.terminal.service.terminal.vfs.VirtualFileSystemDeamon.getLocation(VirtualFileSystemDeamon.java:80)
        at net.datenwerke.rs.terminal.service.terminal.vfs.hookers.VfsObjectResolver.getParentLocation(VfsObjectResolver.java:81)
        at net.datenwerke.rs.terminal.service.terminal.vfs.hookers.VfsObjectResolver.consumes(VfsObjectResolver.java:23)
        at net.datenwerke.rs.terminal.service.terminal.objresolver.ObjectResolverDeamon.getObjects(ObjectResolverDeamon.java:60)
        at net.datenwerke.rs.terminal.service.terminal.objresolver.ObjectResolverDeamon.getObjects(ObjectResolverDeamon.java:88)
        at net.datenwerke.rs.terminal.service.terminal.objresolver.ObjectResolverDeamon.getObjects(ObjectResolverDeamon.java:84)
        at net.datenwerke.rs.terminal.service.terminal.TerminalServiceImpl.getObjectsByLocation(TerminalServiceImpl.java:101)
        at net.datenwerke.rs.terminal.service.terminal.TerminalServiceImpl.getObjectByLocation(TerminalServiceImpl.java:112)
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfig(ConfigServiceImpl.java:85)
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfig(ConfigServiceImpl.java:76)
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe(ConfigServiceImpl.java:67)
        at net.datenwerke.rs.core.service.internaldb.InternalDbModule.provideDbLocation(InternalDbModule.java:37)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.google.inject.internal.ProviderMethod.get(ProviderMethod.java:104)
        at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at net.datenwerke.rs.core.service.internaldb.InternalDbServiceImpl.getLocation(InternalDbServiceImpl.java:81)
        at net.datenwerke.rs.core.service.internaldb.InternalDbServiceImpl.clearDatabase(InternalDbServiceImpl.java:114)
        at net.datenwerke.rs.core.service.internaldb.hookers.ClearInternalDbOnShutdown.contextDestroyed(ClearInternalDbOnShutdown.java:26)
        at net.datenwerke.gf.DwGwtFrameworkBase.contextDestroyed(DwGwtFrameworkBase.java:88)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4871)
        at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5499)
        at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:702)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:698)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1119)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1760)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
        at com.google.inject.persist.jpa.JpaPersistService.begin(JpaPersistService.java:70)
        at com.google.inject.persist.jpa.JpaPersistService.get(JpaPersistService.java:50)
        at com.google.inject.persist.jpa.JpaPersistService.get(JpaPersistService.java:34)
        at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        ... 45 more

21-Mar-2014 01:24:36.968 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesJdbc The web application [/ReportServer] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
21-Mar-2014 01:24:36.968 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [com.google.inject.internal.util.$Finalizer] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [Thread-6] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [Thread-7] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [Thread-8] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:36.984 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:37.015 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 01:24:37.015 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@7e9cab]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@5fdd61]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 01:24:37.015 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@7e9cab]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@1bf12a6]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 01:24:37.015 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@7e9cab]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@47a326]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 01:24:37.015 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@7e9cab]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@128452b]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 01:24:37.453 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\tomcat\apache-tomcat-8.0.0-RC5\webapps\ROOT
21-Mar-2014 01:24:38.156 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
21-Mar-2014 01:24:38.171 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
21-Mar-2014 01:24:38.265 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 82380 ms
21-Mar-2014 01:25:02.078 INFO [C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-AdminTaskTimer] org.apache.catalina.loader.WebappClassLoader.loadClass Illegal access: this web application instance has been stopped already.  Could not load com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1461)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkIdleResources(BasicResourcePool.java:1584)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$2000(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$CheckIdleResourcesTask.run(BasicResourcePool.java:2116)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)

Exception in thread "C3P0PooledConnectionPoolManager[identityToken->1hge138901r6tt321afkfdq|e2b390]-AdminTaskTimer" java.lang.NoClassDefFoundError: com/mchange/v2/resourcepool/BasicResourcePool$AsyncTestIdleResourceTask
        at com.mchange.v2.resourcepool.BasicResourcePool.checkIdleResources(BasicResourcePool.java:1584)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$2000(BasicResourcePool.java:44)
        at com.mchange.v2.resourcepool.BasicResourcePool$CheckIdleResourcesTask.run(BasicResourcePool.java:2116)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)
Caused by: java.lang.ClassNotFoundException: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1575)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        ... 5 more

tomharney

Member

Registered: 2014-03-11

Re: Installation issue

What is the version number?  For example, RS2.1.6-5543?   And did you use the quick installer?  Or did you roll your own and install it manually using the zip download?   Since you indicated 32-bit, I assume maybe you rolled your own?

scorpio001

Member

Registered: 2014-03-21

Re: Installation issue

Hi Tom

I rolled my own with Tomcat 8.0.0.RC5 and MySQL 5.5
I used the version RS2.1.6-5543

I looked into localhost log file and think there is a problem with the SQL create scripts. Any ideas

21-Mar-2014 00:30:13.593 INFO [localhost-startStop-2] org.apache.catalina.core.ApplicationContext.log SessionListener: contextDestroyed()
21-Mar-2014 00:30:13.593 INFO [localhost-startStop-2] org.apache.catalina.core.ApplicationContext.log ContextListener: contextDestroyed()
21-Mar-2014 01:23:21.312 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log ContextListener: contextInitialized()
21-Mar-2014 01:23:21.312 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log SessionListener: contextInitialized()
21-Mar-2014 01:24:34.875 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.filterStart Exception starting filter guiceFilter
javax.persistence.PersistenceException: [PersistenceUnit: reportServerPU] Unable to build EntityManagerFactory
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:924)
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899)
    at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)
    at com.google.inject.persist.jpa.JpaPersistService.start(JpaPersistService.java:94)
    at com.google.inject.persist.PersistFilter.init(PersistFilter.java:77)
    at com.google.inject.servlet.FilterDefinition.init(FilterDefinition.java:114)
    at com.google.inject.servlet.ManagedFilterPipeline.initPipeline(ManagedFilterPipeline.java:98)
    at com.google.inject.servlet.GuiceFilter.init(GuiceFilter.java:172)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:107)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4665)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:702)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:698)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1119)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1760)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.HibernateException: Wrong column type in reportserver.rs_column for column hidden. Found: bit, expected: boolean
    at org.hibernate.mapping.Table.validateColumns(Table.java:373)
    at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1284)
    at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:155)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:508)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1769)
    at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)
    ... 25 more

tomharney

Member

Registered: 2014-03-11

Re: Installation issue

Try going back to RS2.1.4-5528.   I've had problems with 2.1.5 and 2.1.6.   I believe we're operating on the bleeding edge!

Or maybe try this...

http://stackoverflow.com/questions/8667 … -4-upgrade

I was able to solve this issue by adding transformedBitIsBoolean=true to my MySQL connection string. See here: https://hibernate.atlassian.net/browse/HHH-6935

I think you can do this for Report Server by editing this file:
/reportserver/WEB-INF/classes/META-INF/persistence.xml

I found this:   <property name="hibernate.connection.transformedBitIsBoolean">true</property>
here: https://hibernate.atlassian.net/browse/HHH-468

Last edited by tomharney (2014-03-21 14:57:49)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Installation issue

Hi Scorpio,

which dialect did you configure in your persistence.xml? The issue should be solved by switching to

<property name="hibernate.dialect" value="net.datenwerke.rs.utils.hibernate.MySQL5Dialect"/>

Hope this helps,
Arno

scorpio001

Member

Registered: 2014-03-21

Re: Installation issue

Anro,

I changed the hibernate dialect and this time it seems to have read all the database table. But now its giving a different error. I will wait to hear from you or otherwise will try to install the older version

16:40:00,234  INFO TableMetadata:66 - HHH000037: Columns: [weekly_days, weekly_config_id]
16:40:00,921 ERROR MetadataContext:443 - HHH015011: Unable to locate static metamodel field : net.datenwerke.security.service.usermanager.entities.AbstractUserManagerNode_#origin
16:40:00,921 ERROR MetadataContext:443 - HHH015011: Unable to locate static metamodel field : net.datenwerke.security.service.usermanager.entities.AbstractUserManagerNode_#guid
21-Mar-2014 16:40:03.500 WARNING [localhost-startStop-1] com.google.inject.internal.ProxyFactory.<init> Method [public net.datenwerke.gxtdto.client.model.DwModel net.datenwerke.rs.core.server.reportexecutor.ReportExecutorRpcServiceImpl.storePNGInSession(net.datenwerke.rs.core.client.reportmanager.dto.reports.ReportDto) throws net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException] is synthetic and is being intercepted by [net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor@3c5dff]. This could indicate a bug.  The method may be intercepted twice, or may not be intercepted
21-Mar-2014 16:40:03.500 WARNING [localhost-startStop-1] com.google.inject.internal.ProxyFactory.<init> Method [public net.datenwerke.gxtdto.client.model.DwModel net.datenwerke.rs.core.server.reportexecutor.ReportExecutorRpcServiceImpl.storePNGInSession(net.datenwerke.rs.core.client.reportmanager.dto.reports.ReportDto) throws net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException] is synthetic and is being intercepted by [net.datenwerke.security.service.security.aop.SecurityCheckInterceptor@c26afe]. This could indicate a bug.  The method may be intercepted twice, or may not be intercep
16:40:03,531  WARN Ejb3Configuration:1141 - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
21-Mar-2014 16:40:05.484 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Error filterStart
21-Mar-2014 16:40:05.484 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/ReportServer] startup failed due to previous errors
21-Mar-2014 16:40:10.109 WARNING [localhost-startStop-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile datasources/internaldb.cf could not be loaded. Default values are in effect.
net.datenwerke.rs.utils.config.ConfigFileNotFoundException: Could not find config for datasources/internaldb.cf
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfig(ConfigServiceImpl.java:87)
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfig(ConfigServiceImpl.java:76)
        at net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe(ConfigServiceImpl.java:67)
        at net.datenwerke.rs.core.service.internaldb.InternalDbModule.provideDbLocation(InternalDbModule.java:37)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.google.inject.internal.ProviderMethod.get(ProviderMethod.java:104)
        at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
        at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
        at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
        at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
        at net.datenwerke.rs.core.service.internaldb.InternalDbServiceImpl.getLocation(InternalDbServiceImpl.java:81)
        at net.datenwerke.rs.core.service.internaldb.InternalDbServiceImpl.clearDatabase(InternalDbServiceImpl.java:114)
        at net.datenwerke.rs.core.service.internaldb.hookers.ClearInternalDbOnShutdown.contextDestroyed(ClearInternalDbOnShutdown.java:26)
        at net.datenwerke.gf.DwGwtFrameworkBase.contextDestroyed(DwGwtFrameworkBase.java:88)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4871)
        at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5499)
        at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:702)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:698)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1119)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1760)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)

21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesJdbc The web application [/ReportServer] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [com.google.inject.internal.util.$Finalizer] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [Thread-8] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901s3cils1mdpzu5|1ce9798]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901s3cils1mdpzu5|1ce9798]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.156 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901s3cils1mdpzu5|1ce9798]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.171 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge138901s3cils1mdpzu5|1ce9798]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.171 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [dwdaemon-JpaEventLoggerServiceImpl-1] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.171 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [dwdaemon-watchdog-JpaEventLoggerServiceImpl] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.171 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [scheduler-thread-1] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.171 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.clearReferencesThreads The web application [/ReportServer] appears to have started a thread named [scheduler-watchdog] but has failed to stop it. This is very likely to create a memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@10c9368]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@a19890]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1271749]) and a value of type [org.hibernate.ejb.EntityManagerImpl] (value [org.hibernate.ejb.EntityManagerImpl@169da03]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@10c9368]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@680b11]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1271749]) and a value of type [org.hibernate.ejb.EntityManagerImpl] (value [org.hibernate.ejb.EntityManagerImpl@aeb983]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1271749]) and a value of type [org.hibernate.ejb.EntityManagerImpl] (value [org.hibernate.ejb.EntityManagerImpl@1e849e6]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@10c9368]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@14bb6b0]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1271749]) and a value of type [org.hibernate.ejb.EntityManagerImpl] (value [org.hibernate.ejb.EntityManagerImpl@1c6eff1]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.281 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/ReportServer] created a ThreadLocal with key of type [com.google.inject.internal.InjectorImpl$1] (value [com.google.inject.internal.InjectorImpl$1@10c9368]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@1b2be47]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
21-Mar-2014 16:40:10.421 INFO [scheduler-thread-1] org.apache.catalina.loader.WebappClassLoader.loadClass Illegal access: this web application instance has been stopped already.  Could not load org.hibernate.param.AbstractExplicitParameterSpecification.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1461)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
        at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2774)
        at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1112)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1542)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        at org.hibernate.hql.internal.ast.HqlSqlWalker.generateNamedParameter(HqlSqlWalker.java:956)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.parameter(HqlSqlBaseWalker.java:4950)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1347)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4426)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3901)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2076)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2026)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
        at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
        at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
        at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
        at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
        at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221)
        at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199)
        at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1778)
        at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291)
        at net.datenwerke.scheduler.service.scheduler.stores.jpa.JpaJobStore.getExecutingJobs(JpaJobStore.java:80)
        at net.datenwerke.scheduler.service.scheduler.SchedulerDaemon.handleTerminatedJobs(SchedulerDaemon.java:145)
        at net.datenwerke.scheduler.service.scheduler.SchedulerDaemon.run(SchedulerDaemon.java:93)
        at java.lang.Thread.run(Thread.java:744)

21-Mar-2014 16:40:10.453 INFO [dwdaemon-JpaEventLoggerServiceImpl-1] org.apache.catalina.loader.WebappClassLoader.loadClass Illegal access: this web application instance has been stopped already.  Could not load org.hibernate.event.spi.FlushEntityEvent.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1461)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:226)
        at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:100)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1234)
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)
        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
        at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:75)
        at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:74)
        at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
        at java.lang.Thread.run(Thread.java:744)

21-Mar-2014 16:40:10.468 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\tomcat\apache-tomcat-8.0.0-RC5\webapps\ROOT
21-Mar-2014 16:40:10.468 INFO [Thread-8] org.apache.catalina.loader.WebappClassLoader.loadClass Illegal access: this web application instance has been stopped already.  Could not load org.hibernate.internal.CoreMessageLogger_$logger_en_US.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1461)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1420)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:270)
        at org.jboss.logging.Logger.getMessageLogger(Logger.java:2238)
        at org.jboss.logging.Logger.getMessageLogger(Logger.java:2214)
        at org.hibernate.jdbc.Expectations.<clinit>(Expectations.java:48)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3029)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3489)
        at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
        at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
        at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
        at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
        at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
        at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Installation issue

Hi scorpio,

my guess is that due to the wrong dialect ReportServer's installation partially completed before and that the database is now in an inconsistent state. Try to
clean the database (running the MYSQL_DROP.sql file and subsequently remaking the database using the MYSQL_CREATE.sql file) and try again.

Arno