Forum Discussion
Mirroring Azure SQL database in Fabric
I was able to folow the tutorial, but if I look in the SQL database and run this command:
SELECT * FROM sys.dm_change_feed_errors;I see a lot of entries where error_message = "Error occurred while interacting with landing zone."
Does anyone know what it means?
Hi Martin_inndx ,
Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I actually got it working. I did not give the Managed Identity access to the Fabric Workspace.
One other thing that I don't understand is why each table that get's mirrored, have "dbo_" appended infront of the table names. I suppose I need to create a new topic for that.
I keep encountering the error message: 'Error occurred while interacting with the landing zone,' even though I have granted Managed Identity access to the Fabric Workspace.
Martin_inndx did you get any explanation regardig the error
"Error occurred while interacting with landing zone"?
I have issus with a mirror for a Azure SQL-database and this is the error that occur in sys.dm_change_feed_errors
Thx!Is this issue resolved? how did you fix error_message = "Error occurred while interacting with landing zone." and Error_State = 2 and 13.
