Archives of the TeradataForum

Message Posted: Wed, 28 Oct 2015 @ 11:56:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, October 28, 2015 07:50 -->

Hi all,

We are migrating from SQLa 13 to SQLa 14.10.0.08 and are encountering the below error on a select * query from a table with 149k rows and 273 columns.

In SQLa 13 it runs perfectly both via odbc and Teradata.net but in SQLa 14 it crashes out by either shutting SQLa down or producing the below error on both odbc and Teradata.net.

The pc we have loaded SQLa14 on has 24g of ram whereas the pc with SQLa13 has much less .

Has anyone come across this or would anyone have any advice?

Thanks in advance

     SQLA Version: 14.10.0.8
     Driver Version: Teradata.Net 14.11.0.1
     System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException'
     was thrown.
        at v.b(Int32 A_0, Int32 A_1)
        at v.h(Int32 A_0, Int32 A_1)
        at v.g(Int32 A_0)
        at FarPoint.Win.Spread.Model.DefaultSheetDataModel.set_RowCount(Int32 value)
        at Teradata.SQLA.RunQry.LoadDataGrid(Object ci) in V:\cm.client.ttu141.efix\tdcli\qman\sqla\RunQry.vb:line 1390
        at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
        at System.Threading.ExecutionContext.Run(ExecutionContext
     executionContext, ContextCallback callback, Object state, Boolean
     ignoreSyncCtx)
        at System.Threading.ExecutionContext.Run(ExecutionContext
     executionContext, ContextCallback callback, Object state)
        at System.Threading.ThreadHelper.ThreadStart(Object obj)

	<Prev	Next>		<<First	<Prev	Next>	Last>>