You can translate the question and the replies:

Connect Denodo Express to Infor Compass data lake

Has anybody tried connecting Denodo Express to an Infor Compass Data Lake using an external jdbc driver? I have applied the directions on both Denodo and Infor side based on documentation available but still getting this error when doing a test connection: 80395682 [statement-runner-2] ERROR 2022-06-21T11:11:05.563 com.infor.dmp.common.query.client.Retry [] - Unable to successfully call acquire token in 10 attempts, giving up. com.infor.idl.shaded.javax.ws.rs.ProcessingException: Already connected at com.infor.idl.shaded.org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:254) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.JerseyInvocation$1.call(JerseyInvocation.java:671) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.JerseyInvocation$1.call(JerseyInvocation.java:668) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.internal.Errors.process(Errors.java:315) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.internal.Errors.process(Errors.java:297) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.internal.Errors.process(Errors.java:228) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:444) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:668) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:428) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:334) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth2.client.utils.OAuthAuthorization.callAuthorizationServer(OAuthAuthorization.java:58) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth2.client.utils.OAuthAuthorization.retrieveAccessData(OAuthAuthorization.java:41) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth2.client.utils.OAuthService.loadAccessData(OAuthService.java:26) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth2.client.utils.OAuthService.getAuthorizationHeaderValue(OAuthService.java:19) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth2.client.utils.OAuth2Client.makeRequestAndWaitForResponse(OAuth2Client.java:151) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.oauth.client.OAuthClient.makeRequestAndWaitForResponse(OAuthClient.java:111) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.IonApiAuthorizationTokenSupplier.get(IonApiAuthorizationTokenSupplier.java:78) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.TokenAuthenticatingClient.lambda$ensureToken$1(TokenAuthenticatingClient.java:160) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.Retry.lambda$retry$3(Retry.java:181) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.Retry.retry(Retry.java:202) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.Retry.retry(Retry.java:184) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.TokenAuthenticatingClient.ensureToken(TokenAuthenticatingClient.java:159) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.TokenAuthenticatingClient.makeRequestAndWaitForResponse(TokenAuthenticatingClient.java:111) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.TokenAuthenticationStatementClient.pingInternal(TokenAuthenticationStatementClient.java:137) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.dmp.common.query.client.TokenAuthenticationStatementClient.lambda$ping$1(TokenAuthenticationStatementClient.java:129) ~[infor-compass-jdbc-2020-09.jar:?] at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: java.lang.IllegalStateException: Already connected at sun.net.www.protocol.http.HttpURLConnection.setRequestProperty(HttpURLConnection.java:3170) ~[?:?] at sun.net.www.protocol.https.HttpsURLConnectionImpl.setRequestProperty(HttpsURLConnectionImpl.java:312) ~[?:?] at com.infor.idl.shaded.org.glassfish.jersey.client.HttpUrlConnector.setOutboundHeaders(HttpUrlConnector.java:362) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.HttpUrlConnector.access$100(HttpUrlConnector.java:91) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.HttpUrlConnector$4.getOutputStream(HttpUrlConnector.java:325) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.message.internal.CommittingOutputStream.commitStream(CommittingOutputStream.java:200) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.message.internal.CommittingOutputStream.commitStream(CommittingOutputStream.java:194) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.message.internal.CommittingOutputStream.commit(CommittingOutputStream.java:262) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.message.internal.OutboundMessageContext.commitStream(OutboundMessageContext.java:816) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.ClientRequest.writeEntity(ClientRequest.java:545) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.HttpUrlConnector._apply(HttpUrlConnector.java:329) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.HttpUrlConnector.apply(HttpUrlConnector.java:242) ~[infor-compass-jdbc-2020-09.jar:?] at com.infor.idl.shaded.org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:245) ~[infor-compass-jdbc-2020-09.jar:?] ... 28 more 80395694 [DNI(19782)-XXX.XXX.XX.XX-33] ERROR 2022-06-21T11:11:05.575 com.denodo.vdb.util.introspectionservice.actions.TestJDBCConnectionAction [] - Error testing connection com.denodo.util.exceptions.InternalErrorException: Data Lake is not available at com.denodo.vdb.util.introspectionservice.actions.JDBCActionUtil.getConnection(Unknown Source) ~[denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.util.introspectionservice.actions.JDBCActionUtil.getConnection(Unknown Source) ~[denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.util.introspectionservice.actions.TestJDBCConnectionAction.execute(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.TestJDBCConnectionAction.exec(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.Action.run(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.f3(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.a3(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.d3(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.a3(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.Action.start(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.ExecutionEngine.execute(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.interpreter.execution.ExecutionEngine.execute(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.vdbinterface.server.QueryExecutorImpl.executeStatement(Unknown Source) [denodo-vdp-server.jar:8.0.3] at com.denodo.vdb.vdbinterface.server.QueryExecutorImpl.executeStatement(Unknown Source) [denodo-vdp-server.jar:8.0.3] at jdk.internal.reflect.GeneratedMethodAccessor177.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at com.denodo.internal.o.a.r.server.ObjectRef.invoke(ObjectRef.java:110) [denodo-asyncrmi.jar:8.0.3] at com.denodo.internal.o.a.r.netty.RMIServerHandler.dispatch(RMIServerHandler.java:183) [denodo-asyncrmi.jar:8.0.3] at com.denodo.internal.o.a.r.netty.RMIServerHandler.channelRead(RMIServerHandler.java:81) [denodo-asyncrmi.jar:8.0.3] at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [denodo-asyncrmi.jar:8.0.3] at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.access$600(AbstractChannelHandlerContext.java:61) [denodo-asyncrmi.jar:8.0.3] at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext$7.run(AbstractChannelHandlerContext.java:370) [denodo-asyncrmi.jar:8.0.3] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at com.denodo.internal.i.n.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [denodo-asyncrmi.jar:8.0.3] at java.lang.Thread.run(Thread.java:834) [?:?] I have tried using another Db tool called DBeaver to connect to the Infor Compass data lake using infor documentation and it works without any issues. I can connect and run SQL to view table data from a JSON file. Pleas advise. Rafael
user
21-06-2022 16:58:57 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here