Unable to create new connection to hive

Have a pro license.
Every time i try to create a new connection to hive, get the below error

Unable to connect to any of the specified Data Service hosts.
Details:
Unable to connect to any of the specified Data Service hosts.
at Quest.Toad.CloudDB.CloudDBConnection.DoBeforeConnect()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.CreateConnection(ConnectMediator connOptions, OpenConnectSettings openConnectSettings)
at Quest.Toad.ConnectionManager.ConnectionFacade.NewConnection(ConnectMediator connectOptions, Boolean promptUIToConnectIfNeed, Nullable1 nbCreateDocumentsOnNewConnection, Nullable1 nbAddToGlobalConnectionList, Boolean bUseBackgroundConnector, ConnectionCreatedHandler onEndHandler, Nullable1 secondRun) at Quest.Toad.ConnectionManager.ConnectionFacade.GetConnection(ConnectMediator connectOptions, Boolean& isInGlobalConnectionList, Boolean promptUIToConnectIfNeed, Nullable1 nbCreateDocumentsOnNewConnection, Boolean bUseBackgroundConnector, ConnectionCreatedHandler onEndHandler)
at Quest.Toad.CloudDB.CloudDBConnectionControl.getConnection()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Hi Pradeep,
what version do you use? Which DB is it? Which DB version is it? When exactly do you get the error?

Version 5.1
Error is when i try to set-up a new connection

Can you zip the folder Logs in C:\Users%username%\AppData\Local\Quest Software\Toad Data Point Hub Data and send it here?

doesn't let me upload the zipped folder. IS there a mail i can send it to?

Can you send me a PM? If not you can always open a support request at Quest.com.

sorry could you please guide me on how to PM you

request your help .. please guide me on how I can send the file via PM / could you send me a PM so i can reply on it?

Hi,
I have read the logs and found it was because mysql_upgrade.exe failed to execute. Could you please help to find the err file called <your_machine_name>.err. it is located at C:\Users\prabhupr\AppData\Local\Quest Software\Toad Data Point Hub Data\data\xxx.err,
please send this file to dan or me (winnie.wu@quest.com), thanks.

1 Like

hi,
after you have send the err file, could you help to have a try:

  1. make sure TDP is closed and then go to rename the folder: C:\Users\prabhupr\AppData\Local\Quest Software\Toad Data Point Hub Data to a different name, e.g. Toad Data Point Hub Data_old.
  2. start TDP, then try to connect to apache hive, to see if you can connect successfully.

if you are still not able to connect, please go to the newly generated folder: "C:\Users\prabhupr\AppData\Local\Quest Software\Toad Data Point Hub Data" and then collect the following two files:
C:\Users\prabhupr\AppData\Local\Quest Software\Toad Data Point Hub Data\data***.err
C:\Users\prabhupr\AppData\Local\Quest Software\Toad Data Point Hub Data\logs\guardian_xxxx.log
send them to us: winnie.wu@quest.com

1 Like