Failed to save the connection. Internal query error. - Issue with MYSQL database connection

Question

Summary

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 ?

Rsakman · Answer

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.

Dkumar346 · Answer

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')}

]]

Rsakman · Answer

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":" 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/ Cause: 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> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8"/> <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/ Cause: An error was thrown from datasource : java.io.IOException: [nQSError: 43113] Message returned from OBIS.[nQSError: 43126]