Archives of the TeradataForum
Message Posted: Wed, 28 Oct 2015 @ 11:56:17 GMT
<-- Anonymously Posted: Wednesday, October 28, 2015 07:50 -->
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: 22.214.171.124 Driver Version: Teradata.Net 126.96.36.199 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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|