Reportserver cannot be loaded

mcavdar · January 12, 2015, 8:40am

Hi,
I’ve recently installed Reportserver to evaluate but i have problems. I downloaded the file RS2.2.1-5602-reportserver-x64-bundle.exe from sourceforge.net, and installed with the options “install tomcat” and “install postgresql”. after installation I saw the page your installation is succesful but when I go to the page “http://localhost:8080/reportserver/ReportServer.html” i see that page cannot be loaded. there are these errors in catalina.log file. Can you help?

Thank you

Oca 12, 2015 10:24:00 AM com.google.inject.internal.ProxyFactory
WARNING: 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@548e8645]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Oca 12, 2015 10:24:00 AM com.google.inject.internal.ProxyFactory
WARNING: 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@5d7fb056]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Oca 12, 2015 10:24:01 AM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl
INFO: Loading messages…
Oca 12, 2015 10:24:01 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Error while committing the transaction
javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)
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(Unknown Source)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3067)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3509)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:286)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
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)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
… 17 more

Oca 12, 2015 10:24:01 AM net.datenwerke.scheduler.service.scheduler.SchedulerDaemon run
WARNING: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
at net.datenwerke.scheduler.service.scheduler.stores.jpa.JpaJobStore.getExecutingJobs(JpaJobStore.java:87)
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(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2036)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1815)
at org.hibernate.loader.Loader.doQuery(Loader.java:899)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
at org.hibernate.loader.Loader.doList(Loader.java:2522)
at org.hibernate.loader.Loader.doList(Loader.java:2508)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2338)
at org.hibernate.loader.Loader.list(Loader.java:2333)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
… 4 more
Caused by: org.postgresql.util.PSQLException: ERROR: column abstractjo0_1_.script_d does not exist
Position: 519
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
… 19 more

Oca 12, 2015 10:24:03 AM net.datenwerke.gf.service.lateinit.LateInitStartup$1 run
SEVERE: Error in LateInitHook
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
at net.datenwerke.treedb.service.treedb.TreeDBServiceImpl.persist(TreeDBServiceImpl.java:76)
at net.datenwerke.treedb.service.treedb.TreeDBManagerImpl.persist(TreeDBManagerImpl.java:96)
at net.datenwerke.security.service.treedb.LoggedTreeDbManagerImpl.persist(LoggedTreeDbManagerImpl.java:31)
at net.datenwerke.security.service.treedb.SecuredTreeDBManagerImpl.persist(SecuredTreeDBManagerImpl.java:123)
at net.datenwerke.rs.core.service.reportmanager.ReportServiceImpl.persist(ReportServiceImpl.java:148)
at net.datenwerke.security.service.eventlogger.aop.PersistEntityEventInterceptor.invoke(PersistEntityEventInterceptor.java:26)
at net.datenwerke.security.service.security.aop.UpdateOwnerInformationInterceptor.invoke(UpdateOwnerInformationInterceptor.java:48)
at net.datenwerke.rs.core.service.reportmanager.ReportServiceImpl.persist(ReportServiceImpl.java:1)
at net.datenwerke.security.service.treedb.SecuredTreeDBManagerImpl.persist(SecuredTreeDBManagerImpl.java:1)
at net.datenwerke.rs.installation.PrepareDbForReportServer.prepareReportTree(PrepareDbForReportServer.java:241)
at net.datenwerke.rs.installation.PrepareDbForReportServer.execute(PrepareDbForReportServer.java:86)
at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.prepareDatabase(ReportServerInstallationServiceImpl.java:54)
at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.install(ReportServerInstallationServiceImpl.java:30)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
at net.datenwerke.rs.installation.RsInstallStartup$1.initialize(RsInstallStartup.java:25)
at net.datenwerke.gf.service.lateinit.LateInitStartup$1.run(LateInitStartup.java:42)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2036)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1815)
at org.hibernate.loader.Loader.doQuery(Loader.java:899)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
at org.hibernate.loader.Loader.doList(Loader.java:2522)
at org.hibernate.loader.Loader.doList(Loader.java:2508)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2338)
at org.hibernate.loader.Loader.list(Loader.java:2333)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
… 17 more
Caused by: org.postgresql.util.PSQLException: ERROR: column abstractre0_1_.preview_mage_id does not exist
Position: 548
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
… 32 more

Oca 12, 2015 10:24:06 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Error while committing the transaction
javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)
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(Unknown Source)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3067)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3509)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:286)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
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)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
… 17 more

Oca 12, 2015 10:24:12 AM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl loadMessageFiles
INFO: remove locale stubs: , no, el_GR, ru, pt_BR, ua, ca, ko, cn, zh, ja, tr, pt_PT
Oca 12, 2015 10:24:12 AM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl
INFO: Available locales: de, fi, pt, bg, keys, lt, hr, lv, fr, hu, sk, sl, ga, sv, el, mt, en, it, es, et, cs, pl, da, ro, nl
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2 as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicTagRepositoryResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.ExporterResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.QueryResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.SessionResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource as a root resource class
Oca 12, 2015 10:24:12 AM com.sun.jersey.server.impl.application.WebApplicationImpl initiate
INFO: Initiating Jersey application, version ‘Jersey: 1.18.1 02/19/2014 03:28 AM’
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2 to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicTagRepositoryResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.ExporterResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.QueryResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.SessionResource to GuiceManagedComponentProvider with the scope “Singleton”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource to GuiceManagedComponentProvider with the scope “PerRequest”
Oca 12, 2015 10:24:13 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files\reportserver\tomcat\webapps\ROOT
Oca 12, 2015 10:24:14 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-apr-8080”]
Oca 12, 2015 10:24:14 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-apr-8009”]
Oca 12, 2015 10:24:14 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 90193 ms
Oca 12, 2015 10:25:01 AM net.datenwerke.scheduler.service.scheduler.SchedulerDaemon run
WARNING: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
at net.datenwerke.scheduler.service.scheduler.stores.jpa.JpaJobStore.getExecutingJobs(JpaJobStore.java:87)
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(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2036)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1815)
at org.hibernate.loader.Loader.doQuery(Loader.java:899)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
at org.hibernate.loader.Loader.doList(Loader.java:2522)
at org.hibernate.loader.Loader.doList(Loader.java:2508)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2338)
at org.hibernate.loader.Loader.list(Loader.java:2333)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
… 4 more
Caused by: org.postgresql.util.PSQLException: ERROR: column abstractjo0_1.script_d does not exist
Position: 519
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
… 19 more

Oca 12, 2015 10:25:06 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Error while committing the transaction
javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)
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(Unknown Source)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3067)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3509)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:286)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
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)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
… 17 more

Oca 12, 2015 10:26:01 AM net.datenwerke.scheduler.service.scheduler.SchedulerDaemon run
WARNING: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
at net.datenwerke.scheduler.service.scheduler.stores.jpa.JpaJobStore.getExecutingJobs(JpaJobStore.java:87)
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(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2036)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1815)
at org.hibernate.loader.Loader.doQuery(Loader.java:899)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
at org.hibernate.loader.Loader.doList(Loader.java:2522)
at org.hibernate.loader.Loader.doList(Loader.java:2508)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2338)
at org.hibernate.loader.Loader.list(Loader.java:2333)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
… 4 more
Caused by: org.postgresql.util.PSQLException: ERROR: column abstractjo0_1_.script_d does not exist
Position: 519
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
… 19 more

Oca 12, 2015 10:26:06 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Error while committing the transaction
javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)
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(Unknown Source)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3067)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3509)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:286)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
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)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
… 17 more

Oca 12, 2015 10:26:16 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Error while committing the transaction
javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:92)
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(Unknown Source)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:80)
… 3 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3067)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3509)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:286)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
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)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
Position: 53
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
… 17 more

Guest · January 12, 2015, 2:45pm

Hi,

can you find the file persistence.xml in you reportserver directory and post it here? There seems to be something wrong when reportserver tries to access the database:

