I am currently trying to establish a connection between two Mendix apps so that we can use the data base from another app. I have successfully accessed the data hub from the app I am trying to pull data from and have added the external entities in m ydomain model. However, when I try and use the external attribute as a data source within my app, I am still receiving errors (see below) and the external data does not display. Any ideas what I could be missing? Error log: An error has occurred while handling the request. [User 'MxAdmin' with session id '6d2842c9-XXXX-XXXX-XXXX-XXXXXXXX227a' and roles 'Administrator'] -------- com.mendix.webui.WebUIException: Exception while retrieving data for 'MyFirstModule.Trial_NewEdit.referenceSelector2' on document 'MyFirstModule.Trial_NewEdit' at com.mendix.webui.actions.client.RetrieveAction.$anonfun$apply$3(RetrieveAction.scala:94) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//MyFirstModule.SolutionDomains","amount":-1,"offset":-1,"returnsCount":false,"sort":[{"memberName":"SolutionDomainID","direction":{}}],"type":"RetrieveXPathSchemaRawAction"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): InternalLimitedXPathTextGetRequest (depth = -1): //MyFirstModule.SolutionDomains at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:35) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: The OData endpoint returned 401 Unauthorized. Set log level to Trace to see the corresponding URI. at com.mendix.integration.data.odata.CallWithRetry$.$anonfun$apply$2(CallWithRetry.scala:24) at scala.Option.getOrElse(Option.scala:201) at com.mendix.integration.data.odata.CallWithRetry$.giveUp$1(CallWithRetry.scala:22) at com.mendix.integration.data.odata.CallWithRetry$.$anonfun$apply$4(CallWithRetry.scala:35) at com.mendix.integration.data.odata.CallWithRetry$.apply(CallWithRetry.scala:43) at com.mendix.integration.data.odata.ODataServiceRepositoryImpl.retrieveFeed(ODataServiceRepository.scala:34) at com.mendix.integration.data.odata.ConsumedODataModule.$anonfun$handle$1(ConsumedODataModule.scala:23) at com.mendix.integration.data.odata.ConsumedODataModule.handle(ConsumedODataModule.scala:43) at com.mendix.integration.data.odata.ODataGetRequestHandler.handle(ODataGetRequestHandler.scala:21) at com.mendix.integration.data.odata.LimitedDataSourceQueryHandler.handle(LimitedDataSourceQueryHandler.scala:32) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeRemoteQuery(QueryRequestExecutor.scala:79) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForRemote(QueryRequestExecutor.scala:50) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:36) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:35) at scala.Option.map(Option.scala:242) at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:32) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:26) at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:118) at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:105) at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:26) at com.mendix.connectionbus.retrieve.GetRequestHandler.doOtherRequests(GetRequestHandler.scala:69) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.scala:29) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:30) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.scala:466) at com.mendix.basis.action.user.RetrieveXPathSchemaRawAction.executeAction(RetrieveXPathSchemaRawAction.scala:126) at com.mendix.basis.action.user.RetrieveXPathSchemaRawAction.executeAction(RetrieveXPathSchemaRawAction.scala:18) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56) at com.mendix.webui.RetrieveUtils.retrieveByXPathRaw(RetrieveUtils.scala:229) at com.mendix.webui.RetrieveUtils.retrieveWithHasMore(RetrieveUtils.scala:194) at com.mendix.webui.RetrieveUtils.retrieveByXPath(RetrieveUtils.scala:124) at com.mendix.webui.actions.client.RetrieveAction.$anonfun$apply$3(RetrieveAction.scala:67) at scala.util.Either.map(Either.scala:382) at com.mendix.webui.actions.client.RetrieveAction.apply(RetrieveAction.scala:43) at com.mendix.webui.actions.client.RetrieveAction.apply(RetrieveAction.scala:28) at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:30) at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.$anonfun$apply$4(RegularClientAction.scala:56) at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:45) at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:42) at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.withState(RegularClientAction.scala:46) at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:54) at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:46) at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$3(RegularClientAction.scala:120) at scala.util.Try$.apply(Try.scala:210) at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:120) at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:118) at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$5(ContextHandling.scala:57) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:49) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:49) at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:57) at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:31) at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94) at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:28) at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:20) at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94) at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:118) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18) at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest(ProfileHandling.scala:14) at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest$(ProfileHandling.scala:10) at com.mendix.webui.actions.client.RegularClientAction.profileRequest(RegularClientAction.scala:94) at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:115) at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:106) at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:79) at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:37) at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1(MxRuntimeConnector.scala:50) at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1$adapted(MxRuntimeConnector.scala:50) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.scala:50) at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.scala:232) at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:32) at javax.servlet.http.HttpServlet.service(HttpServlet.java:750) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764) at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1630) at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1600) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:506) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1571) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1378) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:463) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1544) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1300) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) at org.eclipse.jetty.server.Server.handle(Server.java:562) at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:319) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100) at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:412) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:381) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:268) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:138) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:407) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:894) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1038) at java.base/java.lang.Thread.run(Thread.java:829)
asked
Molly Campbell
2 answers
1
Adding a visual to my comment on Andrej's answer:
In your case, sounds like it's standard http auth – make sure to check the http authentication box so you can provide the credentials here
answered
Hardy Chen
1
Your log contains the following “The OData endpoint returned 401 Unauthorized. Set log level to Trace to see the corresponding URI.”
How did you configure authentication on the odata service and the consumed odata service?