All Forums Tools
menard 1 post Joined 12/11
23 Dec 2011
Sql Assistant 13 doesn't allow more than 1 Show Table statement

I've had this error ever since I upgraded to 13.0 about a month ago.

I can submit a SHOW TABLE <tablename> in Sql Assistant once, but if the answerset is still displayed and I submit another SHOW TABLE statement I get a 'Key already exists' error.    It doesn't matter if it's the same table or not.  If I close the Answerset window it will allow another SHOW Table.  Anyone else heard of this problem?

this is was it writes to the SQLAError.txt file when it happens...

SQLA Version:
Driver Version: ODBC
System.ArgumentException: Key already exists
Parameter name: Key
   at Infragistics.Shared.KeyedSubObjectsCollectionBase.Vali dateKeyDoesNotExist(String key, IKeyedSubObject ignoreObject)
   at Infragistics.Shared.KeyedSubObjectsCollectionBase.Vali dateKeyDoesNotExist(String key)
   at Infragistics.Win.UltraWinTabControl.UltraTabsCollectio n.Add(String key, String text)
   at Teradata.SQLA.AnswerFrm.AddTab(String title, AnswerType typ, String dsn, String language) in F:\ttu1311_efix_snap\tdcli\qman\sqla\AnswerFrm.vb:line 199
   at Teradata.SQLA.MainFrm.GetNewAnswer(AnswerFrm& form, String formTitle, String tabTitle, AnswerType typ, String dsn, String language) in F:\ttu1311_efix_snap\tdcli\qman\sqla\MainFrm.vb:line 182
   at Teradata.SQLA.RunQry.DisplayResults(DbDataReader rdr, String stmt, Int32& rowCnt) in F:\ttu1311_efix_snap\tdcli\qman\sqla\RunQry.vb:line 455

umakathir 32 posts Joined 09/06
19 Sep 2012

Yes, I too faced the same issue... but I don't think it is specific to version 13.11 ... like Show table we also have issues with EXPLAIN.
There is an work around for this....
Instead of viewing the answerset in the window, you could Export the result into the file without any issues.

You must sign in to leave a comment.