ReportServer Forum

zuera

Member

Registered: 2020-06-16

Issue deleting users

Hi,

I have encountered the following error while trying to delete some users from ReportServer. The issue doesn't happen with most users, just with a couple of them, but apparently there's no way to delete them safely. I have tried removing these users from any Scheduled report, workspace... that they belonged, but the error keeps the same:

va: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.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$65321ee5.deleteNode(&lt;generated&gt;)<br>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>    at java.lang.reflect.Method.invoke(Method.java:498)<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.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$65321ee5.CGLIB$processCall$29(&lt;generated&gt;)<br>    at .........
.........
"REMOVED BY ME, BECAUSE MESSAGE TOO LONG POST"
........
........
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: org.postgresql.util.PSQLException: ERROR: update or delete on table &quot;rs_user&quot; violates foreign key constraint &quot;fk_1be2jre7ckkkf12dokmbj080v&quot; on table &quot;rs_favorite_list&quot;<br>  Detail: Key (id)=(1584070) is still referenced from table &quot;rs_favorite_list&quot;.<br>    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)<br>    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)<br>    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)<br>    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)<br>    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)<br>    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:133)<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>    ... 68 more<br>

Apparently the key of the error is this:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table &quot;rs_user&quot; violates foreign key constraint &quot;fk_1be2jre7ckkkf12dokmbj080v&quot; on table &quot;rs_favorite_list&quot;<br>  Detail: Key (id)=(1584070) is still referenced from table &quot;rs_favorite_list&quot;.

But I haven't found any feature related to "favorite_list" that may be assigned to those specific users. Am I doing something wrong, or is this a bug?

Best regards

Last edited by zuera (2020-07-03 08:26:17)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Issue deleting users

Hi zuera,

this sounds like a bug. I raised RS-4279 for this. Can you please check if the user you cannot remove has any entries in the bookmark dadget ? https://reportserver.net/en/guides/user … Dashboard/ Bookmark Dadget    Allows to quickly jumpt to important report objects.

which version exactly are you using ? (rsversion.properties)

Regards,
Eduardo