Microsoft IR Java Issue

Charles Godart 5 Reputation points
2023-08-07T09:05:18.0366667+00:00

Hi there,

I installed the Microsoft IR on my On premise server.

I created a copy activity connected to my on premise server using the IR.

When I run the process I face an issue regarding the Java version.

"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,'"

After investigation the Java version on my server is X86 and not X64.

I asked the IT to install the last X64 version but they refused because it will break the SAP server tools.

My question is how can I configure the IR using X64 ?

I need to do it without changing the JAVA HOME or find a solution to have them running in parallel.

Thanks and regards,

Charles

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
SQL Server Integration Services
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 91,656 Reputation points Moderator
    2023-08-08T05:03:13.36+00:00

    @Charles Godart - Thanks for the question and using MS Q&A platform.

    These are the system requirements to install Microsoft Integration Runtime.
    User's image

    Based on the error message you provided, it seems that the Java Runtime Environment platform does not match the process. The error message indicates that the process is running on a 64-bit platform, but the Java Runtime Environment is 32-bit.

    To use the 64-bit version of Java with the Integration Runtime, you need to install the 64-bit version of the Java Runtime Environment on your machine**.** However, if you cannot install the 64-bit version of Java on your machine, you can try the following workaround:

    1. Create a new environment variable called _JAVA_OPTIONS.
    2. Set the value of the _JAVA_OPTIONS variable to -d32.
    3. Restart the Integration Runtime service.

    This will force the Integration Runtime to use the 32-bit version of Java, which should resolve the issue. However, please note that this workaround may have performance implications, as the 32-bit version of Java may not be able to take full advantage of the resources available on your machine.

    Alternatively, you can try running the SAP server tools and the Integration Runtime on separate machines to avoid conflicts between the two.

    For more details, refer to [Installing self hosted runtime on windows 7(copying data from sql server to Data Lake(parquet) )](https://learn.microsoft.com/en-us/answers/questions/730985/installing-self-hosted-runtime-on-windows-7(copyin) which addressing similar issue.

    Hope this helps. Do let us know if you any further queries.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.