Deploying Warehouse fails

[Thomas_Pi]

I have a workspace containing different objects, among others one warehouse. I can deploy all objects with a deployment pipeline, except the warehouse. When initially deployed, I get the error "Import failure: DmsImportDatabaseException".

Even though, the warehouse is then deployed from DEV to TEST. But when I try to update all objects, or only the warehouse, I get the error that there is already an item with the same name in the target, which are not bound:

When I delete the Warehouse in the target and wait for the common 15 minutes or more, it starts again from the first error message. 

Does anyone had similar issues or any ideas how to solve it? Already waiting for support for more than one month without any help so far.

[evrise]

Guys, sorry, but this is the same as all released Fabric features. Nothing is designed well to be linked with the whole Fabric ecosystem. I gave two chances to this feature.... Now (after months)  its still not working.

Each part has own team. and nothing works together properly. The current issue is, that if you move warehouse from one workspace to another, it will change the ID. That fine, and its obvious. But somebody who designed warehouse Git integration did not work with this information. So whenever you want to checkout branch from your dev collaborate workspace to your own one. It will fail and you can not merge your changes back again, cause in git, there is no only db project. but some config files with warehouse id. And yea. warehouse in your branch is now no that one in main branch 🙂 

[AndyDDC]

To be honest I'm not using deployment pipelines as they're not flexible enough to suit a variety of ci-cd options.

[evrise]

Thanks @AndyDDC , but am not talking about deployment pipelines just now. This is step before, when you want to make cahnges as a developer an merge it back to main branch (CI). Deployment pipelines is the next step (CD). 

But if would be so kind, can you describe shortly how do you do CI on your site ? Do you have exported dacpac locally, making changes there and build project within DevOps CI pipelne, or something different ? Thanks a lot for ur time.

[AndyDDC]

Hi @Thomas_Pi there's a thread here that may help:

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

[Thomas_Pi]

Hi @AndyDDC 
Thanks for the link. I've seen this before, and tried to delete the relationships, but didn't help in my case. Also other tipps didn't work which are mentioned.