Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Failed to save the connection. Internal query error. Issue with DBaaS database connection to Oracle

Received Response
181
Views
3
Comments

Summary

Failed to save the connection. Internal query error. Issue with DBaaS database connection to Oracle Data Visualization.

Content

Hello,

 

Could somebody help me with connecting DBaaS Database Instances with Data Visualization? I've already managed to connect SQL developer to my DBaaS Database Instance, but I kept getting this error when trying to do the same with Data Visualization "Failed to save the connection. Internal query error". The fields shown here are almost identical to SQL Developer's input fields for setting up a database connection (which worked), however, they don't seem to be working in Data Viz. Thanks in advance!

 

I'm using Data Visualization Version 12.2.4.2.0-20180220134543.

 

Data Viz Error.PNG

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 2 - Community Beginner

    Yes, they are exactly the same. Do I need to have an SSH tunnel open on port 1521 perhaps? SQL developer has a built in SSH tunnel option that I used to get that running. I assumed that the tunnel that I opened opened there would transfer over to Data Viz, but that might not be the case (I had SQL Developer and Data Viz open at the same time).

  • Rank 6 - Analytics Lead

    I'm using 12.2.4.2.0-20180220134543 and am connected to my 12.1 cloud DB in the same format as you are doing there.  You're right that It is the same format as SQL Developer.  If it was able to connect and you'd got the un/pw wrong then you do get a message saying that, so it does look like it's not even connecting that far.  I can make mine get the same error if I deliberatly break it ( setting the port to the wrong number for example ).  Have you triple checked the bits you've scribbed out on the screenshot??

    Regards,

    Mark

  • Rank 2 - Community Beginner

    I believe I solved the problem. It turns out that there where network security settings within the cloud service itself that prevented me from linking Data Viz to my database. Once I made changes to the security rules I was able to connect. Good to know!

Welcome!

It looks like you're new here. Sign in or register to get started.