TDP 5.3 Win10
A recent security update is causing a name resolution error for Teradata alias'. Our server alias isn't being resolved. The fix is to use an FQDN instead of the alias. In Teradata SQL Assistant, if we set the Data Source DNS Entries value to a single digit integer, there are no connection issues. I'd like to find something similar to workaround for TDP.
Of course it works for basic reporting to update the connection properties to the FQDN but the txp/tim TRL references are still to the alias which of course breaks the report process.
We're still looking for a fix but any suggestions here would be greatly appreciated.
Error is:
System.Net.Sockets.SocketException
This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server
Stack Trace:
at System.Net.Dns.GetAddrInfo(String name)
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at Teradata.Client.Provider.WpTcpTransport.WpDataSourceResolver.Initialize(UtlStopwatchWrapper timer, Int32 timeout)
at Teradata.Client.Provider.WpTcpTransport.WpDataSourceResolver.GetHost(UtlStopwatchWrapper timer, Int32 timeout)
at Teradata.Client.Provider.WpTcpTransport.Connect(UtlStopwatchWrapper timer, Int32 timeout)
at Teradata.Client.Provider.WpSession.OpenTransport(UtlStopwatchWrapper timer, Int32 connectionTimeout)
at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
at Teradata.Client.Provider.ExeContext`3.Open(Int32 timeout, String password)
at Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
at Teradata.Client.Provider.ConnectionPool.CreateConnection(UInt32 timeout)
at Teradata.Client.Provider.ConnectionPool.GetConnectionFromPool(Object owningObject)
at Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString conStr)
at Teradata.Client.Provider.TdConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.Teradata.TeradataConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()