How to fix the " ErrorCode=JreNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Java Runtime Environment cannot be found on the Self-hosted Integration Runtime machine. It is required for parsing or writing to Parquet/ORC

Question

Issue with Pipeline SQL _ADLS_PARQUET

While validating their is no error shown but debugging time

Error:

ErrorCode=JreNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Java Runtime Environment cannot be found on the Self-hosted Integration Runtime machine. It is required for parsing or writing to Parquet/ORC files. Make sure Java Runtime Environment has been installed on the Self-hosted Integration Runtime machine.,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.Common.JavaUtils,'

13c2a73c-8715-4e01-a4c2-f6de82ce64a3

I have tried all possible troubleshooting methods 

1. Java IS installed
2. java -version works
3. SHIR is 64-bit
4. JAVA_HOME + PATH are correct
5. Service runs as Local System

Answer 1

Hey, it looks like you're encountering a Java Runtime Environment (JRE) issue while working with Azure Data Factory's Self-hosted Integration Runtime. This error usually occurs when the Integration Runtime cannot find the necessary JRE for parsing or writing to Parquet/ORC files, which can be a bit tricky to troubleshoot.

Given that you’ve already verified the installation of Java and confirmed that java -version works, here are some steps you can try:

1. Check Installation Path: Ensure that the JRE is installed in a location accessible to the Self-hosted Integration Runtime. Sometimes, multiple Java versions can cause confusion, so please double-check that the JRE path set in the JAVA_HOME environment variable points to the correct installation.
2. Check for 32-bit vs 64-bit Versions: Since you mentioned that your Self-hosted Integration Runtime is 64-bit, ensure that you have the 64-bit version of JRE installed. Mixing 32-bit and 64-bit versions can lead to issues like the one you're experiencing.
3. Permissions: Make sure that the Local System account (under which the SHIR service runs) has sufficient permissions to access the JRE installation path. Sometimes, permission issues can prevent the service from accessing necessary files.
4. Reinstall JRE: As a last resort, consider uninstalling and then reinstalling the JRE. Sometimes, a corrupt installation may lead to unpredictable behavior.
5. Check Logs: Look into the logs of the Self-hosted Integration Runtime for any additional error messages that could provide more context to the issue.

I hope these suggestions help you resolve the error! If the issue persists, feel free to share any additional details or specific error messages.

If you need further clarification on any of the steps or have additional questions, here are a few follow-up questions that might help:

1. What version of JRE are you using?
2. Can you confirm if there are multiple versions of Java installed on the machine?
3. Have you configured any specific Java options in the SHIR settings?
4. Have you checked for any recent changes to the environment (like updates or policy changes)?

Relevant Documentation

• Azure Data Factory - Fixing JRE Not Found Error
• Self-hosted Integration Runtime documentation

Let me know if you need any more help!

Answer 2

I have tried all the above steps i guess its product limitation/bug.

is there any possible ways to help me