#1 2020-08-31 17:42:15

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 40

Unable to Add or import a dashboard !

Hi there,
I can't add or import a dashboard, I am getting an error message

Please help!


"Error

Error while committing the transaction"

"net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException: Error while committing the transaction
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.mapException(CatchStacktraceInterceptor.java:74)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:47)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.importReferencedDashboardForUser(&lt;generated&gt;)
<br>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br>    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
<br>    at java.lang.reflect.Method.invoke(Unknown Source)
<br>    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.CGLIB$processCall$30(&lt;generated&gt;)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e$$FastClassByGuice$$64dd9267.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.processCall(&lt;generated&gt;)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.CGLIB$processCall$31(&lt;generated&gt;)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e$$FastClassByGuice$$64dd9267.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.processCall(&lt;generated&gt;)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
<br>    at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.CGLIB$service$44(&lt;generated&gt;)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e$$FastClassByGuice$$64dd9267.invoke(&lt;generated&gt;)
<br>    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
<br>    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
<br>    at net.datenwerke.rs.dashboard.server.dashboard.DashboardRpcServiceImpl$$EnhancerByGuice$$e4bf150e.service(&lt;generated&gt;)
<br>    at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
<br>    at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
<br>    at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
<br>    at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
<br>    at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
<br>    at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
<br>    at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
<br>    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
<br>    at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
<br>    at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
<br>    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
<br>    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
<br>    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
<br>    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
<br>    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
<br>    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
<br>    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
<br>    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
<br>    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
<br>    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
<br>    at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
<br>    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
<br>    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
<br>    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
<br>    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
<br>    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
<br>    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
<br>    at java.lang.Thread.run(Unknown Source)
<br>Caused by: javax.persistence.RollbackException: Error while committing the transaction
<br>    at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:86)
<br>    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:87)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br>    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
<br>    at java.lang.reflect.Method.invoke(Unknown Source)
<br>    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
<br>    at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
<br>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
<br>    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
<br>    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
<br>    ... 31 more
<br>Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement
<br>    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
<br>    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
<br>    at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:67)
<br>    ... 51 more
<br>Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement
<br>    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
<br>    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
<br>    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
<br>    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
<br>    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
<br>    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2884)
<br>    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3384)
<br>    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
<br>    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:451)
<br>    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:336)
<br>    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335)
<br>    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
<br>    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)
<br>    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:464)
<br>    at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2905)
<br>    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2281)
<br>    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
<br>    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:146)
<br>    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
<br>    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:230)
<br>    at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
<br>    at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)
<br>    ... 51 more
<br>Caused by: java.sql.SQLException: Field &#39;reload_interval&#39; doesn&#39;t have a default value
<br>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
<br>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
<br>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
<br>    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
<br>    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
<br>    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
<br>    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
<br>    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
<br>    at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
<br>    at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
<br>    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
<br>    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
<br>    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
<br>    ... 69 more
<br>"

Last edited by Hamza_DBM (2020-08-31 17:45:33)

Offline

#2 2020-09-01 06:51:23

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Unable to Add or import a dashboard !

Hi Hamza_DBM,

the error is "Field &#39;reload_interval&#39; doesn&#39;t have a default value" , which may be caused by different versions of ReportServer (the version currently installed - trying the import, vs the version where the export happened). Are you sure you used the same version for exporting/importing ?

Regards,
Eduardo

Offline

#3 2020-09-01 11:08:19

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 40

Re: Unable to Add or import a dashboard !

Hi Eduardo,

What to do to fix this issue!?

Because I can't add new users they see the same error after login and when trying to import or add a dashboard for everyone!

Thank you

Offline

#4 2020-09-01 11:46:03

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Unable to Add or import a dashboard !

Hi Hamza_DBM,

did you export these users in a different ReportServer version than you are importing them?

Regards,
Eduardo

Offline

#5 2020-09-01 13:33:11

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 40

Re: Unable to Add or import a dashboard !

Recently we upgraded the virsion to 3.2.0 but still showing Version:
RS3.0.7-6008 (2019-05-06-13-37-55)

Is ther a good way to update the version correctly ?

Is it possible to backup this virsion and then reinstall RS with the new virsion directly ?

Is it possible to call me and connect with teamViewer  I am in Canada
+1 450-622-3100 ext: 362

Thank you

Offline

#6 2020-09-01 13:40:45

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,789
Website

Re: Unable to Add or import a dashboard !

Hi Hamza_DBM,

here you can find the upgrade guide: https://reportserver.net/en/tutorials/upgrade-30/

If it still shows 3.0.7, the upgrade to 3.2.0 did not work correctly.
If you made a backup of your metadata database, you can just revert to this backup, then copy the 3.0.7 binaries into the installation path, to have a "clean" 3.0.7 installation, and finally upgrade to 3.2.0 as described in the upgrade guide.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB