topic Re: Debugging Warehouse deployment errors in Data Warehouse

Debugging Warehouse deployment errors

Amit_K — Tue, 15 Oct 2024 15:06:42 GMT

Hi All,

what is the best way to debug warehouse deployment errors during deployment via pipelines.

I keep getting "Import failure: DmsImportDatabaseException" during deployment and I have no clue whats causing the issue.

I have checked and can confirm that none of the possible reasons flagged on the below issue apply in my case -

https://community.fabric.microsoft.com/t5/Data-Warehouse/Anyone-else-unable-to-deploy-a-data-warehouse-with-relationships/m-p/3827735

At the very least Microsoft should provide some avenues to debug the deployment issues or suggest some ways to do it no matter how cumbersome it may be.

Any suggestions would be greatly appreciated. It is worrisome to go live with the inability to debug deployment errors without raising with Microsoft support.

Cheers,

Re: Debugging Warehouse deployment errors

FabianSchut — Tue, 15 Oct 2024 15:21:54 GMT

Hi Amit_K,

I run into this issue once when the name of a table or view (please check the views too) was not correct. In my case, there was a dot in the name of the view. You could also check for other strange characters in the name.

The API of the deployment pipelines does give some information about an error that has occured, but I don't know if that gives more information than the "Import failure: DmsImportDatabaseException" message you already got. You could try it to be sure: https://learn.microsoft.com/en-us/rest/api/power-bi/pipelines/get-pipeline-operation#deploymenterror

Re: Debugging Warehouse deployment errors

Amit_K — Tue, 15 Oct 2024 15:51:56 GMT

Thanks FabianSchut . I dont think that is the issue here. The reason being the fact when I deleted the target warehouse and redeployed, it deployed fine. I could do that now as we are still in development phase and a complete no go when we go live. I will check out the link that you have posted and see if it provides some extra details on the error.

Cheers,

Re: Debugging Warehouse deployment errors

Anonymous — Wed, 16 Oct 2024 01:52:01 GMT

Hi Amit_K ,

Thanks for the reply from FabianSchut .

Here are some of my suggestions:

Ensure that there are no special characters or reserved words in table or column names.

Avoid using special characters such as hyphens in schema names.

If the table creation script is very large (more than 4000 characters), try breaking it up.

Here's a user with a similar problem to yours that may help you:

Solved: Anyone else unable to deploy a data warehouse with... - Page 3 - Microsoft Fabric Community

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: Debugging Warehouse deployment errors

Amit_K — Wed, 16 Oct 2024 08:42:10 GMT

Hi Anonymous , I did go through the list of potential issues in the raised in the link that flagged but none of them apply in my case. I just tried to use the API link mentioned here (https://learn.microsoft.com/en-us/rest/api/power-bi/pipelines/get-pipeline-operation#deploymenterror) to check if it provides a little bit more detail . I see this :

"error": {

"errorCode": "CopyOverwriteResult.GenericError",

"errorDetails": "Import failure: DmsImportDatabaseException"

}

Now , what does this errorcode indicate. It would be very helpful if microsoft can provide some documentation around these error codes at the very least, not that we have an API which seems to provide a tiny little bit more information on the deployment failures

Re: Debugging Warehouse deployment errors

Anonymous — Thu, 17 Oct 2024 07:15:53 GMT

Hi Amit_K ,

Unfortunately, there is no detailed documentation specific to this error code.

You can create a support ticket for free, providing them with the error code and any associated logs will help speed up the troubleshooting process and a dedicated Microsoft engineer will resolve the issue for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

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: Debugging Warehouse deployment errors

Amit_Kar — Fri, 18 Oct 2024 08:52:56 GMT

Thank you. Will do

Re: Debugging Warehouse deployment errors

Anonymous — Mon, 21 Oct 2024 08:30:03 GMT

Hi Amit_Kar ,

Thanks for your cooperation.

If there are any subsequent developments or solutions you can share at the bottom of this thread, I'm sure this will be of great help to users experiencing similar issues.

Best Regards,
Yang
Community Support Team

Re: Debugging Warehouse deployment errors

Anonymous — Tue, 29 Oct 2024 06:40:52 GMT

Hi Amit_K ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

Re: Debugging Warehouse deployment errors

Amit_Kar — Tue, 29 Oct 2024 11:51:55 GMT

Hi Yang,

I have not managed to raise a support ticket for the overall issue of "lack of avenues to debug pipeline deployment errors", but I have now found that any procs with CTAS statements in them need to be dropped in the target before deployment. I am using CTAS statements to fill the gap due to lack of temp tables in fabric. So , we need to add this to the list of checks prior to triggering a pipeline deployment.

Cheers,

Amit

Re: Debugging Warehouse deployment errors

Anonymous — Thu, 31 Oct 2024 07:24:31 GMT

Hi Amit_Kar ,

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

Thank you for your cooperation!

Best Regards,
Yang
Community Support Team

Re: Debugging Warehouse deployment errors

uselessai_in — Thu, 09 Jan 2025 12:21:08 GMT

Find the solution here guys.

Find all deployment related issues with their creative solutions here. I tested and implemented all of them. Hope it helps.

link - https://uselessai.in/dont-use-set-variable-activity-in-data-factory-pipeline-microsoft-fabric-bf74fa7d0d34?source=---------0-----------------------

2. https://uselessai.in/microsoft-fabric-interesting-and-hidden-deployment-observations-important-bug-fixes-a87d4c8512db?source=---------1-----------------------

3. https://uselessai.in/microsoft-fabric-stored-procedure-not-reflecting-warehouse-connection-change-in-data-factory-e0dc96e6ce83?source=---------2-----------------------

4. https://uselessai.in/microsoft-fabric-warehouse-deployment-issue-s-and-potential-solution-s-9ad360411f7a?source=---------3-----------------------

Re: Debugging Warehouse deployment errors

uselessai_in — Thu, 09 Jan 2025 12:23:07 GMT

You can check this Amit. I hope it helps.

Find all deployment related issues with their creative solutions here. I tested and implemented all of them. Hope it helps.

link - https://uselessai.in/dont-use-set-variable-activity-in-data-factory-pipeline-microsoft-fabric-bf74fa7d0d34?source=---------0-----------------------

2. https://uselessai.in/microsoft-fabric-interesting-and-hidden-deployment-observations-important-bug-fixes-a87d4c8512db?source=---------1-----------------------

3. https://uselessai.in/microsoft-fabric-stored-procedure-not-reflecting-warehouse-connection-change-in-data-factory-e0dc96e6ce83?source=---------2-----------------------

4. https://uselessai.in/microsoft-fabric-warehouse-deployment-issue-s-and-potential-solution-s-9ad360411f7a?source=---------3-----------------------