'ErrorCode=SystemErrorOutOfMemory' when running Copy data activity in Fabric Pipeline

Hello

I am using Fabric pipeline activity to copy data from on-prem SQL server database to Fabric lakehouse. It works good. So I schedule a hourly run.

What interesting is during this weekend, It run failed after several times success as below screenshot shown.

And after two times failed, it always run successfully again.

Checked the run log, it's error msg:

{
"copyDuration": 52,
"errors": [
{
"Code": 8000,
"Message": "ErrorCode=SystemErrorOutOfMemory,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A task failed with out of memory.,Source=Microsoft.DataTransfer.TransferTask,''Type=System.OutOfMemoryException,Message=Exception of type 'System.OutOfMemoryException' was thrown.,Source=Microsoft.DataTransfer.ClientLibrary,'",
"EventType": 0,
"Category": 5,
"Data": {
"OutOfMemory": "Exception of type 'System.OutOfMemoryException' was thrown."
},
"MsgId": null,
"ExceptionType": null,
"Source": null,
"StackTrace": null,
"InnerEventInfos": []
}
],
"usedParallelCopies": 1,
"executionDetails": [
{
"source": {
"type": "SqlServer"
},
"sink": {
"type": "Lakehouse"
},
"status": "Failed",
"start": "12/2/2024, 12:46:00 AM",
"duration": 52,
"usedParallelCopies": 1,
"profile": {
"queue": {
"status": "Completed",
"duration": 0
},
"transfer": {
"status": "Completed",
"duration": 3
}
},
"detailedDurations": {
"queuingDuration": 0,
"transferDuration": 3
}
}
],
"dataConsistencyVerification": {
"VerificationResult": "Unsupported"
}
}

Any idea / suggestions regarding this issue?

Thanks.