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
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!
Amit_KHi 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 failuresHi 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 TeamIf 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!Thank you. Will do