Teradata SQL assistant by default works in ANSI mode
0
Once for no reason Teradata sql assistant has started to work in ANSI mode, as result help view ..., show view, sel stopped to work:
After connection creating new sheets by ctrl+N - creates normal sheet, everything work well there:
However reconnecting breaks everything, so one more time is needeed to create working sheets.
Session mode is Teradata:
Versions:
It doesnt show any my connection lines:
How to fix this?
UPD1:
Log (deleted old and unsuccessful connections):
*******************************************************
20.08.2018 9:58:38
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.
в Teradata.Client.Provider.WpTcpTransport.<>c.<WaitOnSockets>b__52_0()
в Teradata.Client.Provider.UtlStopwatchWrapper.GetTimeRemaining(Int32 timeout, Action timeoutAction)
в Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, TdErrorCollection errors)
в Teradata.Client.Provider.WpTcpTransport.Connect(UtlStopwatchWrapper timer, Int32 timeout)
в Teradata.Client.Provider.WpSession.OpenTransport(UtlStopwatchWrapper timer, Int32 connectionTimeout)
в Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
в Teradata.Client.Provider.ExeContext`3.Open(Int32 timeout, String password)
в Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
в Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr)
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:строка 202
*******************************************************
28.08.2018 14:38:05
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
System.Exception: Exception handled in FpSpread.WndProc ---> System.NullReferenceException:
в FarPoint.Win.Spread.SpreadView.a(Int32 A_0, MouseEventArgs A_1)
в FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
в FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
в System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
--- Конец трассировки внутреннего стека исключений ---
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*******************************************************
13.09.2018 10:03:19
SQLA Version: 16.10.0.2
System.InvalidOperationException: Cant call Invoke or BeginInvoke on a control until the window handle has been completed.
в System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object args, Boolean synchronous)
в System.Windows.Forms.Control.BeginInvoke(Delegate method, Object args)
в System.Windows.Forms.Control.BeginInvoke(Delegate method)
в Teradata.SQLA.RunQry.ExecuteStatement() в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 645
в Teradata.SQLA.RunQry._Lambda$__3(Object a0) в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 357
в System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
в System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
в System.Threading.ThreadPoolWorkQueue.Dispatch()
в System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
*******************************************************
23.10.2018 18:08:44
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100015] Total size of all parcels is greater than the max message size.
в Teradata.Client.Provider.Request.VerifyRequestDoesNotExceedMaxBuffer(TeraTypeBase parameters)
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.Client.Provider.TdCommand.ExecuteDbDataReader(CommandBehavior behavior)
в System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.SQLA.TdConnectInfo.Execute(DbCommand cmd, String keyword, DbDataReader& rdr, Int64& rowCnt, Int32& errPos) в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 169
*******************************************************
07.11.2018 12:21:21
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).
[Teradata Database] [3110] The transaction was aborted by the user.
[Socket Transport] [115003] The receive operation timed out. ---> System.Net.Sockets.SocketException (0x80004005)
в System.Net.Sockets.Socket.Receive(Byte buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout)
в Teradata.Client.Provider.WpStartRequestManager.ReceiveStartMessage()
в Teradata.Client.Provider.WpStartRequestManager.Action(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.RedriveAction(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.Action()
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteNonQuery()
в Teradata.Client.Provider.TdConnection.ChangeDatabase(String databaseName)
в Teradata.Client.Provider.TdConnection.ExecuteInitializationStmts()
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 202
*******************************************************
sql teradata teradata-sql-assistant
asked Nov 9 at 8:20
Rocketq
1,52963873
add a comment |
0
Once for no reason Teradata sql assistant has started to work in ANSI mode, as result help view ..., show view, sel stopped to work:
After connection creating new sheets by ctrl+N - creates normal sheet, everything work well there:
However reconnecting breaks everything, so one more time is needeed to create working sheets.
Session mode is Teradata:
Versions:
It doesnt show any my connection lines:
How to fix this?
UPD1:
Log (deleted old and unsuccessful connections):
*******************************************************
20.08.2018 9:58:38
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.
в Teradata.Client.Provider.WpTcpTransport.<>c.<WaitOnSockets>b__52_0()
в Teradata.Client.Provider.UtlStopwatchWrapper.GetTimeRemaining(Int32 timeout, Action timeoutAction)
в Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, TdErrorCollection errors)
в Teradata.Client.Provider.WpTcpTransport.Connect(UtlStopwatchWrapper timer, Int32 timeout)
в Teradata.Client.Provider.WpSession.OpenTransport(UtlStopwatchWrapper timer, Int32 connectionTimeout)
в Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
в Teradata.Client.Provider.ExeContext`3.Open(Int32 timeout, String password)
в Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
в Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr)
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:строка 202
*******************************************************
28.08.2018 14:38:05
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
System.Exception: Exception handled in FpSpread.WndProc ---> System.NullReferenceException:
в FarPoint.Win.Spread.SpreadView.a(Int32 A_0, MouseEventArgs A_1)
в FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
в FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
в System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
--- Конец трассировки внутреннего стека исключений ---
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*******************************************************
13.09.2018 10:03:19
SQLA Version: 16.10.0.2
System.InvalidOperationException: Cant call Invoke or BeginInvoke on a control until the window handle has been completed.
в System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object args, Boolean synchronous)
в System.Windows.Forms.Control.BeginInvoke(Delegate method, Object args)
в System.Windows.Forms.Control.BeginInvoke(Delegate method)
в Teradata.SQLA.RunQry.ExecuteStatement() в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 645
в Teradata.SQLA.RunQry._Lambda$__3(Object a0) в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 357
в System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
в System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
в System.Threading.ThreadPoolWorkQueue.Dispatch()
в System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
*******************************************************
23.10.2018 18:08:44
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100015] Total size of all parcels is greater than the max message size.
в Teradata.Client.Provider.Request.VerifyRequestDoesNotExceedMaxBuffer(TeraTypeBase parameters)
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.Client.Provider.TdCommand.ExecuteDbDataReader(CommandBehavior behavior)
в System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.SQLA.TdConnectInfo.Execute(DbCommand cmd, String keyword, DbDataReader& rdr, Int64& rowCnt, Int32& errPos) в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 169
*******************************************************
07.11.2018 12:21:21
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).
[Teradata Database] [3110] The transaction was aborted by the user.
[Socket Transport] [115003] The receive operation timed out. ---> System.Net.Sockets.SocketException (0x80004005)
в System.Net.Sockets.Socket.Receive(Byte buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout)
в Teradata.Client.Provider.WpStartRequestManager.ReceiveStartMessage()
в Teradata.Client.Provider.WpStartRequestManager.Action(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.RedriveAction(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.Action()
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteNonQuery()
в Teradata.Client.Provider.TdConnection.ChangeDatabase(String databaseName)
в Teradata.Client.Provider.TdConnection.ExecuteInitializationStmts()
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 202
*******************************************************
sql teradata teradata-sql-assistant
asked Nov 9 at 8:20
Rocketq
1,52963873
That's strange. ANSI mode will still allowsel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?
– dnoeth
Nov 9 at 8:34
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
1
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07
add a comment |
0
0
0
Once for no reason Teradata sql assistant has started to work in ANSI mode, as result help view ..., show view, sel stopped to work:
After connection creating new sheets by ctrl+N - creates normal sheet, everything work well there:
However reconnecting breaks everything, so one more time is needeed to create working sheets.
Session mode is Teradata:
Versions:
It doesnt show any my connection lines:
How to fix this?
UPD1:
Log (deleted old and unsuccessful connections):
*******************************************************
20.08.2018 9:58:38
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.
в Teradata.Client.Provider.WpTcpTransport.<>c.<WaitOnSockets>b__52_0()
в Teradata.Client.Provider.UtlStopwatchWrapper.GetTimeRemaining(Int32 timeout, Action timeoutAction)
в Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, TdErrorCollection errors)
в Teradata.Client.Provider.WpTcpTransport.Connect(UtlStopwatchWrapper timer, Int32 timeout)
в Teradata.Client.Provider.WpSession.OpenTransport(UtlStopwatchWrapper timer, Int32 connectionTimeout)
в Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
в Teradata.Client.Provider.ExeContext`3.Open(Int32 timeout, String password)
в Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
в Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr)
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:строка 202
*******************************************************
28.08.2018 14:38:05
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
System.Exception: Exception handled in FpSpread.WndProc ---> System.NullReferenceException:
в FarPoint.Win.Spread.SpreadView.a(Int32 A_0, MouseEventArgs A_1)
в FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
в FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
в System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
--- Конец трассировки внутреннего стека исключений ---
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*******************************************************
13.09.2018 10:03:19
SQLA Version: 16.10.0.2
System.InvalidOperationException: Cant call Invoke or BeginInvoke on a control until the window handle has been completed.
в System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object args, Boolean synchronous)
в System.Windows.Forms.Control.BeginInvoke(Delegate method, Object args)
в System.Windows.Forms.Control.BeginInvoke(Delegate method)
в Teradata.SQLA.RunQry.ExecuteStatement() в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 645
в Teradata.SQLA.RunQry._Lambda$__3(Object a0) в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 357
в System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
в System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
в System.Threading.ThreadPoolWorkQueue.Dispatch()
в System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
*******************************************************
23.10.2018 18:08:44
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100015] Total size of all parcels is greater than the max message size.
в Teradata.Client.Provider.Request.VerifyRequestDoesNotExceedMaxBuffer(TeraTypeBase parameters)
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.Client.Provider.TdCommand.ExecuteDbDataReader(CommandBehavior behavior)
в System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.SQLA.TdConnectInfo.Execute(DbCommand cmd, String keyword, DbDataReader& rdr, Int64& rowCnt, Int32& errPos) в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 169
*******************************************************
07.11.2018 12:21:21
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).
[Teradata Database] [3110] The transaction was aborted by the user.
[Socket Transport] [115003] The receive operation timed out. ---> System.Net.Sockets.SocketException (0x80004005)
в System.Net.Sockets.Socket.Receive(Byte buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout)
в Teradata.Client.Provider.WpStartRequestManager.ReceiveStartMessage()
в Teradata.Client.Provider.WpStartRequestManager.Action(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.RedriveAction(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.Action()
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteNonQuery()
в Teradata.Client.Provider.TdConnection.ChangeDatabase(String databaseName)
в Teradata.Client.Provider.TdConnection.ExecuteInitializationStmts()
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 202
*******************************************************
sql teradata teradata-sql-assistant
asked Nov 9 at 8:20
Rocketq
1,52963873
Once for no reason Teradata sql assistant has started to work in ANSI mode, as result help view ..., show view, sel stopped to work:
After connection creating new sheets by ctrl+N - creates normal sheet, everything work well there:
However reconnecting breaks everything, so one more time is needeed to create working sheets.
Session mode is Teradata:
Versions:
It doesnt show any my connection lines:
How to fix this?
UPD1:
Log (deleted old and unsuccessful connections):
*******************************************************
20.08.2018 9:58:38
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.
в Teradata.Client.Provider.WpTcpTransport.<>c.<WaitOnSockets>b__52_0()
в Teradata.Client.Provider.UtlStopwatchWrapper.GetTimeRemaining(Int32 timeout, Action timeoutAction)
в Teradata.Client.Provider.WpTcpTransport.WaitOnSockets(List`1 sockets, UtlStopwatchWrapper timer, Int32 timeout, Int32 lccTimeout, TdErrorCollection errors)
в Teradata.Client.Provider.WpTcpTransport.Connect(UtlStopwatchWrapper timer, Int32 timeout)
в Teradata.Client.Provider.WpSession.OpenTransport(UtlStopwatchWrapper timer, Int32 connectionTimeout)
в Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
в Teradata.Client.Provider.ExeContext`3.Open(Int32 timeout, String password)
в Teradata.Client.Provider.Connection.Open(UtlConnectionString connectionString, UInt32 timeout)
в Teradata.Client.Provider.ConnectionFactory.GetConnection(Object owningObject, UtlConnectionString connStr)
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:строка 202
*******************************************************
28.08.2018 14:38:05
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
System.Exception: Exception handled in FpSpread.WndProc ---> System.NullReferenceException:
в FarPoint.Win.Spread.SpreadView.a(Int32 A_0, MouseEventArgs A_1)
в FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
в FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
в System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
--- Конец трассировки внутреннего стека исключений ---
в FarPoint.Win.Spread.FpSpread.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*******************************************************
13.09.2018 10:03:19
SQLA Version: 16.10.0.2
System.InvalidOperationException: Cant call Invoke or BeginInvoke on a control until the window handle has been completed.
в System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object args, Boolean synchronous)
в System.Windows.Forms.Control.BeginInvoke(Delegate method, Object args)
в System.Windows.Forms.Control.BeginInvoke(Delegate method)
в Teradata.SQLA.RunQry.ExecuteStatement() в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 645
в Teradata.SQLA.RunQry._Lambda$__3(Object a0) в v:cm.client.ttu16.xtdcliqmansqlaRunQry.vb:строка 357
в System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
в System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
в System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
в System.Threading.ThreadPoolWorkQueue.Dispatch()
в System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
*******************************************************
23.10.2018 18:08:44
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100015] Total size of all parcels is greater than the max message size.
в Teradata.Client.Provider.Request.VerifyRequestDoesNotExceedMaxBuffer(TeraTypeBase parameters)
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.Client.Provider.TdCommand.ExecuteDbDataReader(CommandBehavior behavior)
в System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
в Teradata.SQLA.TdConnectInfo.Execute(DbCommand cmd, String keyword, DbDataReader& rdr, Int64& rowCnt, Int32& errPos) в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 169
*******************************************************
07.11.2018 12:21:21
SQLA Version: 16.10.0.2
Driver Version: Teradata.Net 16.10.0.0
Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).
[Teradata Database] [3110] The transaction was aborted by the user.
[Socket Transport] [115003] The receive operation timed out. ---> System.Net.Sockets.SocketException (0x80004005)
в System.Net.Sockets.Socket.Receive(Byte buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.ReadLanHeader(Buffer buffer, Int32 timeout, Int32 readBytes)
в Teradata.Client.Provider.WpTcpTransport.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpSession.Receive(Buffer buffer, Int32 timeout)
в Teradata.Client.Provider.WpMessageManager.Receive(Int32 timeout)
в Teradata.Client.Provider.WpStartRequestManager.ReceiveStartMessage()
в Teradata.Client.Provider.WpStartRequestManager.Action(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.RedriveAction(ManagerActions step)
в Teradata.Client.Provider.WpStartRequestManager.Action()
в Teradata.Client.Provider.Request.ExecuteStartRequest(String commandText, TeraTypeBase parameters, ExecutionMode executionMode, Boolean asynchronous, Boolean isTrustedRequest)
в Teradata.Client.Provider.TdCommand.ExecuteRequest(CommandBehavior cmdBehavior, Boolean asynchronousCall, Boolean useStatementIndependence)
в Teradata.Client.Provider.TdCommand.ExecuteNonQuery()
в Teradata.Client.Provider.TdConnection.ChangeDatabase(String databaseName)
в Teradata.Client.Provider.TdConnection.ExecuteInitializationStmts()
в Teradata.Client.Provider.TdConnection.Open()
в Teradata.SQLA.TdConnectInfo.GetSession() в v:cm.client.ttu16.xtdcliqmansqlaTdConnectInfo.vb:line 202
*******************************************************
sql teradata teradata-sql-assistant
sql teradata teradata-sql-assistant
asked Nov 9 at 8:20
Rocketq
1,52963873
asked Nov 9 at 8:20
Rocketq
1,52963873
edited Nov 9 at 9:28
asked Nov 9 at 8:20
Rocketq
1,52963873
asked Nov 9 at 8:20
Rocketq
1,52963873
asked Nov 9 at 8:20
Rocketq
1,52963873
1,52963873
That's strange. ANSI mode will still allowsel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?
– dnoeth
Nov 9 at 8:34
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
1
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07
add a comment |
That's strange. ANSI mode will still allowsel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?
– dnoeth
Nov 9 at 8:34
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
1
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07
That's strange. ANSI mode will still allow
sel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?– dnoeth
Nov 9 at 8:34
That's strange. ANSI mode will still allow
sel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?– dnoeth
Nov 9 at 8:34
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
1
1
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07
add a comment |
1 Answer
1
active
oldest
votes
0
I have accidentally toggled on View / ANSI SQL option, disabling solved the problem
answered Nov 12 at 6:46
Rocketq
1,52963873
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222075%2fteradata-sql-assistant-by-default-works-in-ansi-mode%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
I have accidentally toggled on View / ANSI SQL option, disabling solved the problem
answered Nov 12 at 6:46
Rocketq
1,52963873
add a comment |
0
I have accidentally toggled on View / ANSI SQL option, disabling solved the problem
answered Nov 12 at 6:46
Rocketq
1,52963873
add a comment |
0
0
0
I have accidentally toggled on View / ANSI SQL option, disabling solved the problem
answered Nov 12 at 6:46
Rocketq
1,52963873
I have accidentally toggled on View / ANSI SQL option, disabling solved the problem
answered Nov 12 at 6:46
Rocketq
1,52963873
answered Nov 12 at 6:46
Rocketq
1,52963873
answered Nov 12 at 6:46
Rocketq
1,52963873
answered Nov 12 at 6:46
Rocketq
1,52963873
1,52963873
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222075%2fteradata-sql-assistant-by-default-works-in-ansi-mode%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
That's strange. ANSI mode will still allow
sel,show, etc., you probably still logon using Teradata mode, but it seems like SQLA doesn't load the syntax files for Teradata. When you look at the Database Explorer, does it show myconnection(Teradata)? Did you try to close & restart SQLA?– dnoeth
Nov 9 at 8:34
@dnoeth tried reloading even PC, problem persist for a long time. About myconnection(Teradata) - I provided pic, cant be sure
– Rocketq
Nov 9 at 8:55
I've never seen that behaviour and there's indication of a bugfix up to 16.20.00.04. Is there any information in C:Users...AppDataRoamingTeradataSQL AssistantSQLAError.Txt?
– dnoeth
Nov 9 at 9:13
1
Doesn't seem there's any info in the error text. Try posting the question on Teradata's community forum, Steve Feinholz (SQLA developer) monitors it: community.teradata.com/t5/Tools-Utilities/bd-p/3 Or open an incident with TD Customer Service.
– dnoeth
Nov 9 at 9:40
community.teradata.com/t5/Tools-Utilities/… did it
– Rocketq
Nov 9 at 12:07