- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Failed lookups and duplicate insert in copy activity. Temporary server problem?
Hi!
My pipeline have been running well for about a week, but tonight some of the tables that were supposed to be loaded failed due to this error in a lookup:
ErrorCode=SystemErrorFailedToGetAccessTokenByUserAuth,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Internal Server Error. Please retry later. If issue consist repro, please contact us.,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.DataTransfer.TokenService.Client.Models.ErrorResponseException,Message=Operation returned an invalid status code 'InternalServerError',Source=Microsoft.DataTransfer.TokenServiceClient,'
The lookup is referencing a table in my Data Warehouse. And most of the lookups worked, but some failed. I wonder what this error means? And do you have some suggestions on how to avaoid tehm in the future?
Also, after the lookup I run a copy activity. And for three of my tables (where the lookup worked) the data got inserted twice into my Lakehosue table, causing duplicates. But I have the settings on "overwrite" so that shouldn't happen:
How can this be avoided in the future?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got an answer from the support team:
Thanks for sharing the information. Firstly, apologies for the inconvenience caused. After some time investigating on the issue and checked with the backend logs, we have come to know that the issue has been caused due to outage in North Europe region during that timeframe and it is mitigated now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JE_test
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JE_test
Apologies for the inconvenience. Internal team has suggested to open a support ticket.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JE_test
We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I created a ticket now: 2405020050000585
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got an answer from the support team:
Thanks for sharing the information. Firstly, apologies for the inconvenience caused. After some time investigating on the issue and checked with the backend logs, we have come to know that the issue has been caused due to outage in North Europe region during that timeframe and it is mitigated now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JE_test
Glad that you query got resolved and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.
Thank you.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-18-2024 02:24 AM | |||
04-18-2024 09:33 PM | |||
08-28-2024 03:58 PM | |||
01-20-2025 01:27 AM | |||
04-30-2024 05:58 AM |
User | Count |
---|---|
4 | |
3 | |
3 | |
1 | |
1 |
User | Count |
---|---|
9 | |
8 | |
7 | |
6 | |
4 |