We are trying to copy data from on-premise SQL Server to Azure Blob storage. But we are facing below error :
Activity Copy_741 failed: Failure happened on 'Sink' side. ErrorCode=UserErrorJreNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Java Runtime Environment could not be found.,Source=Microsoft.DataTransfer.Common,''Type=System.DllNotFoundException,Message=Unable to load DLL 'jvm.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E),Source=Microsoft.DataTransfer.Richfile.HiveOrcBridge,'
On some other post, we found we need to install Microsoft Visual C++ 2010 Redistributable Package on Integration Runtime node but the latest version is already installed.
We are using Azure data factory v2. Also, we are able to transfer data from Azure SQL Server to Blob without any problem
Converting to ORC files requires the Java Runtime Environment to be installed on your self-hosted integration runtime. If you have already double-checked that you have the JRE and the C++ 2010 Redistributable installed, here are some other things to check:
It might be related to Java not being installed on the relevant machine.
Hope it helps!
User contributions licensed under CC BY-SA 3.0