question

MnhSamba-6277 avatar image
0 Votes"
MnhSamba-6277 asked KranthiPakala-MSFT commented

Error copying data from Amazom S3 into Azure Tables

Hello there This is the first time I am trying Data Factory. I am trying to copy data from AWS S3 bucket into an Azure Table Storage but I keep getting this error, any assistance would be highly appreciated:
78226-image.png

azure-data-factory
image.png (45.8 KiB)
· 8
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.

Hi @mnhsamba-6277,

Welcome to Microsoft Q&A forum and thanks for reaching out.
Could you please share the failed pipeline runId and failed activity runID? And also please do confirm what is the Integration runtime being used on both source as well as sink?

We look forward to your response.

Thanks

0 Votes 0 ·

Hi Kranthi
Thank you for your reponse.
The Pipeline runID: f10b6789-f1b5-4eb3-98f2-68ea91e018ae
Activity runID: 1af846ed-e300-48d7-b11e-d7843d199f2b

Integratin Runtime: AutoResolveIntegrationRuntime

Thanks

0 Votes 0 ·

Thanks for your response and details @mnhsamba-6277. As per the initial analysis, it seems to be an issue with the sink dataset (Azure Table Storage) configuration. Could you please share a screenshot of your sink settings? Suspecting something wrong with Partition Key or Row Key

78961-image.png

Also I would recommend to review the Property Names and Property Limitations section of this doc: Understanding the Table service data model and let us know how it goes


Thanks



0 Votes 0 ·
image.png (29.2 KiB)

Hi @mnhsamba-6277,

Just checking to see if you have got a chance to see my previous comment and review your sink settings as per the given document?

Do let us know how it goes.

Thanks

0 Votes 0 ·

Hi @mnhsamba-6277,

We still have not heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Thanks

0 Votes 0 ·

Hello @KranthiPakala-MSFT

Sorry about the delay in responding.
Heres a screenshot of the sink settings:
79954-image.png


0 Votes 0 ·
image.png (42.2 KiB)

Hi @mnhsamba-6277,

Sorry for the delay in response. Looks like you have the default settings. I tried to reproduce the issue but no luck. In case if you are still facing the issue, I would recommend to file a support ticket for deeper investigation. If you don't have a support plan please let us know here.


Thanks

0 Votes 0 ·

Hi @mnhsamba-6277,

Just checking to see if you have got a chance to file a support ticket? If you don't have a support plan, do let us know. Incase if you have already found a solution, please do share it here with community.

Thanks

0 Votes 0 ·

0 Answers