SQL Assistant : System.ArgumentOutOfRangeException

Teradata Applications

SQL Assistant : System.ArgumentOutOfRangeException

Hi Guys,


I am facing a problem with my Teradata SQL Assistant It is throwing below error whenever I am trying to open it. I had re-installed it also but facing the same problem. Need help how to resolve it.


Just after the status of "Loading Database Explorer Tree" the pop up is coming as shown below. 



SQLAError.txt File is having the below log. 


7/9/2018 10:25:04 PM
SQLA Version:
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at Infragistics.Win.UltraWinTree.TreeNodesCollection.get_Item(Int32 index)
at Teradata.SQLA.MainFrm.LoadCurrentDbViews(String dsn, String& db, List`1& viewList, String oldDsn, String& oldDb) in v:\cm.client.ttu150\tdcli\qman\sqla\MainFrm.vb:line 514
at Teradata.SQLA.QueryFrm.SetCurrentDB(String dsn, String db, Boolean refresh) in v:\cm.client.ttu150\tdcli\qman\sqla\QueryFrm.vb:line 494
at Teradata.SQLA.QueryFrm..ctor() in v:\cm.client.ttu150\tdcli\qman\sqla\QueryFrm.vb:line 223
at Teradata.SQLA.MainFrm.Form_Load(Object sender, EventArgs e) in v:\cm.client.ttu150\tdcli\qman\sqla\MainFrm.vb:line 2298


And if I click on OK on the pop up the next screen is coming as shown below.


SQLAError.txt File is getting updated with the below log. 


7/9/2018 10:31:07 PM
SQLA Version:
System.NullReferenceException: Object reference not set to an instance of an object.
at Teradata.SQLA.MainFrm.Form_Load(Object sender, EventArgs e) in v:\cm.client.ttu150\tdcli\qman\sqla\MainFrm.vb:line 2350
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Teradata Employee

Re: SQL Assistant : System.ArgumentOutOfRangeException

SQL Assistant is quite old and is an initial release with no maintenance fixes applied. I would consider upgrading.


But to answer your question, this can sometimes be caused by a corrupted .config file (in the same folder where you found SQLAError.Txt file).

Based on the traceback, you can try renaming the customized Toolbars.config (which will restore the defaults).