question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked RohitKulkarni-3496 edited

Get Meta Data Issue

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
image.png (13.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT edited

Hi @rohitkulkarni-3496,

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.






image.png (11.1 KiB)
image.png (31.0 KiB)
image.png (23.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.