Hi , i am new to reportserver , I am intalling reportserver on tomcat with postgres DB.
While installing i am getting the following error.
Nov 09, 2016 11:57:48 AM net.datenwerke.rs.EnvironmentValidator startup
INFO:
| __ \ | | / |
| |) | _ __ ___ _ __| || (_ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ | '| |_ \ / _ \ '\ \ / / _ \ '|
| | \ \ / |) | () | | | | ___) | __/ | \ V / __/ |
|| __| ./ _/|| _|/ _|_| _/ _||
| |
||
Version: RS3.0.2-5855 2016-05-29-17-55-24
Code Version: 2016-05-29-17-55-24
Java Version: Oracle Corporation Java HotSpot™ 64-Bit Server VM 25.25-b02 (1.8)
VM Args: -Xmx512m -Djava.util.logging.config.file=D:\apache-tomcat-7.0.34\conf\logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=D:\apache-tomcat-7.0.34\endorsed -Dcatalina.base=D:\apache-tomcat-7.0.34 -Dcatalina.home=D:\apache-tomcat-7.0.34 -Djava.io.tmpdir=D:\apache-tomcat-7.0.34\temp
rs.configdir: Not Configured
DB Config
hibernate.dialect: org.hibernate.dialect.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://localhost/HariDB (OK)
hibernate.connection.username: postgres
hibernate.connection.password: **********
hibernate.default_schema:
Connection Test: OK
Schema Version: RS3.0-8
Nov 09, 2016 11:57:51 AM net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl getConfigFailsafe
WARNING: Configfile scheduler/scheduler.cf could not be loaded. Default values are in effect.
Nov 09, 2016 11:57:51 AM net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl getConfigFailsafe
WARNING: Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
Nov 09, 2016 11:57:51 AM net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl getConfigFailsafe
WARNING: Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
Nov 09, 2016 11:57:56 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
SEVERE: ERROR: relation “hibernate_sequence” does not exist
Position: 17
Nov 09, 2016 11:57:56 AM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1152)
at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:62)
at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
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:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:96)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:42)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:417)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67)
at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58)
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:774)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:747)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:752)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation “hibernate_sequence” does not exist
Position: 17
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
… 15 more
Nov 09, 2016 11:57:56 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:58)
at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:73)
at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
at java.lang.Thread.run(Unknown Source)
Nov 09, 2016 11:57:56 AM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl
INFO: Loading messages…
Nov 09, 2016 11:57:56 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
SEVERE: ERROR: relation “hibernate_sequence” does not exist
Position: 17
Nov 09, 2016 11:57:56 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.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1152)
at net.datenwerke.treedb.service.treedb.TreeDBServiceImpl.persist(TreeDBServiceImpl.java:90)
at net.datenwerke.treedb.service.treedb.TreeDBManagerImpl.persist(TreeDBManagerImpl.java:98)
at net.datenwerke.security.service.treedb.LoggedTreeDbManagerImpl.persist(LoggedTreeDbManagerImpl.java:31)
at net.datenwerke.security.service.treedb.SecuredTreeDBManagerImpl.persist(SecuredTreeDBManagerImpl.java:124)
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.security.service.usermanager.UserManagerServiceImpl.persist(UserManagerServiceImpl.java:1)
at net.datenwerke.rs.installation.PrepareDbForReportServer.createRootUser(PrepareDbForReportServer.java:274)
at net.datenwerke.rs.installation.PrepareDbForReportServer.executeOnFirstRun(PrepareDbForReportServer.java:85)
at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.prepareDatabase(ReportServerInstallationServiceImpl.java:54)
at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.install(ReportServerInstallationServiceImpl.java:28)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:58)
at net.datenwerke.rs.installation.RsInstallStartup$1.initialize(RsInstallStartup.java:25)
at net.datenwerke.gf.service.lateinit.LateInitStartup$1.run(LateInitStartup.java:62)
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:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:96)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:42)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:417)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67)
at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58)
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:774)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:747)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:752)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146)
… 15 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation “hibernate_sequence” does not exist
Position: 17
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
… 27 more
Nov 09, 2016 11:58:01 AM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl
INFO: Available locales: de, ru, fi, pt, bg, keys, lt, hr, lv, fr, hu, zh-CN, sk, sl, ga, sv, zh-TW, el, mt, en, it, es, et, cs, pl, da, ro, nl
Nov 09, 2016 11:58:01 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
SEVERE: ERROR: relation “hibernate_sequence” does not exist
Position: 17
Nov 09, 2016 11:58:01 AM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1152)
at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:62)
at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
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:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:96)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:42)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:417)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67)
at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58)
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:774)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:747)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:752)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146)
… 3 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation “hibernate_sequence” does not exist
Position: 17
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
… 15 more
Nov 09, 2016 11:58:01 AM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:58)
at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:73)
at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
at java.lang.Thread.run(Unknown Source)
please help me to rectify this problem