DmsImportDatabaseException - Invalid object that exists in both workspaces - Deployment Pipeline

Hi ritz ,

Thank you for reaching out to the Microsoft Community Forum.

Please try below things to fix the issue.

1. Please check dependency order, verify that:

View_abc --> is created before View_2. All referenced objects exist under the same schema (audit).

2. Please try to re-create the schema & views in TEST. Because schema-level objects sometimes mismatch. In TEST, manually drop these objects:

audit.View_2
audit.View_abc

Also check if schema audit was created manually earlier. Let deployment recreate.

3. Please try to delete Warehouse from TEST and wait for sometime and then perform redeployment.

4. If your stored procedure uses CTAS, Drop the stored proc in TEST, Redeploy and Recreate after deployment.

Please refer below links.

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

Solved: Debugging Warehouse deployment errors - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Hi ritz , Not from Solution but from root cause perspective. This is becuase Child view is being created before the parent view. Based on the information I have and i might be wrong, this is because Fabric warehouse deployment is not sequence-based. Warehouse deployments are still object-level executions wrapped as item-level deployment. Fabric deploys the warehouse as a collection of independent SQL objects. When you deploy a data warehouse using deployment pipelines, Fabric appears to deploy the entire warehouse item but internally still operates at the object/script level. So it might not guarantee that a parent view is created before its child views. I don't know if dacfx/dacpac deploy would solve this issue, but that could be worth trying, or you could flatten the views to remove inter-view dependencies.