Toad Data point Crash upon start

Toad Data Point & Toad Intelligence Central
1

Could anyone help with the error? it pops up and force close every time. TIA

image
image260×539 78.7 KB

MySqlException
Unable to connect to any of the specified MySQL hosts.

Stack Trace:

Server stack trace:
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.MySQL.MySQLConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.CloudDB.CloudDBConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
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, Nullable`1 secondRun)

Exception rethrown at [0]:
at Quest.Toad.Util.Global.RethrowKeepingStackTrace(Exception e)
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()

2

Welcome to the Toad Data Point Forum, BTW.

It's difficult to play Support Engineer on a forum without details and context. Stack traces are good for developers, but even they need some context leading up to the state which causes the issue.

For example, would help if we knew...

  • WIndows OS version
  • TDP version and bitness
  • Steps that you performed leading to the error message
  • etc.

The Stack trace seems to imply that you are connecting to a cloud data source... by chance, are you attempting to connect to a source that requires Multi-Factor Auth? If so, TDP doesn't yet support MFA for most sources... MFA support will be coming in later releases.

If getting over this issue is an urgent matter, I'd like to suggest that you open a Support ticket so we can have a Support Engineer discuss the details with you.

3

Thank you for your response. See additional info below:

  1. Windows 10 Enterprise

  2. TDP version: Toad Data Point 5.3.0.333 (64 bit)

  3. Once TDP start, I click “New connection”, trying to set up Apache Hive, “guardian initialization” in background process will start, the Apache Hive window is all grey out. The error message will pop in 1-2 min.

The TDP was newly installed, I set up Apache Hive connection before by then there was no this error. This error occurred all of sudden, not sure what triggered it.

image001.jpg

4

TDP 6.0.1 is the latest release. I'd like to suggest you upgrade that the latest version (v 5.3 is at least 2-3 years old) and see if it doesn't resolve your issue.

If not, you'll need to take this one to Support, please.