Heterogeneous Query Editor Won't Open

Toad Data Point & Toad Intelligence Central
1

Is there a bug in 5.1 with the cross-connection editor because 5.0 never had this problem before we upgraded. Tried rebooting and restarting TDP and the cross connection editor will not open for reasons unknown. Tried opening it using both the build and edit options and neither work.

Regular queries run under the connections that TDP is saying has a connect error. This is only happening with the cross-connection editor.

It returns the following error in the Output view even though the data sources are connecting fine on their own.

There was a connect error. Check that the server, username, password and port are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled: Unable to connect to any of the specified Cross Query hosts. (Remembered answer: "Cancel". Enable)

Also tried open an existing ccq and while it opened it the query would not execute. Further it grays out the run sql and run script buttons as well.

Path is set for Local Storage, but the Local Storage Connection will not connect.

Opened up TDP 5.0 and local storage connection worked fine. Checked the properties and it's pointing to the same folder using the builtin hub connection. No idea what's happening.

2

Hi toad.user - are you able to connect to Local Storage?

3

If I open v5.0 local storage connection works. If I try it in v5.1 it doesn't, but both are configured the same way. I tried changing the folder for v5.1 in case in needed to reset something, but it doesn't connect. Is there a way to troubleshoot this?

4

I would guess it is a license key problem. Pro with local storage and heterogeneous queries uses a different key (software is the same but features get disabled). You may need a new key, contact support.

5

We have a pro license and have used cross-connection queries for some time. This only happened recently after we upgraded the license.

6

I would suggest contacting support at https://support.quest.com/contact-support they should be able to help you past this. reach out to me directly if you have any issues getting into the support portal. julie.hyman@quest.com

7

I think our support expired so that is why I'm sending requests through this forum.

8

Toad World is actually made for helping Toad community to share knowledge and allowing us to gather some feedback and ideas for enhancements. It's not the same as contacting our Quest Support.

9

We have a professional license and upgraded to 5.1 and cross-connection queries will not open. Is there anything we can do to troubleshoot this? 5.0 worked fine.

image

The issue is local storage won't connect and we're trying to figure out why. It worked in v5.

This old post suggests there's no need to change the username and password for local storage, but TDP continues to return the following error which it never did with v5. There's very limited information under options for local storage and it has all the config files in the designated local storage folder.

> There was a connect error. Check that the server, username, password and port are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled: The requested address is not valid in its context (Remembered answer: "Cancel". Enable)

This post seems to suggest something needs to be done on a command line.

Here is the guardian.log error:

Unable to connect to any of the specified MySQL hosts.
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at HubGuardian.Model.Processes.HubConf.ExecScript(MySqlConnection conn, String script_name)
at HubGuardian.Model.Processes.HubConf.DoCreateConf(Boolean updateSchema)
at HubGuardian.Model.Processes.Hub.ConfigureHub()
2020-04-21 18:23:27.819 [ERROR] fail to run guardian
hub config error
at HubGuardian.Model.Processes.Hub.ConfigureHub()
at HubGuardian.Model.Processes.Hub.Run()
at HubGuardian.Model.Guardian.Start()
at HubGuardian.Model.Guardian.Run()

This was an attempt at a secondary local storage connection:

2020-04-14 15:01:27.700 ping mysqld result: False
2020-04-14 15:01:27.700 Execute mysqlupgrade C:\Program Files\Quest Software\Toad Data Point 5.1\datahub\bin\mysql_upgrade.exe
2020-04-14 15:01:27.747 configure hub from source conf dir C:\Program Files\Quest Software\Toad Data Point 5.1\datahub\conf\hub_information_schema
2020-04-14 15:01:28.841 [ERROR] fail to configure hub
Unable to connect to any of the specified MySQL hosts.
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at HubGuardian.Model.Processes.HubConf.ExecScript(MySqlConnection conn, String script_name)
at HubGuardian.Model.Processes.HubConf.DoCreateConf(Boolean updateSchema)
at HubGuardian.Model.Processes.Hub.ConfigureHub()
2020-04-14 15:01:28.841 [ERROR] fail to run guardian
hub config error
at HubGuardian.Model.Processes.Hub.ConfigureHub()
at HubGuardian.Model.Processes.Hub.Run()
at HubGuardian.Model.Guardian.Start()
at HubGuardian.Model.Guardian.Run()

Attempted a MySQL driver upgrade.

(1) root@localhost (toad_local_db) : There was a connect error. Check that the server, username, password and port are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled

The driver setting is set to default, but it indicates that the driver should match what is being used for cross-connection queries so I presume it should be set to default since we generally need Oracle for cross-connections, but for local storage it would be MySQL.

10

Is TDP using an integrated version of MySQL? It can't be run from the command line and I'm trying to figure out if we need to install it because it's not in the system path and is not a recognized application at the moment.

11

Yes. Toad Data Point uses an integrated version of MySQL. The error is misleading. Toad Data Point handles all of the userid and password info on the integrated version of MySQL.

12

Is this using the wrong login? That is not in any of the connection properties.

image

13

But it doesn't work for reasons unknown. v5.1 is a fresh install and not starting mysqld. This doesn't appear to be an isolated problem and there are forum discussions going back several years. How has this been resolved in the past?

14

We have a process that is extracting report data which is going out a nationwide sales force and because of the way TDP handles loops there is a high volume of queries executing. We need to take the report processing offline, but until we can get this local storage working we have no way to reduce the query overhead so it's maxing out the capacity on the ID it's running under. This is a bug with TDP and we need to fix it because we can't improve the automation until TDP works correctly.

We had support, but every time we tried to use it we got stuck in on-going email threads that never resulted in solutions. When we did schedule time there were no-shows. So investing in support when we're working around bugs doesn't seem like the best solution. However I welcome any support Quest can provide because you were on the company's list of approved vendors, but we seem to be testing the limits of TDP.

15

In between these two versions we upgraded the internal MySQL version and sometimes it's not tolerated well. The first thing we always try is adding the TDP/TIC folders to antivirus exclusions. Are you using McAffee or something else?

16

Hi toad.user
I am developer of local storage, the guardian log shows mysqld didn't start normally, and I think MySQL's own err file can tell us why. please send me two files:
1)C:\Users<username>\AppData\Local\Quest Software\Toad Data Point Hub Data\data\xxx.err
2)C:\Users<username>\AppData\Local\Quest Software\Toad Data Point Hub Data\logs\guardian.log (with the error messages you show us).

you can send those files directly to my e-mail : Winnie.wu@quest.com, I'll go back to you once I
have found something.

after you have sent the log files, I think you may have a try:
step 1: make sure the folder "C:\Users<username>\AppData\Local\Quest Software\Toad Data Point Hub" is excluded in your anti-virus scan. you can add this folder to your anti-virus NOT-scan list.
step 2: rename the folder: C:\Users<username>\AppData\Local\Quest Software\Toad Data Point Hub to a different name
step 3: open tdp, try to connect to local storage
Looking forward to your reply, thanks.
.

17

@Winnie.Wu,

I can connect to local storage, and even renamed the hub folder, so the local storage was recreated after restarting. I can connect to the local storage after restarting.

Despite this, when I try to open the heterogeneous query editor, only the regular query editor opens, not the heterogeneous one. Can you advise?

Thanks,

Adam