Serious Error when trying to connect to a existing Salesforce connection

Toad Data Point
1

Trying to connect to a Salesforce connection created some time ago now always results to a "Toad Shutdown" window raising a serious error: ProcessedExecutionExcepiont with below details copied to Clipboard:

ProcessedExecutionException
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

Stack Trace:
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()

2

What version of TDP are you using? Are you able to start Local Storage?

3

currently there is 4.3 and 5.0.3 installed and same issue faced in both versions. This worked after installation of 5.0.3 for considerable time and suddenly appeared.

4

From the message of the exception, the error is about authority authentication. Please ensure that the information in the "Credentials" tab in the "Connection Properties" window is valid and correct.
1.Can you login into https://login.salesforce.com/ correctly with your verify message?
2.Can you connect Local Storage correctly?
We need more information to analyze this issue. please generate a support bundle and send it to me.
Create support bundle steps:
1.Close TDP and right click TDP shortcut -> Properties -> Shortcut tab -> Target, append /log=all after the origin string, e.g. "C:\Program Files\Quest Software\Toad Data Point 5.0\toad.exe" /log=all

Image 6.png
Image 6.png363×524 12.6 KB

  1. Repreduce this issue.
  2. Help -> Support Bundle
    Image%204
    Image%205
  3. Send the support bundle to me :cjay.zhang@quest.com

Thanks.

5

We have not received a support bundle on this issue. If you would like to pursue sixths issue please open a support ticket.

6

The issue disappeared after updating to 5.0.4. Thx anyway.

7

Thjis is back in v 5.6

ProcessedExecutionException
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

Stack Trace:
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()

8

Hi Karl,
there is no Toad Data Point 5.6. Which of the Toads do you use? When does this error occur?
It is most often caused by a collision of antivirus and internal version of MySQL in Toad/TIC. It usually helps if you add the Toad and TIC folders to exclusions.

9

Dan,

Sorry I had mistyped the version. 5.1.6.206

The issue was resolved by tech support. The issue is I had to rename my Toad Data Point Hub directory to _OLD and restart. Seems like my connections are working fine now.

Best,
Karl