Aug 22 2023
02:21 PM
- last edited on
Mar 05 2024
02:57 PM
by
TechCommunityAP
Aug 22 2023
02:21 PM
- last edited on
Mar 05 2024
02:57 PM
by
TechCommunityAP
We are in plan of migrating Azure DevOps Server (On-Prem) data to Azure DevOps Services (Cloud).
As part of that, we have initiated the dacpac creation from source database via Visual studio's SQL Server Object Explorer by selecting the option of 'Extract Data tier Application' and facing the below error
> Error SQL71501: Error validating element \[Build\]. \[prc_GetRunnablePausedBuilds\]: Procedure: \[Build\]. \[prc_GetRunnablePausedBuilds\] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: \[Build\].\[tbl_Build\]. \[BuildId\], \[Build\].\[tbl_Definition\] .\[BuildId\] or \[Build\].\[tbl_PausedQueue\]. \[BuildId\].
Please help me to resolve this.
We tried to restore the latest database backup of main server (Source) and retried the same, but not worked.
Aug 22 2023 05:17 PM
Aug 30 2023 04:46 AM - edited Aug 30 2023 04:47 AM
Hi @Kidd_Ip ,
Thanks for your input
We are using latest package.
And this issue resolved when we rerun the dacpac creation process 2nd time without changing anything