ReportServer Forum

mcavdar

Member

Registered: 2015-01-09

Reportserver cannot be loaded

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 <init>
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 <init>
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 <init>
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 <init>
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

Thorsten J. Krause

Guest

Re: Reportserver cannot be loaded

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

Member

Registered: 2015-01-09

Re: Reportserver cannot be loaded

Hi,
Thank you for your reply.

persistence.xml :

<?xml version="1.0" encoding="utf-8"?><persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
    <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>
</persistence>

Thorsten J. Krause

Guest

Re: Reportserver cannot be loaded

Hi,

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

-Thorsten