6 Replies Latest reply on Mar 29, 2018 12:36 PM by user10566869

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

    2832094

      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 ?

       

      MysqlError.JPG

        • 1. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
          Gianni Ceresa

          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?

          • 2. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
            user10566869

            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.

            • 3. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
              Gianni Ceresa

              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")

              • 4. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
                user10566869

                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.\r\n[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.\r\n[nQSError: 43126]

                • 5. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
                  user10665355


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

                   

                   

                  ]]

                  • 6. Re: Failed to save the connection. Internal query error. - Issue with MYSQL database connection
                    user10566869

                    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.

                     

                    shortcut.jpg