Exceed the memory limit of 20 MB.

Four Stars

Exceed the memory limit of 20 MB.

Can someone help me with the attached error

Moderator

Re: Exceed the memory limit of 20 MB.

Hello,

Have you tried to free up some space in your database? Did you enable "Use Batch Size" option in tMSSqlOutput component?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Exceed the memory limit of 20 MB.

Hello ,  yes we are using Batch limit of 100  in the output component. 

Moderator

Re: Exceed the memory limit of 20 MB.

Hello,

Are you using  oracle on Azure?

Could you please have a look at this article about:https://stackoverflow.com/questions/44188234/azure-exceeded-the-memory-limit-of-20-mb-per-session-fo...?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Exceed the memory limit of 20 MB.

I have same issue, any help on it?
Moderator

Re: Exceed the memory limit of 20 MB.

Hello,

Have you already checked this article to see if it helps?

https://stackoverflow.com/questions/44188234/azure-exceeded-the-memory-limit-of-20-mb-per-session-fo....

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Exceed the memory limit of 20 MB.

Hi, You got any solution for this 20 MB size limit. We also getting same issue, but when loading a bigger file like more than 100 MB file. Able to load 35 files with size less than 100 MB. When tried with 380 MB file getting same error. Tried with various batch size as 1000/500/100/10, still no luck. Please share if you got any solution. We also loading data to Azure DB from Talend enterprise edition.