Get Meta Data Issue

Rohit Kulkarni 436 Reputation points
2021-03-25T08:52:11.363+00:00

Hello Team,

I am facing issue in Meta data activity issue
81501-image.png
error :

Field 'exists' failed with error: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'RequestUriTooLong'. Account: '. FileSystem: 'raw-zone'. Path: 'GPO Corp /Companies/Group O/{"count":1139,"value":[{"TableName":"Acc_ Sched_ "},{"TableName":"Acc_ Sched_ "},{"TableName":"Acc_ Sched_ "},{"TableName":"Acc_ Sched_"},{"TableName":"Acc_ Sched_ KPI Web"}, it is to long so i just make it short.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,275 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 32,976 Reputation points Microsoft Employee
    2021-03-25T23:11:56.327+00:00

    Hi @Rohit Kulkarni ,

    Thanks for your query. I believe something wrong with the path provided in the ADLS dataset of Get Metadata activity.

    Below path looks confusing. Not sure why a JSON array object is passed in the dataset path. Have you configured this or the path was populated by dynamic expression? Could you please confirm ? If you are using a dynamic expression to populate the path in dataset, please make sure that the expression is correct and it returns a valid path as expected.

    81589-image.png

    It seems like that JSON object in the path looks like an output of a Lookup activity. In case if you are trying to form the path like GPO Corp 2017/Companies/Group O/Acc_ Sched_ Cell Value then you should have this Get Metadata activity inside a ForEach activity, where under settings, the items = @activity('Lookup1').output.value

    Then your dataset path expression should be like : @concat('GPO Corp 2017/Companies/Group O/', dataset().ds_param_folder) Where dataset().ds_param_folder is the dataset parameter which maps to the current item of the iteration as below .

    81647-image.png

    And dataset path setting looks like below (this is just a sample for reference)

    81689-image.png

    Hope this helps.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    No comments