Forum Discussion
Notebook execution failed at Notebook service with http status code - '200'
Hi Team, I am getting errors while loading data into my bronze table through data factory, i have uploaded some data last friday and today i wanted to load some new data but after running the pipeline, i got error(same error) in gold layer notebook, so i delete all the data from all the layers and started reloading the data, starting from bronze but agaian got the same error :
the error is like this :
Notebook execution failed at Notebook service with http status code - '200', please check the Run logs on Notebook, additional details - 'Error name - UnsupportedOperationException, Error value - [DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE] Cannot perform Merge as multiple source rows matched and attempted to modify the same
target row in the Delta table in possibly conflicting ways. By SQL semantics of Merge,
when multiple source rows match on the same target row, the result may be ambiguous
as it is unclear which source row should be used to update or delete the matching
target row. You can preprocess the source table to eliminate the possibility of
multiple matches.
Hi Team, the issue got solved, it was issue related to quote
Hi ramankr48 ,
We really appreciate your efforts and for letting us know the update on the issue. Please accept your reply as Solution so as to help other community members who may come across this post in the future.
Please continue using fabric community forum for your further assistance.
Thank you
10 Replies
Hi, what options do you use when landing the data in the bronze lakehouse? It seems like you use a merge statement, but is it possible that your unique identifier is not unique in the source?
I am using the combination of student_id and course_id in fact table and in bronze and silver layer i have used individual column as unique identifier which is student_id and course_id respectively
Could you check the source with some sql scripts for example that the combination of student_id and course_id is always unique?
Hello ramankr48
The error occurs when:
1. Multiple rows in the source dataset match the same row in the target Delta table during a `MERGE` operation.
2. This leads to conflicting updates or deletions, as SQL cannot determine which source row should be applied to the target row.what are you doing in your copy activity?
Do you any sort of notebook doing merge?
Thanks
I am using the notebook, where I have written the merge query
Hello ramankr48 , Can you try dropping your table and rerun the full load if possible.
Hi ramankr48
May I ask if you have resolved this issue from suggestions mentioned by FabianSchut and nilendraFabric by verifing if combination of student_id and course_id is always unique? If so, please mark the helpful reply and accept it as the solution. And if some other troubleshooting step has worked please mention that step and Accept it as solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Team, the issue got solved, it was issue related to quote
Hi ramankr48 ,
We really appreciate your efforts and for letting us know the update on the issue. Please accept your reply as Solution so as to help other community members who may come across this post in the future.
Please continue using fabric community forum for your further assistance.
Thank you
