Unable to load DLL jvm.dll The specified module could not be found Azure Data Factory V2 error












0















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










share|improve this question



























    0















    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










    share|improve this question

























      0












      0








      0








      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










      share|improve this question














      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







      azure azure-storage-blobs azure-data-factory azure-data-factory-2






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 22 '18 at 5:54









      arpan desaiarpan desai

      4521415




      4521415
























          2 Answers
          2






          active

          oldest

          votes


















          1














          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:




          • Confirm that your copy activity is using the correct integration runtime in ADF.

          • Double-check that the IR and JRE match bit-wise (e.g., both 64-bit)

          • Check that JAVA_HOME is set correctly in the environment variables

          • Check the registry key – HKEY_LOCAL_MACHINESoftwareJavaSoftJava Runtime Environment should have a Current Version entry that shows the current JRE version






          share|improve this answer
























          • After reinstalling IR and JRE it worked

            – arpan desai
            Dec 6 '18 at 6:29



















          0














          It might be related to Java not being installed on the relevant machine.



          Hope it helps!






          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53424666%2funable-to-load-dll-jvm-dll-the-specified-module-could-not-be-found-azure-data-fa%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            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:




            • Confirm that your copy activity is using the correct integration runtime in ADF.

            • Double-check that the IR and JRE match bit-wise (e.g., both 64-bit)

            • Check that JAVA_HOME is set correctly in the environment variables

            • Check the registry key – HKEY_LOCAL_MACHINESoftwareJavaSoftJava Runtime Environment should have a Current Version entry that shows the current JRE version






            share|improve this answer
























            • After reinstalling IR and JRE it worked

              – arpan desai
              Dec 6 '18 at 6:29
















            1














            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:




            • Confirm that your copy activity is using the correct integration runtime in ADF.

            • Double-check that the IR and JRE match bit-wise (e.g., both 64-bit)

            • Check that JAVA_HOME is set correctly in the environment variables

            • Check the registry key – HKEY_LOCAL_MACHINESoftwareJavaSoftJava Runtime Environment should have a Current Version entry that shows the current JRE version






            share|improve this answer
























            • After reinstalling IR and JRE it worked

              – arpan desai
              Dec 6 '18 at 6:29














            1












            1








            1







            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:




            • Confirm that your copy activity is using the correct integration runtime in ADF.

            • Double-check that the IR and JRE match bit-wise (e.g., both 64-bit)

            • Check that JAVA_HOME is set correctly in the environment variables

            • Check the registry key – HKEY_LOCAL_MACHINESoftwareJavaSoftJava Runtime Environment should have a Current Version entry that shows the current JRE version






            share|improve this answer













            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:




            • Confirm that your copy activity is using the correct integration runtime in ADF.

            • Double-check that the IR and JRE match bit-wise (e.g., both 64-bit)

            • Check that JAVA_HOME is set correctly in the environment variables

            • Check the registry key – HKEY_LOCAL_MACHINESoftwareJavaSoftJava Runtime Environment should have a Current Version entry that shows the current JRE version







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Dec 4 '18 at 19:32









            mmariemmarie

            4,68411329




            4,68411329













            • After reinstalling IR and JRE it worked

              – arpan desai
              Dec 6 '18 at 6:29



















            • After reinstalling IR and JRE it worked

              – arpan desai
              Dec 6 '18 at 6:29

















            After reinstalling IR and JRE it worked

            – arpan desai
            Dec 6 '18 at 6:29





            After reinstalling IR and JRE it worked

            – arpan desai
            Dec 6 '18 at 6:29













            0














            It might be related to Java not being installed on the relevant machine.



            Hope it helps!






            share|improve this answer




























              0














              It might be related to Java not being installed on the relevant machine.



              Hope it helps!






              share|improve this answer


























                0












                0








                0







                It might be related to Java not being installed on the relevant machine.



                Hope it helps!






                share|improve this answer













                It might be related to Java not being installed on the relevant machine.



                Hope it helps!







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 22 '18 at 7:23









                Itay PodhajcerItay Podhajcer

                2,0091412




                2,0091412






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53424666%2funable-to-load-dll-jvm-dll-the-specified-module-could-not-be-found-azure-data-fa%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown