topic Re: Mirroring in Fabric - Errors in Data Warehouse

Mirroring in Fabric - Errors

nehalpatel — Sat, 18 May 2024 09:25:42 GMT

First issue:

Is it possible to mirror Cosmos DB for MongoDB at this moment in time using Azure Cosmos DB for NoSQL connector? I have tried and getting ODBC error:

An exception occurred: ODBC: ERROR [HY000] [Microsoft][DocumentDB] (1) Error while attempting to use REST API: Server returned nothing (no headers, no data):

If there is a workaround to make this work any feedback would be appreciated. I am keen to run Fabric POC with data from my MongoDB.

Second issue:

I am getting error when trying to enable an exisitng Azure SQL Database for Fabric Mirroring:

"The database cannot be mirrored to Fabric due to below error: User does not have permission to mirror the database."

I have checked all the prequisites and they are correct.

As a test I did a export of the live database and restored the exported data to a new Azure SQL Database with SMI enabled during creation and also made the DB in Azure AD mode only. When attempting a Fabric Mirror connection with new database everything worked. This confirms all the Fabric enivironment configuration is correct so this can be excluded from troubleshooting.

With my exisiting databases they are running in mix mode and I can preview the tables during new mirrored Azure SQL database connection creation. I get the error when I click on the connect button.

This makes me think its some type of backend issue with fabric and exisiting Azure SQL Database. I am using my orginisation account with full admin rights to Azure SQL Server and database to do the initial connection test. I get the same issues when creating external user accounts as well a local SQL accounts with DBowner rights.

Checked completed

SMI is enabled and primary connection ID on DB
Networking
Database compute size.

Any feedback would be great.

Thanks

Re: Mirroring in Fabric - Errors

Anonymous — Wed, 22 May 2024 05:24:42 GMT

Hi nehalpatel ,

Thanks for using Fabric Community.
Apologies for the delay in reply from our side. Did you got a resolution for this?

Re: Mirroring in Fabric - Errors

Anonymous — Thu, 23 May 2024 10:18:43 GMT

Hello nehalpatel

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .
Thanks

Re: Mirroring in Fabric - Errors

nehalpatel — Thu, 23 May 2024 14:43:03 GMT

Hi Anonymous I do not have a solution to these problems yet.

Thanks,

Re: Mirroring in Fabric - Errors

Anonymous — Fri, 24 May 2024 10:49:09 GMT

Hi nehalpatel ,

Apologize for the issue you are facing. The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: Mirroring in Fabric - Errors

Anonymous — Mon, 27 May 2024 09:23:33 GMT

Hi nehalpatel ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to open a support ticket.
After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thanks

Re: Mirroring in Fabric - Errors

nehalpatel — Mon, 03 Jun 2024 21:41:45 GMT

I have a Microsoft support ticket logged and senior fabric engineer has confirmed environment setup is correct. They are investigating backend logs at the moment. I will provide an update once solution has been provided.

Re: Mirroring in Fabric - Errors

PrathyushaJ — Wed, 21 Aug 2024 09:31:14 GMT

Have you happened have solution for the error/issue?