topic Re: Internal server error occurred mirroring some tables from azure sql in Data Warehouse

Internal server error occurred mirroring some tables from azure sql

jmalcober — Thu, 01 Aug 2024 09:46:59 GMT

Hi,

After stopping and launch the replica from my azure sql database I get the following error from some tables (no all)

Internal server error occurred - artifact id: xxxxxxxxxxxxxxxxxx

Is someone facing the same issue?

Thnks in advance

Re: Internal server error occurred mirroring some tables from azure sql

Anonymous — Thu, 01 Aug 2024 02:05:17 GMT

Hi jmalcober ,

I have not seen any other users reporting this error.

Please note: The “Source” and “databaseID” parts of your attached screenshot reveal your sensitive information, so please re-edit them to make a mosaic.

The status “Running with warnings” is a warning that it is running with a temporary, non-fatal error.

You can check to see if the database has been used for any other operations or if there are other users occupying the current database resources at this point in time.

You can also try to stop the mirror, make sure all the configurations are correct and then start the mirror again to see if it solves the problem.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Internal server error occurred mirroring some tables from azure sql

jmalcober — Thu, 01 Aug 2024 09:50:47 GMT

Hi Anonymous ,

Thank you for your answer.

Following your recomendations I have done the following:

1. I stoped and started the replica. Same error in same tables.

2. I have deleted the replica and created a new replica with diferen name. Same error in same tables.

This error is blocking our development team. Any help is highly appreciated.

Re: Internal server error occurred mirroring some tables from azure sql

jmalcober — Fri, 02 Aug 2024 15:44:05 GMT

Hello Anonymous and community,

We are going crazy with this error, we have even deleted the replica and created from 0 and we getthe same errors in the same tables.

Any help? We are desperate

Re: Internal server error occurred mirroring some tables from azure sql

Anonymous — Mon, 05 Aug 2024 06:58:23 GMT

Hi jmalcober ,

I understand how you feel and there are a few things I would like to confirm with you:

What kind of table are you having problems with, is it a SQL native table or an externally hosted table? Is this table a normal table used to store data or is it a temporary table, such as one generated after running a SQL statement?
Are there any permissions or security policies set up to control access?
Is there any network access control set on the database itself?
Are there multiple workloads running at the same time? It should be much better if only one or two workloads are running.

Finally, since this is a preview feature that is still in beta, there may be some issues that are not mentioned in the documentation. Is this a high priority issue for you, is it very urgent and affecting your workload, if this is the case you can create a support ticket for free and a dedicated Microsoft engineer will resolve the issue for you.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Thank you for your understanding.

Best Regards,
Yang
Community Support Team

Re: Internal server error occurred mirroring some tables from azure sql

jmalcober — Tue, 06 Aug 2024 10:29:54 GMT

OK. Thany you for reply Anonymous ,

We have open a support case, and product team is reviewing the issue. Looks like is an internal bug.

Regards

Re: Internal server error occurred mirroring some tables from azure sql

AlainSmithers — Thu, 08 Aug 2024 18:48:21 GMT

I have the same error. I was able to successfully mirror several tables, but got the error when I added two large tables to the Replication Configuration. Even though the status is "Running with warnings", there are zero records added to the replica tables.

Re: Internal server error occurred mirroring some tables from azure sql

jmalcober — Thu, 08 Aug 2024 21:29:29 GMT

HI AlainSmithers ,

I opened a ticket 3 days ago to MS team, and product team detect a bug. According to information they gave to me this morning (cest) fix is already developed but pending to deploy. I will keep you updated once I have more news.

Regarda

Re: Internal server error occurred mirroring some tables from azure sql

AlainSmithers — Thu, 08 Aug 2024 22:47:57 GMT

Thanks. I've been trying to troubleshoot on my end - see what's different between the tables that fail and the ones that succeed. I found that the problem occurs when the primary key is a numeric data type. I made a copy of my table and changed the data type of the PK to VARCHAR and it worked. Not a very practical solution but at least I narrowed down the problem.

Re: Internal server error occurred mirroring some tables from azure sql

jmalcober — Fri, 09 Aug 2024 09:09:16 GMT

Fresh news from Microsoft Product Team:

As per PG Team:

“If the deployment schedule goes well, then it will be deployed in northeurope at around 8/31. It is a bug when dealing with decimal types. The most likely condition to hit this is when the decimal type column is included in the primary key.”

Best Regards