Retour
-
Titre
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. -
Description
In Toad Data Point (TDP), when trying to connect to Toad Intelligence Central (TIC), maybe to try to publish, one may see a pop-up window that says:
There was an error publishing your object.Please ensure Licensing in Toad Intelligence Central is up to date. If problem persists, please create a support bundle and contact support. Also ensure the connection uses an IP address or host name and not 'localhost'Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.In TDP's Support Bundle, in the file "ExceptionTrace.log", one may see:System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respondStack trace:at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)Outer exception:System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.Stack trace:at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)Outer exception:System.TimeoutException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.Stack trace:at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)at MySql.Data.MySqlClient.MySqlStream.LoadPacket()at MySql.Data.MySqlClient.MySqlStream.ReadPacket()at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)at MySql.Data.MySqlClient.MySqlDataReader.NextResult()at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)Outer exception:MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Stack trace:Server stack trace:at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)at Quest.Toad.Db.ProxyCommand.ExecuteReader(CommandBehavior behavior)Exception rethrown at [0]:at Quest.Toad.Util.Global.RethrowKeepingStackTrace(Exception e)at Quest.Toad.Db.ProxyCommand.ExecuteReader(CommandBehavior behavior)at Quest.Toad.Db.Connection.Query(ConnectionType type, CommandBehavior behavior, String sql, Object[] parameter)at Quest.Toad.CloudDB.CloudDBConnection.IsUserWindowsAuthAccount(String username)at Quest.Toad.CloudDB.CloudDBConnection.DoAfterConnect()at Quest.Toad.Db.Connection.Connect(Boolean notify)at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection() -
Cause
There is a snapshot in TIC with a name like this: "LPT1_xxx", and that name format is a problem for TIC when accessing the object, maybe to refresh it, or simply to execute a query such as: select * from AUX_XXX. -
Résolution
WORKAROUNDFor snapshots / views /datasets, do NOT use names started with the following words:CONPRNAUXNULLPT1LPT2LPT3LPT4LPT5LPT6LPT7LPT8LPT9COM1COM2COM3COM4COM5COM6COM7COM8COM9STATUSWaiting for a fix in a future release of Toad Intelligence Central -
Identifiant du défaut
TIC-10405