Runtime Error in Azure Data Factory RRS feed

  • Question

  • I am copying data from azure postgresql database to azure fileshare using azure datafactory. For Azure postgresql database I am using Self hosted IR and for Azure Fileshare I am using Azure hostes IR. But at the validation step I am getting below error.

    Fail to connect to AzureFileStorage1 from Integration Runtime: integrationRuntime1. Error message: Error occurred when trying to access the file in Folder '\\testoup.file.core.windows.net\test', File filter: ''. The network path was not found. .

    Tuesday, December 17, 2019 5:27 PM

All replies

  • Hello Vishal111890 and thank you for your question.  Is the Azure Hosted IR the 'AutoResolveIntegrationRuntime' (default) or one you created?

    As a debugging step, could you please try:

    1. manually upload a (test) file to Azure Fileshare
    2. use this test file as source in a copy activity, and do 'preview data'.  Let me know the results.

    If this succeeds, then:

    3. use this test file as both source and sink and do a debug run.

    Tuesday, December 17, 2019 10:58 PM