# Unable to connect to any of the specified Cross Query Hosts

**URL:** <https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 11, 2013, 1:36am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970 "2013-12-11T01:36:40Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![kees.lensvelt](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@kees.lensvelt](https://forums.toadworld.com/u/kees.lensvelt)\
**Post date:** [December 11, 2013, 1:36am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/1 "2013-12-11T01:36:40Z")

</div>

Hi,

I am using the trial version of TDP3.4 and I can’t create a new ‘Cross-Connection Query’ (ALT-X).

When doing this, the system is throwing the following error: Unable to connect to any of the specified Cross Query Hosts

It is also not possible to to connect to my Local Storage Connection: Unable to connect to any of the specified Local Storage Hosts

I have already reinstalled the trial version, but I that did not solve my problem.

Can you please advise?

[SYSTEM]  
Computer Name = NL02-HTXBGV1  
Computer Domain = SABICCORP  
Last Bootup Time = 12/11/2013 8:14:48 AM  
System Up Time = 02:20:21 (hh:mm:ss)  
Manufacturer = Dell Inc.  
Model = Latitude E6420  
Serial Number = HTXBGV1  
BIOS Type = Default System BIOS  
BIOS Version = A13  
Processor Name = Intel® Core™ i5-2520M CPU @ 2.50GHz  
Physical Memory = 4 GB  
Memory Banks = 2  
Memory Modules = 1  
IP Address = 3.252.57.88  
DN Computer = CN=NL02-HTXBGV1,CN=Computers,DC=SABICCORP,DC=SABIC,DC=com

[SITE]  
SiteID = NL02  
Pole = Europe  
Country = Netherlands  
City = Bergen op Zoom  
SiteDescription = Bergen op Zoom - SIP Manfacturing Site

[USER]  
User Name = 102003698  
User Full Name = Lensvelt, Kees (SABIC Innovative Plastics)  
User Domain = SABICCORP  
Administrator = Yes  
[OS]  
Operating System = Microsoft Windows 7 Enterprise  
Service Pack = 1  
Image = Apply Image Windows 7 version 2013 R1

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [December 11, 2013, 10:29am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/2 "2013-12-11T10:29:27Z")

</div>

Could you please check out the Task Manager that the following two processes are running after you tried to connect to Local Storage or execute x-query?

![6813.Capture.png](https://global.discourse-cdn.com/quest/original/2X/b/b09fabdf8d78f1f94833f8abf38d0d982b86123b.png)

Thanks

Aleksey

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 11, 2013, 7:34pm UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/3 "2013-12-11T19:34:37Z")

</div>

