Unable to start Cross Connection queries. Error: "There was a connect error. Check that the username and password are correct, that you have ..." (4243354)

Unable to start Cross Connection queries. Error: "There was a connect error. Check that the username and password are correct, that you have ..."

When trying to run or launch a Cross-Connection query, the following error message appears:

"There was a connect error. Check that the username and password 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."

If the Default Buffer Pool size is set to something over 1024MB. Setting it to 2048MB causes this issue.

The HUB in TDP is currently 32 bit. This means that the entire address space of the process cannot exceed 4GB (2^32). The buffer below is just one of several buffers and other things that need to fit into this address space. If the allocation of the buffer pool size fails, the HUB will fail to launch and exit.

Also the memory allocated for this buffer needs to be allocated in 1 continuous block of memory which means that if before it is allocated, the memory used has become fragmented (Very common), this can cause the maximum size to become slightly smaller than the available room.

There isn't a documented hard limit for this, but from testing seems to be around 1GB.

RESOLUTION #1:
Go to the Tools menu | Options | Local Storage | General, change the "Default Buffer Pool Size" setting to at least 256MB and no more than 1024MB.

 

Please re-install Toad Data Point as an Administrator user.