Oracle Copy Data Activity Failed with Out of Memory issue

Question

Oracle Copy Data Activity Failed with Out of Memory issue

Jaganathan, Naveen 31

Hi Team,

I was trying to Run the Copy Data activity(Blob to Oracle table) in parallel(Around 13 Loads) and was facing Out of Memory issue for few loads with huge record count with around 120M records each. Then I tried to run only one load separately, then also I was facing below issue.

Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY001] [Microsoft][ODBC Oracle Wire Protocol driver]Out Of Memory,Source=,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY001] [Microsoft][ODBC Oracle Wire Protocol driver]Out Of Memory,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY001] [Microsoft][ODBC Oracle Wire Protocol driver]Out Of Memory,Source=msora28.dll,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY001] [Microsoft][ODBC Oracle Wire Protocol driver]Out Of Memory,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY001] [Microsoft][ODBC Oracle Wire Protocol driver]Out Of Memory,Source=msora28.dll,'

Please help me to resolve the issue. I am not able to perform the oracle copy data activity...

Thanks,
Naveen

MartinJaffer-MSFT 26,236 Reputation points

2023-01-03T19:36:53.493+00:00
Hello and welcome to Microsoft Q&A @Jaganathan, Naveen

To better assist, could you please add some more details?

Is this a Self-Hosted Integration Runtime, or an Azure Runtime?

What format is the blob in? Complex formats like JSON or Excel take more memory than simpler formats like CSV.
MartinJaffer-MSFT 26,236 Reputation points

2023-01-11T16:19:43.6733333+00:00

@Jaganathan, Naveen are you still facing the issue? We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

1 answer

Your answer

MartinJaffer-MSFT 26,236 Reputation points

2023-01-03T19:36:53.493+00:00

Hello and welcome to Microsoft Q&A @Jaganathan, Naveen

To better assist, could you please add some more details?

Is this a Self-Hosted Integration Runtime, or an Azure Runtime?

What format is the blob in? Complex formats like JSON or Excel take more memory than simpler formats like CSV.
MartinJaffer-MSFT 26,236 Reputation points

2023-01-11T16:19:43.6733333+00:00

@Jaganathan, Naveen are you still facing the issue? We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

Answer 1

JimmySalian-2011 42,491

Hi,

It seems connectivity issue and can you check the performance tuning guide over here. and also the troubleshooting guide if it helps?

If none of these helps, I will suggest you to raise a support case with Microsoft.

Hope this helps.
JS

==
Please Accept the answer if the information helped you. This will help us and others in the community as well.

Share via

Oracle Copy Data Activity Failed with Out of Memory issue

1 answer

Your answer