Forum Discussion

Amit_K's avatar
Amit_K
Advocate I
1 year ago
Solved

Debugging Warehouse deployment errors

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 w...
  • Amit_Kar's avatar
    Amit_Kar
    1 year ago

    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