SQL Assistant: System.ArgumentOutOfRangeException

Tools & Utilities
Enthusiast

SQL Assistant: System.ArgumentOutOfRangeException

Anyone know why I would be getting the below error during query execution? I'm assuming it has something to do with the grid that it is trying to populate with the results from the query.

SQLA Version: 13.10.0.7
Driver Version: Teradata.Net 13.11.0.1
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: value
at FarPoint.Win.Spread.Model.DefaultSheetAxisModel.SetSize(Int32 index, Int32 value)
at FarPoint.Win.Spread.SheetView.SetColumnWidth(Int32 column, Int32 value)
at Teradata.SQLA.Answer.SetColumnWidths() in F:\ttu1310_efix_snap\tdcli\qman\sqla\Answer.vb:line 235
at Teradata.SQLA.RunQry.FinishResultset() in F:\ttu1310_efix_snap\tdcli\qman\sqla\RunQry.vb:line 849
Tags (1)
7 REPLIES
Teradata Employee

Re: SQL Assistant: System.ArgumentOutOfRangeException

Can you reproduce this problem?
If so can you send me the SQL (or a stripped down version that still exhibits the problem) together with any Table/View definitions I would need to recreate it.
Send to: Mike.Dempsey@Teradata.com

I can see that the problem occurs when I try to adjust the widths of the columns to fit the data but in order to improve performance that process works differently depending on the data type of the columns.

The problem appears to be occuring when handling a 'wide' column - one where the data is wider than the width of the visible grid area.
Enthusiast

Re: SQL Assistant: System.ArgumentOutOfRangeException

Increase the "Maximum Response Buffer Size" value in SQL assistant properties to avoid this issue.

Re: SQL Assistant: System.ArgumentOutOfRangeException

How can I increase that?

Teradata Employee

Re: SQL Assistant: System.ArgumentOutOfRangeException

The Exception shown above (see the stack trace) is not related to the Maximum Response Buffer Size.

Teradata Employee

Re: SQL Assistant: System.ArgumentOutOfRangeException

This problem depends on the data type of the column it is trying to size.

I would need to know the definition of the columns returned by the query, the column titles [if different from the column names] and maybe some sample data.

A copy of the UserOptions.config file would also be helpful to determine your window sizes etc.

Changes were made that may have corrected this problem since 13.10.0.7. Have you tried the latest versions? (14.01, 13.11.0.5 or 13.10.0.9)

Re: SQL Assistant: System.ArgumentOutOfRangeException

I am using 13.10 at my client place. I am sure this is nothing with data definitions, because if I run the same query's in 12 - they are working fine. this is not the first time I am having hardtime. At my previous client place also I had the same issue (It was 13.10 again). I was bugging somany (like collegues/dba's). I couldn't get resolution. The strange thing is - other team members using the same version, however it is working fine except few. If you connect new session it will work some time. At my previous client place - I was frustrated with this issue and I went to install TD12. I was happy with 12. I do not have enough time to research on this issue. Does any one having same difficulty? If anyone know the resolution, please share it.

Teradata Employee

Re: SQL Assistant: System.ArgumentOutOfRangeException

SQLA 13.x uses completely different code to set the column widths, and that code varies depending on the data type/size.

The only way I have been able to reproduce this problem is if the Answerset mode is set to 'Never' and I have an existing answerset [that new answers will be written to] that is currently minimized.

Same would apply if multiple results were returned and you minimized the Answerset before all results had been returned.

To avoid the problem ensure that the Answer window is not too narrow. [Generally - Not minimized - which effectively has a width of zero]

I added 2 fixes in 13.11.0.5. (For TTU 13.10)

   1) avoids the 'narrow window' problem.

   2) traps any error that occurs while setting column widths and simply continues. (Widths may not be set)

Same fix is in 14.01.