ERROR: column “user_d” of relation “rs_audit_log_entry” does not exist
ERROR: column abstractre0_1_.preview_mage_id does not exist
ERROR: column abstractjo0_1_.script_d does not exist

All these column names are missing the letter “i” (user_id, preview_image_id, script_id). I’m really curious what might have caused that…

mcavdar · January 12, 2015, 3:05pm

Hi,
Thank you for your reply.

persistence.xml :

<?xml version="1.0" encoding="utf-8"?>[/url]

<persistence-unit name="reportServerPU" transaction-type="RESOURCE_LOCAL">
	<provider>org.hibernate.ejb.HibernatePersistence</provider>
	
    <class>net.datenwerke.scheduler.service.scheduler.entities.history.ExecutionLogEntry</class>
      <class>net.datenwerke.rs.dsbundle.service.dsbundle.entities.DatabaseBundleEntry</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.DailyNthdayTrigger</class>
      <class>net.datenwerke.rs.compiledreportstore.entities.PersistentCompiledReport</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.FilterBlock</class>
      <class>net.datenwerke.rs.tsreportarea.service.tsreportarea.entities.TsDiskRoot</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.StaticHtmlDadget</class>
      <class>net.datenwerke.rs.base.service.datasources.connectors.ArgumentDatasourceConnector</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.Filter</class>
      <class>net.datenwerke.rs.tsreportarea.service.tsreportarea.entities.TsDiskReportReference</class>
      <class>net.datenwerke.rs.base.service.parameters.headline.HeadlineParameterDefinition</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.FilterSpec</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.Dadget</class>
      <class>net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource</class>
      <class>net.datenwerke.rs.birt.service.reportengine.entities.BirtReportVariant</class>
      <class>net.datenwerke.rs.fileserver.service.fileserver.entities.FileServerFolder</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.ReportByteProperty</class>
      <class>net.datenwerke.rs.tabletemplate.service.tabletemplate.entities.TableReportStringTemplate</class>
      <class>net.datenwerke.rs.base.service.parameters.blatext.BlatextParameterDefinition</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.history.ActionEntry</class>
      <class>net.datenwerke.rs.birt.service.reportengine.entities.BirtReport</class>
      <class>net.datenwerke.security.service.usermanager.entities.User</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.MonthlyNthDayConfig</class>
      <class>net.datenwerke.rs.uservariables.service.variabletypes.string.StringUserVariableDefinition</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.DadgetNode</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.AbstractAction</class>
      <class>net.datenwerke.rs.fileserver.service.fileserver.entities.FileServerFile</class>
      <class>net.datenwerke.rs.base.service.datasources.definitions.CsvDatasourceConfig</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.Report</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.AbstractJob</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.DateTrigger</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.AbstractReportManagerNode</class>
      <class>net.datenwerke.rs.birt.service.datasources.birtreport.entities.BirtReportDatasourceDefinition</class>
      <class>net.datenwerke.rs.jxlsreport.service.jxlsreport.entities.JxlsReport</class>
      <class>net.datenwerke.rs.tabletemplate.service.tabletemplate.entities.TableReportByteTemplate</class>
      <class>net.datenwerke.rs.tabletemplate.service.tabletemplate.entities.TableReportTemplate</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.DailyWorkdayTrigger</class>
      <class>net.datenwerke.rs.base.service.parameters.blatext.BlatextParameterInstance</class>
      <class>net.datenwerke.rs.uservariables.service.variabletypes.list.ListUserVariableDefinition</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.history.HistoryEntryProperty</class>
      <class>net.datenwerke.rs.fileserver.service.fileserver.entities.FileServerFileData</class>
      <class>net.datenwerke.security.service.usermanager.entities.UserProperty</class>
      <class>net.datenwerke.rs.scheduleasfile.service.scheduleasfile.entities.ExecutedReportFileReference</class>
      <class>net.datenwerke.security.service.security.entities.GenericSecurityTargetEntity</class>
      <class>net.datenwerke.rs.core.service.datasourcemanager.entities.DatasourceFolder</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormatNumber</class>
      <class>net.datenwerke.rs.base.service.parameters.datetime.DateTimeParameterDefinition</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.UserDashboard</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.WeeklyTrigger</class>
      <class>net.datenwerke.rs.tsreportarea.service.tsreportarea.entities.TsDiskFolder</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.FavoriteList</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.TableReportVariant</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.BaseProperty</class>
      <class>net.datenwerke.rs.base.service.parameters.string.TextParameterInstance</class>
      <class>net.datenwerke.rs.base.service.reportengines.jasper.entities.JasperReportVariant</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormatTemplate</class>
      <class>net.datenwerke.rs.base.service.datasources.connectors.DatasourceConnectorConfig</class>
      <class>net.datenwerke.security.service.usermanager.entities.AbstractUserManagerNode</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.YearlyAtDateTrigger</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.ReportServerSideStringProperty</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.Column</class>
      <class>net.datenwerke.rs.birt.service.reportengine.entities.BirtReportFile</class>
      <class>net.datenwerke.rs.utils.eventlogger.entities.LogProperty</class>
      <class>net.datenwerke.rs.globalconstants.service.globalconstants.entities.GlobalConstant</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.YearlyNamedDayTrigger</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.MonthlyNthDayOfWeekConfig</class>
      <class>net.datenwerke.rs.core.service.datasourcemanager.entities.AbstractDatasourceManagerNode</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.ReportFolder</class>
      <class>net.datenwerke.rs.scheduleasfile.service.scheduleasfile.action.ScheduleAsFileAction</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.YearlyNthDayOfWeekConfig</class>
      <class>net.datenwerke.rs.crystal.service.crystal.entities.CrystalReportFile</class>
      <class>net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasourceConfig</class>
      <class>net.datenwerke.rs.incubator.service.versioning.entities.Revision</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormatDate</class>
      <class>net.datenwerke.rs.core.service.datasourcemanager.entities.DatasourceDefinition</class>
      <class>net.datenwerke.rs.tsreportarea.service.tsreportarea.entities.AbstractTsDiskNode</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.DailyConfig</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.MonthlyNthDayMthMonthTrigger</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.YearlyAtDateConfig</class>
      <class>net.datenwerke.rs.scripting.service.jobs.ScriptExecuteJob</class>
      <class>net.datenwerke.rs.uservariables.service.uservariables.entities.UserVariableDefinition</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.FilterRange</class>
      <class>net.datenwerke.rs.jxlsreport.service.jxlsreport.entities.JxlsReportFile</class>
      <class>net.datenwerke.rs.teamspace.service.teamspace.entities.TeamSpace</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.ReportProperty</class>
      <class>net.datenwerke.rs.utils.eventlogger.entities.AuditLogEntry</class>
      <class>net.datenwerke.rs.condition.service.condition.entity.Condition</class>
      <class>net.datenwerke.rs.dsbundle.service.dsbundle.entities.DatabaseBundle</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.ColumnFilter</class>
      <class>net.datenwerke.rs.base.service.parameters.separator.SeparatorParameterDefinition</class>
      <class>net.datenwerke.rs.core.service.parameters.entities.ParameterDefinition</class>
      <class>net.datenwerke.rs.scriptreport.service.scriptreport.parameter.ScriptParameterInstance</class>
      <class>net.datenwerke.rs.scriptreport.service.scriptreport.entities.ScriptReportVariant</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.AdditionalColumnSpec</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.UrlDadget</class>
      <class>net.datenwerke.rs.base.service.parameters.datasource.DatasourceParameterInstance</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.FavoriteListDadget</class>
      <class>net.datenwerke.rs.base.service.parameters.separator.SeparatorParameterInstance</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.ColumnReference</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.ReportDadget</class>
      <class>net.datenwerke.rs.teamspace.service.teamspace.entities.TeamSpaceMember</class>
      <class>net.datenwerke.rs.incubator.service.jaspertotable.entities.JasperToTableConfig</class>
      <class>net.datenwerke.security.service.security.entities.Ace</class>
      <class>net.datenwerke.rs.base.service.parameters.datetime.DateTimeParameterInstance</class>
      <class>net.datenwerke.rs.incubator.service.scriptdatasource.entities.ScriptDatasourceConfig</class>
      <class>net.datenwerke.rs.uservariables.service.variabletypes.string.StringUserVariableInstance</class>
      <class>net.datenwerke.rs.uservariables.service.variabletypes.list.ListUserVariableInstance</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.ReportMetadata</class>
      <class>net.datenwerke.rs.base.service.datasources.connectors.TextDatasourceConnector</class>
      <class>net.datenwerke.rs.tabletemplate.service.tabletemplate.entities.TableReportTemplateList</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.PreviewImage</class>
      <class>net.datenwerke.security.service.security.entities.Acl</class>
      <class>net.datenwerke.gf.service.properties.entities.Property</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.DateTriggerConfig</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.Dashboard</class>
      <class>net.datenwerke.rs.saiku.service.datasource.MondrianDatasource</class>
      <class>net.datenwerke.rs.grideditor.service.grideditor.entities.GridEditorReport</class>
      <class>net.datenwerke.rs.uservariables.service.parameters.UserVariableParameterDefinition</class>
      <class>net.datenwerke.rs.base.service.datasources.connectors.UrlDatasourceConnector</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormatText</class>
      <class>net.datenwerke.rs.core.service.datasourcemanager.entities.DatasourceContainer</class>
      <class>net.datenwerke.rs.uservariables.service.parameters.UserVariableParameterInstance</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.DashboardFolder</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.LibraryDadget</class>
      <class>net.datenwerke.security.service.usermanager.entities.OrganisationalUnit</class>
      <class>net.datenwerke.rs.core.service.datasourcemanager.entities.DatasourceDefinitionConfig</class>
      <class>net.datenwerke.rs.teamspace.service.teamspace.entities.AppProperty</class>
      <class>net.datenwerke.rs.scriptreport.service.scriptreport.entities.ScriptReport</class>
      <class>net.datenwerke.rs.incubator.service.scriptdatasource.entities.ScriptDatasource</class>
      <class>net.datenwerke.rs.crystal.service.crystal.entities.CrystalReport</class>
      <class>net.datenwerke.rs.base.service.datasources.definitions.CsvDatasource</class>
      <class>net.datenwerke.rs.base.service.reportengines.jasper.entities.JasperReport</class>
      <class>net.datenwerke.rs.crystal.service.crystal.entities.CrystalReportVariant</class>
      <class>net.datenwerke.rs.core.service.reportmanager.entities.reports.ReportStringProperty</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.config.WeeklyConfig</class>
      <class>net.datenwerke.security.service.security.entities.HierarchicalAcl</class>
      <class>net.datenwerke.security.service.security.entities.AceAccessMap</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.AbstractTrigger</class>
      <class>net.datenwerke.scheduler.service.scheduler.triggers.complex.MonthlyNamedDayTrigger</class>
      <class>net.datenwerke.rs.base.service.parameters.datasource.DatasourceParameterData</class>
      <class>net.datenwerke.rs.base.service.parameters.string.TextParameterDefinition</class>
      <class>net.datenwerke.rs.base.service.datasources.connectors.DatasourceConnector</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.TableReport</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormat</class>
      <class>net.datenwerke.rs.jxlsreport.service.jxlsreport.entities.JxlsReportVariant</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.format.ColumnFormatCurrency</class>
      <class>net.datenwerke.security.service.security.entities.HierarchicalAce</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.history.JobEntry</class>
      <class>net.datenwerke.rs.computedcolumns.service.computedcolumns.entities.ComputedColumn</class>
      <class>net.datenwerke.rs.base.service.parameters.headline.HeadlineParameterInstance</class>
      <class>net.datenwerke.rs.core.service.parameters.entities.ParameterInstance</class>
      <class>net.datenwerke.rs.grideditor.service.grideditor.entities.GridEditorReportVariant</class>
      <class>net.datenwerke.rs.uservariables.service.uservariables.entities.UserVariableInstance</class>
      <class>net.datenwerke.rs.saiku.service.saiku.entities.SaikuReportVariant</class>
      <class>net.datenwerke.rs.scheduler.service.scheduler.jobs.report.ReportExecuteJob</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.PreFilter</class>
      <class>net.datenwerke.rs.base.service.reportengines.table.entities.filters.BinaryColumnFilter</class>
      <class>net.datenwerke.rs.saiku.service.saiku.entities.SaikuReport</class>
      <class>net.datenwerke.security.service.usermanager.entities.Group</class>
      <class>net.datenwerke.scheduler.service.scheduler.entities.history.JobHistory</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.AbstractDashboardManagerNode</class>
      <class>net.datenwerke.rs.base.service.reportengines.jasper.entities.JasperReportJRXMLFile</class>
      <class>net.datenwerke.rs.teamspace.service.teamspace.entities.TeamSpaceApp</class>
      <class>net.datenwerke.rs.saiku.service.datasource.MondrianDatasourceConfig</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.DashboardNode</class>
      <class>net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction</class>
      <class>net.datenwerke.rs.fileserver.service.fileserver.entities.AbstractFileServerNode</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.DashboardReference</class>
      <class>net.datenwerke.rs.tsreportarea.service.tsreportarea.entities.TsDiskGeneralReference</class>
      <class>net.datenwerke.rs.scriptreport.service.scriptreport.parameter.ScriptParameterDefinition</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.entities.DashboardContainer</class>
      <class>net.datenwerke.rs.birt.service.datasources.birtreport.entities.BirtReportDatasourceConfig</class>
      <class>net.datenwerke.rs.base.service.parameters.datasource.DatasourceParameterDefinition</class>
      <class>net.datenwerke.rs.dashboard.service.dashboard.dagets.FavoriteListEntry</class>
      <properties>
    
		<!-- Connection properties -->        
		<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
        <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>
        <property name="hibernate.connection.url" value="jdbc:postgresql://localhost/rs"/>
        <property name="hibernate.connection.username" value="rs"/>
        <property name="hibernate.connection.password" value="rs"/>


		<!--<property name="hibernate.default_schema" value=""/>-->
		<property name="hibernate.connection.autocommit" value="false"/>

		<!-- Recreate table on server restart -->
		<!--  DISABLE FOR PRODUCTION -->
        <property name="hibernate.hbm2ddl.auto" value=""/>
    
    	<!-- Cache/Naming -->
        <property name="hibernate.ejb.naming_strategy" value="net.datenwerke.rs.utils.hibernate.ReportServerNamingStrategy"/>
        <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>

		<!-- Debug -->
        <property name="hibernate.show_sql" value="false"/>
        <property name="hibernate.format_sql" value="true"/>

        <!-- C3P0 -->		
		<property name="hibernate.c3p0.acquire_increment" value="5"/>
		<property name="hibernate.c3p0.idle_test_period" value="60"/>
		<property name="hibernate.c3p0.timeout" value="3600"/>
		<property name="hibernate.c3p0.max_size" value="30"/>
		<property name="hibernate.c3p0.max_statements" value="0"/>
		<property name="hibernate.c3p0.min_size" value="5"/>

        <!-- Envers -->
        <property name="org.hibernate.envers.audit_table_suffix" value="_A"/>
        <property name="org.hibernate.envers.audit_table_prefix" value=""/>

        <!-- hibernate search -->
        <property name="hibernate.search.default.directory_provider" value="ram"/>
        
        <!-- <property name="hibernate.search.analyzer" value="org.apache.lucene.analysis.de.GermanAnalyzer"/> -->
        <!-- <property name="hibernate.search.analyzer" value="org.apache.lucene.analysis.WhitespaceAnalyzer"/> --> 
    </properties>
</persistence-unit>

Guest · January 13, 2015, 11:03am

Hi,

well, the config looks fine. Can you zip the logs-folder and send it to me via email?

-Thorsten