Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Failed to save the connection. Internal query error. - Issue with MYSQL database connection
Summary
Failed to save the connection. Internal query error. - Issue with MYSQL database connection
Content
Hi,
Could you please advise how to connect to mysql database in Oracle DV. I am able to connect on other tools with same credentials but not in DV.
Am I missing anything here ?
Answers
-
Hi,
What's the exact version of your MySQL ?
Did you check the log file for more info than just the few words you get on screen?
0 -
How to find Oracle DVD log files — Vlamis Software Solutions
PS: I could post the path directly but they deserves the clicks as they spent the time to publish it (first result on Google for "Oracle DVD log path")
0 -
Hi,
I have the same question. I have installed to 4 different computer but the result is still same. "Internal query error".
Every server connection attempt (Oracle-ExaDB-, MS SQL, MySQL etc) is returning with this error.
You mentioned about checking the log file but I couldn't that either. Could you please specify the exact path?
Thank you for your support.
0 -
Hi again,
Thanks for the reply. I did what you sad on previous post. But I couldn't find the reason in the log files. After doing that, I googled again with the other keywords. Long in short, I generated a log file including error statements. But in this log file the nothing is clear. There is no error reason, just the conclusions. (Internal Server Error etc.)You may check it by yourself.
Thank you again.
INFO: OutboundJaxrsResponse{status=500, reason=Internal Server Error, hasEntity=true, closed=false, buffered=false} {"code":500101,"message":"JDS - Internal Server error","subMessage":"<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8\"/>\n<title>Error 500 [JDSError : 76] An exception was occurred during request processing, please check logs for more deatils : [JDSError : 102] Cannot create a connection since there are some errors. Please fix them and try again. Failed creating a data source connection for jdbc:oraclebi://localhost:59327/\nCause: An error was thrown from datasource : java.io.IOException: [nQSError: 43113] Message returned from OBIS.[nQSError: 43126]
Mar 23, 2018 8:55:28 AM oracle.bi.tech.services.dataset.DatasetSvsImpl _logResponseError
SEVERE: Failed to create connection. : Internal Server Error - {"code":500101,"message":"JDS - Internal Server error","subMessage":"<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8\"/>\n<title>Error 500 [JDSError : 76]
An exception was occurred during request processing, please check logs for more deatils : [JDSError : 102] Cannot create a connection since there are some errors. Please fix them and try again.
Failed creating a data source connection for jdbc:oraclebi://localhost:59327/\nCause: An error was thrown from datasource : java.io.IOException: [nQSError: 43113] Message returned from OBIS.[nQSError: 43126]
0 -
Hi,
I have got support from Oracle Turkey (Thx to the Consultant) and my problem solved finally. The problem was an incompatible language problem. If you run the program with English language version, you probably solve your the source connection problem.
To do,
-Add this (-lang=en) to your shortcut properties area as shown on the picture below?
Please inform us.
Thank you.
0 -
I am also facing Same Error,Failed to save the connection.
Internal query error.
Here is error Log, Please suggest what do i understand and how i connect SQL Server and My SQL with Oracle Data Visualization?
[2018-03-29T12:33:06.301+05:30] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 3a64] [messageid: USER-0] [requestid: 36250002] [sessionid: 36250000] [username: BISystemUser] ############################################## [[
-------------------- SQL Request, logical request hash:
56a6c7db
{call NQSGetGroups('NAME=BIServiceAdministrator,BISystem,AuthenticatedUser')}
]]
[2018-03-29T12:33:16.871+05:30] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 3a64] [messageid: USER-0] [requestid: 36250003] [sessionid: 36250000] [username: BISystemUser] ############################################## [[
-------------------- SQL Request, logical request hash:
7b8708c6
{call NQSGetUsers('NAME=weblogic','DISPLAY_NAME','ssi')}
]]
0
