This is the same error as this post from 6 years ago. We have a problem of SSO with the combination of the deeplink module for SOME users, it works perfectly for most but for a handful it just doesnt work and this error keeps popping up in logs. As far as I can tell everything is set up correctly, the users have access to the entity. The module is updated to the latest for Mx7. If anyone has any ideas please let me know. Thanks! Martin 2022-07-14T12:56:49.532270851Z INFO - SAML_SSO: Success: Successful sign on: userlogin 2022-07-14T12:56:59.412651344Z ERROR - DeepLink: Error while serving deeplink: 2022-07-14T12:56:59.413023246Z ERROR - DeepLink: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//DeepLink.PendingLink[DeepLink.PendingLink_DeepLink=$mxId and User=$username]","amount":-1,"variables":{"username":"169864","mxId":"[MendixIdentifier:: id=68116944363978953 objectType=DeepLink.DeepLink entityID=242]"},"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back 2022-07-14T12:56:59.413095747Z at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:159) 2022-07-14T12:56:59.413137747Z 2022-07-14T12:56:59.413638151Z Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//DeepLink.PendingLink[DeepLink.PendingLink_DeepLink=$mxId and User=$username]","amount":-1,"variables":{"username":"169864","mxId":"[MendixIdentifier:: id=68116944363978953 objectType=DeepLink.DeepLink entityID=242]"},"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back 2022-07-14T12:56:59.413688551Z at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) 2022-07-14T12:56:59.413712151Z 2022-07-14T12:56:59.414135454Z Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//DeepLink.PendingLink[DeepLink.PendingLink_DeepLink=$mxId and User=$username]","amount":-1,"variables":{"username":"169864","mxId":"[MendixIdentifier:: id=68116944363978953 objectType=DeepLink.DeepLink entityID=242]"},"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back 2022-07-14T12:56:59.414215355Z at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:160) 2022-07-14T12:56:59.414237955Z 2022-07-14T12:56:59.414324655Z Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 2022-07-14T12:56:59.414482457Z InternalXPathTextGetRequest (depth = 0): //DeepLink.PendingLink[DeepLink.PendingLink_DeepLink=$mxId and User=$username] 2022-07-14T12:56:59.414508157Z at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:64) 2022-07-14T12:56:59.414515757Z 2022-07-14T12:56:59.414857959Z Caused by: com.mendix.core.objectmanagement.SecurityRuntimeException: No access rights for subquery [SELECT x1DeepLink.PendingLink.ID FROM deeplink$pendinglink AS x1DeepLink.PendingLink WHERE (c1deeplink$pendinglink_deeplink.deeplink$deeplinkid = ? AND x1DeepLink.PendingLink.user = ?)] 2022-07-14T12:56:59.414929660Z at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleSubQuery(WhereClauseMapper.java:1192) 2022-07-14T12:56:59.415067061Z at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleSelectColumn(WhereClauseMapper.java:1054) 2022-07-14T12:56:59.415221362Z at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleWhereTermSide(WhereClauseMapper.java:566) 2022-07-14T12:56:59.415343163Z at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleWhereTerm(WhereClauseMapper.java:171) 2022-07-14T12:56:59.415430863Z at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.map(WhereClauseMapper.java:144) 2022-07-14T12:56:59.415569564Z at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.mapWhereClauseWhereTerms(QueryMapper.java:734) 2022-07-14T12:56:59.415680565Z at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:239) 2022-07-14T12:56:59.415795066Z at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:137) 2022-07-14T12:56:59.415897267Z at com.mendix.connectionbus.retrieve.OqlRequestHandler.doOldQueryHandling(OqlRequestHandler.scala:158) 2022-07-14T12:56:59.416023467Z at com.mendix.connectionbus.retrieve.OqlRequestHandler.handleRequest(OqlRequestHandler.scala:123) 2022-07-14T12:56:59.416130468Z at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:42) 2022-07-14T12:56:59.416275669Z at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:36) 2022-07-14T12:56:59.416301369Z at scala.collection.TraversableLike.$anonfun$flatMap$1(TraversableLike.scala:293) 2022-07-14T12:56:59.416439570Z at scala.collection.IndexedSeqOptimized.foreach(IndexedSeqOptimized.scala:36) 2022-07-14T12:56:59.416547171Z at scala.collection.IndexedSeqOptimized.foreach$(IndexedSeqOptimized.scala:33) 2022-07-14T12:56:59.416596672Z at scala.collection.mutable.WrappedArray.foreach(WrappedArray.scala:38) 2022-07-14T12:56:59.416713472Z at scala.collection.TraversableLike.flatMap(TraversableLike.scala:293) 2022-07-14T12:56:59.416786973Z at scala.collection.TraversableLike.flatMap$(TraversableLike.scala:290) 2022-07-14T12:56:59.416845773Z at scala.collection.AbstractTraversable.flatMap(Traversable.scala:108) 2022-07-14T12:56:59.416981874Z at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:36) 2022-07-14T12:56:59.417104375Z at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:34) 2022-07-14T12:56:59.417204876Z at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:75) 2022-07-14T12:56:59.417284076Z at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:50) 2022-07-14T12:56:59.417393677Z at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:481) 2022-07-14T12:56:59.417552178Z at com.mendix.basis.action.user.RetrieveXPathRawAction.retrieveXPathRaw(RetrieveXPathRawAction.java:132) 2022-07-14T12:56:59.417642479Z at com.mendix.basis.action.user.RetrieveXPathRawAction.executeAction(RetrieveXPathRawAction.java:72) 2022-07-14T12:56:59.417769580Z at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:58) 2022-07-14T12:56:59.417839880Z at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:16) 2022-07-14T12:56:59.417968881Z at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) 2022-07-14T12:56:59.418074582Z at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79) 2022-07-14T12:56:59.418221583Z at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57) 2022-07-14T12:56:59.418274083Z at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55) 2022-07-14T12:56:59.418397584Z at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18) 2022-07-14T12:56:59.418487285Z at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47) 2022-07-14T12:56:59.418604186Z at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 2022-07-14T12:56:59.418695686Z at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49) 2022-07-14T12:56:59.418819487Z at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25) 2022-07-14T12:56:59.418926188Z at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22) 2022-07-14T12:56:59.419049389Z at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18) 2022-07-14T12:56:59.419222790Z at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:68) 2022-07-14T12:56:59.419363091Z at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55) 2022-07-14T12:56:59.419440592Z at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55) 2022-07-14T12:56:59.419553892Z at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150) 2022-07-14T12:56:59.419662093Z at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 2022-07-14T12:56:59.419778394Z at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155) 2022-07-14T12:56:59.419894595Z at com.mendix.basis.action.InternalXPathQuery.execute(InternalXPathQuery.scala:52) 2022-07-14T12:56:59.419981096Z at deeplink.actions.StartDeeplinkJava$DeepLinkHandler.serveDeeplink(StartDeeplinkJava.java:225) 2022-07-14T12:56:59.420100796Z at deeplink.actions.StartDeeplinkJava$DeepLinkHandler.processRequest(StartDeeplinkJava.java:158) 2022-07-14T12:56:59.420230797Z at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40) 2022-07-14T12:56:59.420312898Z at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:72) 2022-07-14T12:56:59.420421899Z at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:69) 2022-07-14T12:56:59.420492599Z at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 2022-07-14T12:56:59.420645700Z at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:75) 2022-07-14T12:56:59.420696601Z at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:953) 2022-07-14T12:56:59.420954002Z at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.service(RuntimeHandler.java:42) 2022-07-14T12:56:59.421020703Z at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 2022-07-14T12:56:59.421108504Z at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) 2022-07-14T12:56:59.421176604Z at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) 2022-07-14T12:56:59.421295005Z at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) 2022-07-14T12:56:59.421409406Z at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) 2022-07-14T12:56:59.421528606Z at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) 2022-07-14T12:56:59.421644907Z at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) 2022-07-14T12:56:59.421716508Z at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) 2022-07-14T12:56:59.421825609Z at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) 2022-07-14T12:56:59.421913309Z at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) 2022-07-14T12:56:59.422013910Z at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) 2022-07-14T12:56:59.422128711Z at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) 2022-07-14T12:56:59.422210511Z at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) 2022-07-14T12:56:59.422307812Z at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 2022-07-14T12:56:59.422388913Z at org.eclipse.jetty.server.Server.handle(Server.java:516) 2022-07-14T12:56:59.422477613Z at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) 2022-07-14T12:56:59.422574614Z at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) 2022-07-14T12:56:59.422650414Z at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) 2022-07-14T12:56:59.422788915Z at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) 2022-07-14T12:56:59.422881916Z at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) 2022-07-14T12:56:59.422961717Z at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) 2022-07-14T12:56:59.423038017Z at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) 2022-07-14T12:56:59.423186418Z at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) 2022-07-14T12:56:59.423269319Z at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) 2022-07-14T12:56:59.423370020Z at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) 2022-07-14T12:56:59.423467920Z at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) 2022-07-14T12:56:59.423610221Z at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386) 2022-07-14T12:56:59.423683622Z at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) 2022-07-14T12:56:59.423792723Z at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) 2022-07-14T12:56:59.423836423Z at java.lang.Thread.run(Thread.java:750)