Try this solution.

 ![Knowledge article on hub wornt start.png](https://global.discourse-cdn.com/quest/original/2X/5/51b64638c3ae58c67ef44d70927118651df90fa7.png)

---

<div class="post-metadata">

**Author:** ![kees.lensvelt](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@kees.lensvelt](https://forums.toadworld.com/u/kees.lensvelt)\
**Post date:** [December 12, 2013, 5:11am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/4 "2013-12-12T05:11:05Z")

</div>

Aleksey/Debbie: you suggestions did work!

But…

When I was building a cross connection query based on two Oracle connections, with 2 tables and an expected result of one row, so to my understanding the most simple query. After two hours of running I cancelled the query, without any result…

If I query the single tables it gives a result within one second…

What can be wrong?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 13, 2013, 3:46pm UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/5 "2013-12-13T15:46:49Z")

</div>

How large are the two tables. Are you doing any filtering? can you post the Query?

---

<div class="post-metadata">

**Author:** ![kees.lensvelt](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@kees.lensvelt](https://forums.toadworld.com/u/kees.lensvelt)\
**Post date:** [December 14, 2013, 5:58am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/6 "2013-12-14T05:58:20Z")

</div>

To my understanding is the query ease and straight forward.

This is the query:

SELECT FSITEM.ITEM\_CODE

, FSITEM.COMPONENT\_IND

, FSITEM.DESCRIPTION

, FSITEM.CAS

, FSITEM.COMM\_CODE

, FSITEM.STATUS\_IND

, FSITEM.APPROVAL\_CODE

, FSITEM.HOLD\_CODE

, T\_PROD\_COMP.F\_CAS\_NUMBER

, T\_PROD\_COMP.F\_COMPONENT\_ID

, T\_PROD\_COMP.F\_CHEM\_NAME

, T\_PROD\_COMP.F\_TRADE\_SECRET\_CHEM\_NAME

, T\_PROD\_COMP.F\_HAZ\_FLAG

, T\_PROD\_COMP.F\_PERCENT

, T\_PROD\_COMP.F\_PERCENT\_RANGE

, T\_PROD\_COMP.F\_UNITS

, T\_PROD\_COMP.F\_TRADE\_SECRET\_FLAG

, T\_PROD\_COMP.F\_SARA\_FLAG

, T\_PROD\_COMP.F\_USER\_UPDATED

, T\_PROD\_COMP.F\_DATE\_STAMP

, T\_PROD\_COMP.F\_ORDER

FROM

`G026D_PKGG026D (GPD03), GPD03`.GPD03.FSITEM FSITEM

INNER JOIN

`P316P_PKGP316P (WERCS)`.WERCS.T\_PROD\_COMP T\_PROD\_COMP

ON (FSITEM.ITEM\_CODE = T\_PROD\_COMP.F\_PRODUCT)

WHERE FSITEM.ITEM\_CODE IN (‘333’, ‘259’)

---

<div class="post-metadata">

**Author:** ![kanuchris](https://avatars.discourse-cdn.com/v4/letter/k/c57346/32.png) [@kanuchris](https://forums.toadworld.com/u/kanuchris)\
**Post date:** [October 16, 2014, 8:18pm UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/7 "2014-10-16T20:18:28Z")

</div>

Hi Aleksy/Debbie-

I am having the same issue with TDP 3.5 install (Unable to connect to any of the specified Cross Query Hosts). I have done what Debbie suggested to delete the guardian lock file and that did not help. However I noticed that the Hubproxy and Guardian processes were not running as Aleksey suggested. I manually started the hubproxy application from the file folder and it showed up in the task manager but the guardian application could not be started. It starts and immidiately shuts down. With the hubroxy running I was getting a different error when I tried to open the cross connection query builder (MYSQL Database Error: Attempted to read past the end of the stream). Is it possible that if the guardian application process could be started, we should be ok? How do I make the these process to start when TDP is executed? Or is there something else going on here…please your help will be appreciated.

Chris

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [October 17, 2014, 7:40pm UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/8 "2014-10-17T19:40:21Z")

</div>

Can you add " /log=all" on the command line of your shortcut and restart toad? Reproduce the error and then generate a support bundle and post. I am looking for more detail in the toad.log file. Also, have you recently change the buffer size of Local Storage? Sometimes making that too large can cause problems.

---

<div class="post-metadata">

**Author:** ![thorsten.herrmann](https://avatars.discourse-cdn.com/v4/letter/t/ccd318/32.png) [@thorsten.herrmann](https://forums.toadworld.com/u/thorsten.herrmann)\
**Post date:** [July 2, 2019, 1:54pm UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/9 "2019-07-02T13:54:17Z")

</div>

Hi there.  
I just got an installtion of TOAD Data Point 5.0 and get the same error when I start a cross-connection query ("Unable to connect to any of the specified Cross Query hosts."). Any ideas?  
Regards,  
Thorsten

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [July 3, 2019, 3:25am UTC](https://forums.toadworld.com/t/unable-to-connect-to-any-of-the-specified-cross-query-hosts/27970/10 "2019-07-03T03:25:41Z")

</div>

First try starting Local Storage. We use this internal database when executing Cross Queries. If you are having difficulty starting local storage please open a support ticket and they will help you. They are very knowledgeable on this subject.
