Forum Discussion
Helper IFUAM Load_Items_E2E Error in Copy Data
Hi all.
Solution was just to upload the notebook "Deploy_FUAM" and run it again. This solved the issue, so I'm guessing it was something with an update that has been done to this notebook.Thanks to everyone that helped!
Community SupportHi pbi_taken,
Thank you for reaching out and providing the error details. Also thanks mabdollahi, for his inputs on this issue.
The issue arises from the creatorPrincipal column in your active_items table. This column appears to contain a complex or unsupported data type (such as a nested object or user principal), which is not supported by the Delta format in Lakehouse.
To address this, you will need to exclude the creatorPrincipal column from your data source before the pipeline processes it.
Create a new version of your table (or view) that removes the problematic column:
CREATE OR REPLACE TABLE active_items_clean AS
SELECT * EXCEPT (creatorPrincipal)
FROM active_items;
Update your Copy Data / Load_Items_E2E pipeline to point to active_items_clean instead of the original active_items table.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Community SupportHi pbi_taken,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.