Forum Discussion
Advocate IDebugging Warehouse deployment errors
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
Solution SageHi 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
Amit_KThanks 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,
AK
uselessai_inHelper II
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.