The Issue Within one of our Azure DevOps builds we today started to see the following error when running the SonarQube analysis step: ##[error][SQ] Task failed with status FAILED, Error message: Unrecoverable indexing failures: 1 errors among 1 requests. Check Elasticsearch logs for further details. Nothing obvious pointed to why this should have started to occur, the SonarQube logs showed nothing more than a longer version of the same message....

Background In past years, pre Covid, Black Marble hosted a venue for the Global DevOps Bootcamp, a community run in person hackathon event. After a short hiatus, I am pleased to be able to say this event has a successor, the Global DevOps Experience which is being run on the 15th of June at many venues around the world, including Black Marble’s offices. What will be involved? The Global DevOps Experience is a day full of learning and fun, as we immerse you in the world of DevOps and AI....

The Issue We have a number of projects that use the old style SQL Server Reporting Services (SSRS) .RPTProj project format. These projects are not supported in Visual Studio 2022 out of the box, but there is an extension in the Marketplace that adds the functionality back so you can build them in the IDE. However, we want to build our RDL files as part of our CI process, and this is where we hit a problem....

Problem One of my client’s recently had a problem that a large number of Azure DevOps work items had been updated via Excel in error. They asked if there was a means to undo these edits. Unfortunately, a feature Azure DevOps does not provide. Solution So, I wrote a PowerShell script to do it. The script… Gets a list of work items edited today by a specific user, the one who did the problematic bulk update, using a Work Item Query Get the last update of each work item and check it was made by the user who did the bulk edit, incase someone manually fixed the problematic update already....

Background Programmatic connection to Azure DevOps cannot be done with your Active Directory credentials. This is because this involves a dialog being shown, and these days usually an MFA check too. Historically, the solution to this problem was to enable Alternate Credentials, which could be passed as username and password, without the dialog being shown. However, the use of these has been deprecated since 2020, and they have been completely removed since Jan 2024....