Failure when using Denodo Testing Tool

I am trying to test denodo testing tool on one of the base views I have created on a local orable db installed on my pc. Everytime I try to run it, I am getting below error Test FAILED. Test raised an unexpected com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: sun/rmi/transport/proxy/RMISocketInfo Could someone pls help
user
13-06-2019 18:41:48 -0400

1 Answer

Hello, The error you are experiencing is something you might see if you cannot connect to the Oracle database from the testing tool. It's possible that you are referencing the Oracle server in a way that does not match up with an active listener, or that there is some other network issue. We recommend you test this network path by using the telnet command to connect to the same servername or IP address you have used in the jdbcUrl, over port 1521, assuming that is the port you are using. Also, test connecting to the VDP server without actually querying a view by running a test like this (replace vdp with your datasource name from the configuration.properties file that you set up): ``` # ========================================== %EXECUTION[query] { ds:vdp } select 1 from sys.Dual # --------------------------------------------------------------------------- %RESULTS[data] field1 1 # --------------------------------------------------------------------------- ``` If none of this helps troubleshoot the issue, since you are a customer, we recommend you submit a support ticket. Hope this helps
Denodo Team
25-06-2019 12:41:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here