Installing self hosted runtime on windows 7(copying data from sql server to Data Lake(parquet) )

Question

I am trying to copying data from sql server to Data Lake(parquet).I have installed self hosted runtime on windows 7 64 bit.

I am following the below solution :

https://learn.microsoft.com/en-us/troubleshoot/azure/general/error-run-copy-activity-azure

The self hosted runtime is installed in C:\Program Files\

I am Trying To Install JRE on the same location(C:\Program Files) but it always pick : C:\Program Files (x86)\Java\jre1.8.0_321.

I have set the java_home path to : C:\Program Files (x86)\Java\jre1.8.0_321

Also there is not registry entry for JRE in windows 7 maching

I am still getting the below error.

{
"errorCode": "2200",
"message": "Failure happened on 'Sink' side. ErrorCode=JrePlatfromNotMatch,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Java Runtime Environment platform does not match the process: x64.,Source=Microsoft.DataTransfer.Common,''Type=System.BadImageFormatException,Message=An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B),Source=Microsoft.DataTransfer.Richfile.HiveOrcBridge,'",
"failureType": "UserError",
"target": "Copy_SQL_To_Parquet",
"details": []
}

Answer 1

Hello @Sunil Bailwal ,

Thanks for the question and using MS Q&A platform.

As we understand the ask here is that you have installed SHIR in Windows 7 operation system and trying to use it in your copy activity but having the above error. Please correct if I'm not accurate.

As per the official MS documentation, Self-Hosted Integration Runtime is supported only in below mentioned operating systems:

You can also refer to Requirements in Integration Runtime download page: Download Microsoft Integration Runtime

In general, for copy running on Self-hosted IR (hosted in the supported operating systems as mentioned above) with Parquet file serialization/deserialization, the service locates the Java runtime by firstly checking the registry (SOFTWARE\JavaSoft\Java Runtime Environment\{Current Version}\JavaHome) for JRE, if not found, secondly checking system variable JAVA_HOME for OpenJDK.

• To use JRE: The 64-bit IR requires 64-bit JRE. You can find it from here.
• To use OpenJDK: It's supported since IR version 3.13. Package the jvm.dll with all other required assemblies of OpenJDK into Self-hosted IR machine, and set system environment variable JAVA_HOME accordingly.
• To install Visual C++ 2010 Redistributable Package: Visual C++ 2010 Redistributable Package is not installed with self-hosted IR installations. You can find it from here.

Reference: Parquet format in Azure Data Factory

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

I am able to run the copy activity for parquet sink file on windows 7. I was installing wrong version JRE 32 bit. I installed the correct JRE 64 bit version and set the path for system variable JAVA_HOME = "C:\Program Files\Java\jre1.8.0_321"