Sql request exceeds maximum allowed limit of 1 MB

dataservices job design
1

HI All.,

When i was loading transcational data to teradata database , attached is the error i was getting. It says that Sql request exceeds maximum allowed limit of 1 MB… Did google on this topic and foundout that it was to deal with ODBC connection but was not clear.

Any suggestions on solving this issue.

Thanks
Error.doc (20.0 KB)

paul.bods (BOB member since 2011-06-29)

2

Haha. Yup.

We need to reduce the commit size. When the number of columns to Teradata Target is really more then it has some limits on each line of data. So if you have your commit size set as 1000 then probably try reducing it to 500

Then it should work.

ganeshxp :us: (BOB member since 2008-07-17)

3

Thanks a lot Ganesh.

You are a life saver…

paul.bods (BOB member since 2011-06-29)

4

I had used Teradata as my Datawarehouse. Thats why 8)

ganeshxp :us: (BOB member since 2008-07-17)