Archives of the TeradataForum
Message Posted: Fri, 21 Jun 2013 @ 19:53:29 GMT
One of our development team is using SSIS ETL tool to load data from a SQL table to Teradata. The table has just 8 to 9 columns and they are trying to load just 30-130 records ,however the jobs are failing with error  Insufficient memory to parse this request, during QueryRewrite phase. The user is able to load other tables without any issues. All that the job is doing is copying data from SQL server and insert to Teradata table.
I looked at the previous posts which said , to increase the MaxParseTreeSegs value form the default 2000 to higher value. However I want to be sure before I made any change to the DBS control setting. Has anyone come across this issue?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|