Visual Studio 2019 and Azure Devops Pipeline Build Failed

PowerBI82 21 Reputation points
2021-01-28T18:47:37.243+00:00

Hi,

I recently installed Visual Studio 2019 and have a database project I am working on which I have cloned the Repository from Azure Devops Repos.
I created a test table on the project and then pushed and committed the changes just to make sure it appears on my branch, I then deleted this table and pushed and committed the changes to the branch as it was a test table and not required.

I then amended an existing view to add a new column, I pushed and committed the changed to the branch.

I then went to Azure Devops and created a Pull Request and this was completed.

I then went to the Pipelines and ran an an existing Build Project.
This where it failed with the error message:

2021-01-28T17:02:42.4303138Z ##[error]D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql(0,0): Error SQL72001: File "D:\a\1\s\Database Projects\NEWReporting\NEWReporting\DW Tables\Adm\Table1.sql" does not exist.

Not sure why it is still referencing the table "Table1.sql" as this is deleted from the Project on Visual Studio?

Any Ideas

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,794 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful