ReportServer Forum

sbmubasharsb

Member

Registered: 2015-04-13

ReportServer Local setup Issue

I have downloaded RS2.2.2-5639-reportserver-x64-bundle a dn trying to configure ReportServer with
DB2 database using apache-tomcat-7.0.34

I have Executed the the DB2 DDL

Updated the persistence.xml

<property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect"/>
<property name="hibernate.connection.driver_class" value="com.ibm.db2.jcc.DB2Driver"/>
<property name="hibernate.connection.url" value="jdbc:db2:ECRD"/>
<property name="hibernate.connection.username" value="rapiddb"/>
<property name="hibernate.connection.password" value="******"/>

placed DB2 libary in WEB\LIB folder

Please help me what i am missing

Here is the complete log

Apr 13, 2015 4:20:21 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files (x86)\Java\jdk1.7.0_45\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0\;c:\program files\lenovo\bluetooth software\;c:\program files\lenovo\bluetooth software\syswow64;c:\program files (x86)\ibm\gsk8\lib;C:\Program Files (x86)\Java\jdk1.6.0_32\bin;C:\Program Files (x86)\cvsnt;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\PROGRA~2\IBM\SQLLIB\BIN;C:\PROGRA~2\IBM\SQLLIB\FUNCTION;C:\PROGRA~2\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Skype\Phone\;;.
Apr 13, 2015 4:20:22 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8888"]
Apr 13, 2015 4:20:22 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8889"]
Apr 13, 2015 4:20:22 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 920 ms
Apr 13, 2015 4:20:22 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Apr 13, 2015 4:20:22 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.34
Apr 13, 2015 4:20:22 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\docs
Apr 13, 2015 4:20:22 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\examples
Apr 13, 2015 4:20:22 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\host-manager
Apr 13, 2015 4:20:23 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\manager
Apr 13, 2015 4:20:23 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\reportserver
Apr 13, 2015 4:21:08 PM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.HibernateException: The database returned no natively generated identity value
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:63)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:90)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2975)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3487)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
    ... 3 more

Apr 13, 2015 4:21:08 PM 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@1c70f4f]. This could indicate a bug.  The method may be intercepted twice, or may not be intercepted at all.
Apr 13, 2015 4:21:08 PM 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@1599bc3]. This could indicate a bug.  The method may be intercepted twice, or may not be intercepted at all.
Apr 13, 2015 4:21:08 PM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:74)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)

Apr 13, 2015 4:21:08 PM net.datenwerke.gf.service.lateinit.LateInitStartup$1 run
SEVERE: Error in LateInitHook
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
    at net.datenwerke.treedb.service.treedb.TreeDBServiceImpl.persist(TreeDBServiceImpl.java:91)
    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.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:258)
    at net.datenwerke.rs.installation.PrepareDbForReportServer.execute(PrepareDbForReportServer.java:85)
    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(Thread.java:744)
Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:90)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2975)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3487)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
    ... 15 more

Apr 13, 2015 4:21:09 PM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl <init>
INFO: Loading messages...
Apr 13, 2015 4:21:13 PM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.HibernateException: The database returned no natively generated identity value
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:63)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:90)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2975)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3487)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
    ... 3 more

Apr 13, 2015 4:21:13 PM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:74)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)

Apr 13, 2015 4:21:18 PM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.HibernateException: The database returned no natively generated identity value
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:63)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:90)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2975)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3487)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
    ... 3 more

Apr 13, 2015 4:21:18 PM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:74)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)

Apr 13, 2015 4:21:23 PM net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon doWork
WARNING: org.hibernate.HibernateException: The database returned no natively generated identity value
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:63)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
    at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:90)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2975)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3487)
    at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377)
    at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:214)
    at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:194)
    at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:178)
    at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
    at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)
    at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)
    ... 3 more

Apr 13, 2015 4:21:23 PM net.datenwerke.rs.utils.daemon.DwDaemonImpl run
WARNING: Transaction marked as rollbackOnly
javax.persistence.RollbackException: Transaction marked as rollbackOnly
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:72)
    at net.datenwerke.rs.utils.eventlogger.jpa.JpaEventLoggerDaemon.doWork(JpaEventLoggerDaemon.java:74)
    at net.datenwerke.rs.utils.daemon.DwDaemonImpl.run(DwDaemonImpl.java:39)
    at java.lang.Thread.run(Thread.java:744)

Apr 13, 2015 4:21:29 PM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl loadMessageFiles
INFO: remove locale stubs: , zh, ca, tr, no, pt_BR, el_GR, pt_PT, ko, cn, ua, ru, ja
Apr 13, 2015 4:21:29 PM net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl <init>
INFO: Available locales: hr, ro, hu, lv, lt, ga, de, fi, fr, bg, sv, zh-TW, sl, sk, da, it, keys, mt, zh-CN, cs, el, pl, pt, en, et, es, nl
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2 as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.BasicTagRepositoryResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.ExporterResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.QueryResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.SessionResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
INFO: Registering net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource as a root resource class
Apr 13, 2015 4:21:30 PM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate
INFO: Initiating Jersey application, version 'Jersey: 1.18.1 02/19/2014 03:28 AM'
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2 to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.BasicTagRepositoryResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.ExporterResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.QueryResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.SessionResource to GuiceManagedComponentProvider with the scope "Singleton"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
INFO: Binding net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource to GuiceManagedComponentProvider with the scope "PerRequest"
Apr 13, 2015 4:21:32 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\Tomcat\apache-tomcat-7.0.34\webapps\ROOT
Apr 13, 2015 4:21:32 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8888"]
Apr 13, 2015 4:21:33 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8889"]
Apr 13, 2015 4:21:33 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 70856 ms

Looking forward your response.

Regards,
SbMubasharSb

sbmubasharsb

Member

Registered: 2015-04-13

Re: ReportServer Local setup Issue

Can any body help on this issue, Will be highly thankful

sbmubasharsb

Member

Registered: 2015-04-13

Re: ReportServer Local setup Issue

Report Server stared started successfully with MYSQL but still not working with DB2.
Might be there is problem with DB2 ddl which are available added in release or i am missing something

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: ReportServer Local setup Issue

Hi,

sorry for the late response. I currently don't have a DB2 at hand, but this might be an incompatibility of an older DB2 version (or JDBC driver) with Hibernate (see for example http://stackoverflow.com/questions/8118 … tity-value). Which DB2 version are you using and which JDBC driver version?

Cheers
-Arno