2026-03-09T00:23:18.5047888Z ##[section]Starting: Run DwSql Integration Tests 2026-03-09T00:23:18.5057673Z ============================================================================== 2026-03-09T00:23:18.5057877Z Task : .NET Core 2026-03-09T00:23:18.5057998Z Description : Build, test, package, or publish a dotnet application, or run a custom dotnet command 2026-03-09T00:23:18.5058205Z Version : 2.269.0 2026-03-09T00:23:18.5058328Z Author : Microsoft Corporation 2026-03-09T00:23:18.5058469Z Help : https://docs.microsoft.com/azure/devops/pipelines/tasks/build/dotnet-core-cli 2026-03-09T00:23:18.5058654Z ============================================================================== 2026-03-09T00:23:18.8409490Z Info: .NET Core SDK/runtime 2.2 and 3.0 are now End of Life(EOL) and have been removed from all hosted agents. If you're using these SDK/runtimes on hosted agents, kindly upgrade to newer versions which are not EOL, or else use UseDotNet task to install the required version. 2026-03-09T00:23:19.0092341Z [command]/opt/hostedtoolcache/dotnet/dotnet test /home/vsts/work/1/s/src/Cli.Tests/Cli.Tests.csproj --logger trx --results-directory /home/vsts/work/_temp --filter TestCategory=DwSql --no-build --configuration Release --collect XPlat Code coverage 2026-03-09T00:23:19.7252855Z Test run for /home/vsts/work/1/s/src/out/tests/net8.0/Cli.Tests.dll (.NETCoreApp,Version=v8.0) 2026-03-09T00:23:19.7921806Z VSTest version 17.11.1 (x64) 2026-03-09T00:23:19.7999748Z 2026-03-09T00:23:19.9058098Z Starting test execution, please wait... 2026-03-09T00:23:19.9364251Z A total of 1 test files matched the specified pattern. 2026-03-09T00:23:43.7499117Z No test matches the given testcase filter `TestCategory=DwSql` in /home/vsts/work/1/s/src/out/tests/net8.0/Cli.Tests.dll 2026-03-09T00:23:45.4912106Z Results File: /home/vsts/work/_temp/_runnervmzqwse_2026-03-09_00_23_45.trx 2026-03-09T00:23:45.4917389Z 2026-03-09T00:23:45.6946917Z 2026-03-09T00:23:45.6954789Z Attachments: 2026-03-09T00:23:45.6956533Z /home/vsts/work/_temp/087080a2-7102-46f5-b39d-f2d7d99fdf94/coverage.cobertura.xml 2026-03-09T00:23:45.7567186Z 2026-03-09T00:23:45.7599974Z [command]/opt/hostedtoolcache/dotnet/dotnet test /home/vsts/work/1/s/src/Service.Tests/Azure.DataApiBuilder.Service.Tests.csproj --logger trx --results-directory /home/vsts/work/_temp --filter TestCategory=DwSql --no-build --configuration Release --collect XPlat Code coverage 2026-03-09T00:23:46.4833382Z Test run for /home/vsts/work/1/s/src/out/tests/net8.0/Azure.DataApiBuilder.Service.Tests.dll (.NETCoreApp,Version=v8.0) 2026-03-09T00:23:46.5406497Z VSTest version 17.11.1 (x64) 2026-03-09T00:23:46.5463727Z 2026-03-09T00:23:46.6306618Z Starting test execution, please wait... 2026-03-09T00:23:46.6611114Z A total of 1 test files matched the specified pattern. 2026-03-09T00:25:25.3983611Z Failed FindStoredProcedureWithNonexistentParameter [945 ms] 2026-03-09T00:25:25.3984428Z Error Message: 2026-03-09T00:25:25.3984920Z Test method Azure.DataApiBuilder.Service.Tests.SqlTests.RestApiTests.Find.DwSqlFindApiTests.FindStoredProcedureWithNonexistentParameter threw exception: 2026-03-09T00:25:25.3985768Z System.Text.Json.JsonReaderException: 'Y' is an invalid escapable character within a JSON string. The string should be correctly escaped. LineNumber: 0 | BytePositionInLine: 1022. 2026-03-09T00:25:25.3986386Z Stack Trace: 2026-03-09T00:25:25.3986834Z at System.Text.Json.ThrowHelper.ThrowJsonReaderException(Utf8JsonReader& json, ExceptionResource resource, Byte nextByte, ReadOnlySpan`1 bytes) 2026-03-09T00:25:25.3987525Z at System.Text.Json.Utf8JsonReader.ConsumeStringAndValidate(ReadOnlySpan`1 data, Int32 idx) 2026-03-09T00:25:25.3987989Z at System.Text.Json.Utf8JsonReader.ConsumeString() 2026-03-09T00:25:25.3999816Z at System.Text.Json.Utf8JsonReader.ConsumeValue(Byte marker) 2026-03-09T00:25:25.4000296Z at System.Text.Json.Utf8JsonReader.ReadSingleSegment() 2026-03-09T00:25:25.4000791Z at System.Text.Json.JsonDocument.Parse(ReadOnlySpan`1 utf8JsonSpan, JsonReaderOptions readerOptions, MetadataDb& database, StackRowStack& stack) 2026-03-09T00:25:25.4002140Z at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 utf8Json, JsonReaderOptions readerOptions, Byte[] extraRentedArrayPoolBytes, PooledByteBufferWriter extraPooledByteBufferWriter, Boolean allowDuplicateProperties) 2026-03-09T00:25:25.4002783Z at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 json, JsonDocumentOptions options) 2026-03-09T00:25:25.4003233Z at System.Text.Json.JsonDocument.Parse(String json, JsonDocumentOptions options) 2026-03-09T00:25:25.4004022Z at Azure.DataApiBuilder.Service.Tests.SqlTests.SqlTestHelper.VerifyResultAsync(String expected, HttpRequestMessage request, HttpResponseMessage response, Boolean exceptionExpected, HttpMethod httpMethod, String expectedLocationHeader, Int32 verifyNumRecords, Boolean isExpectedErrorMsgSubstr) in /home/vsts/work/1/s/src/Service.Tests/SqlTests/SqlTestHelper.cs:line 461 2026-03-09T00:25:25.4005487Z at Azure.DataApiBuilder.Service.Tests.SqlTests.SqlTestBase.SetupAndRunRestApiTest(String primaryKeyRoute, String queryString, String entityNameOrPath, String sqlQuery, EntityActionOperation operationType, String restPath, IHeaderDictionary headers, String requestBody, Boolean exceptionExpected, String expectedErrorMessage, HttpStatusCode expectedStatusCode, Nullable`1 restHttpVerb, String expectedSubStatusCode, String expectedLocationHeader, String expectedAfterQueryString, Boolean paginated, Int32 verifyNumRecords, Boolean expectJson, Boolean isExpectedErrorMsgSubstr, String clientRoleHeader) in /home/vsts/work/1/s/src/Service.Tests/SqlTests/SqlTestBase.cs:line 603 2026-03-09T00:25:25.4006801Z at Azure.DataApiBuilder.Service.Tests.SqlTests.RestApiTests.Find.FindApiTestBase.FindStoredProcedureWithNonexistentParameter() in /home/vsts/work/1/s/src/Service.Tests/SqlTests/RestApiTests/Find/FindApiTestBase.cs:line 1555 2026-03-09T00:25:25.4007164Z 2026-03-09T00:25:25.4007468Z Standard Output Messages: 2026-03-09T00:25:25.4007879Z dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0] 2026-03-09T00:25:25.4008384Z ffd2d6e6-832e-4b93-a5f5-32bea28e3ed1 AuthN state: Anonymous. Role: Anonymous. Scheme: AppServiceAuthentication 2026-03-09T00:25:25.4008830Z dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] 2026-03-09T00:25:25.4009438Z ffd2d6e6-832e-4b93-a5f5-32bea28e3ed1 Executing query: EXECUTE [dbo].[get_books] 2026-03-09T00:25:25.4009627Z 2026-03-09T00:25:25.4009734Z 2026-03-09T00:26:59.6296091Z Skipped TestConfigTakesPrecedenceForRelationshipFieldsOverDB 2026-03-09T00:27:29.5560360Z Skipped TestDbPolicyForCreateOperationReferencingFieldAbsentInRequest 2026-03-09T00:27:29.5572803Z Skipped TestTryInsertMutationForVariableNotNullDefault 2026-03-09T00:27:29.5573246Z Skipped TestParallelInsertMutationPKNonAutoGenerated 2026-03-09T00:27:29.5573641Z Skipped TestParallelInsertMutationPKAutoGenerated 2026-03-09T00:27:29.6351752Z Results File: /home/vsts/work/_temp/_runnervmzqwse_2026-03-09_00_24_05.trx 2026-03-09T00:27:29.6357980Z 2026-03-09T00:27:29.6406871Z Failed! - Failed: 1, Passed: 281, Skipped: 5, Total: 287, Duration: 3 m 29 s - Azure.DataApiBuilder.Service.Tests.dll (net8.0) 2026-03-09T00:27:29.8488386Z 2026-03-09T00:27:29.8494712Z Attachments: 2026-03-09T00:27:29.8496504Z /home/vsts/work/_temp/2475fcdb-cf97-406c-81c5-206f64c9f00c/coverage.cobertura.xml 2026-03-09T00:27:29.9114195Z 2026-03-09T00:27:29.9167285Z ##[error]Error: The process '/opt/hostedtoolcache/dotnet/dotnet' failed with exit code 1 2026-03-09T00:27:31.1615001Z Result Attachments will be stored in LogStore 2026-03-09T00:27:31.1981081Z Run Attachments will be stored in LogStore 2026-03-09T00:27:31.3923593Z No Result Found to Publish '/home/vsts/work/_temp/_runnervmzqwse_2026-03-09_00_23_45.trx'. 2026-03-09T00:27:31.4073552Z ##[warning].NET 5 has some compatibility issues with older Nuget versions(<=5.7), so if you are using an older Nuget version(and not dotnet cli) to restore, then the dotnet cli commands (e.g. dotnet build) which rely on such restored packages might fail. To mitigate such error, you can either: (1) - Use dotnet cli to restore, (2) - Use Nuget version 5.8 to restore, (3) - Use global.json using an older sdk version(<=3) to build 2026-03-09T00:27:31.4075840Z Info: Azure Pipelines hosted agents have been updated and now contain .Net 5.x SDK/Runtime along with the older .Net Core version which are currently lts. Unless you have locked down a SDK version for your project(s), 5.x SDK might be picked up which might have breaking behavior as compared to previous versions. You can learn more about the breaking changes here: https://docs.microsoft.com/en-us/dotnet/core/tools/ and https://docs.microsoft.com/en-us/dotnet/core/compatibility/ . To learn about more such changes and troubleshoot, refer here: https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/build/dotnet-core-cli?view=azure-devops#troubleshooting 2026-03-09T00:27:31.4077830Z ##[error]Dotnet command failed with non-zero exit code on the following projects : [ '/home/vsts/work/1/s/src/Service.Tests/Azure.DataApiBuilder.Service.Tests.csproj' ] 2026-03-09T00:27:31.4093456Z ##[section]Async Command Start: Publish test results 2026-03-09T00:27:31.5649803Z Publishing test results to test run '53238'. 2026-03-09T00:27:31.5661688Z TestResults To Publish 287, Test run id:53238 2026-03-09T00:27:31.5684363Z Test results publishing 287, remaining: 0. Test run id: 53238 2026-03-09T00:27:32.8640173Z Published Test Run : https://dev.azure.com/sqldab/Data%20API%20builder%20Dependency%20Packages/_TestManagement/Runs?runId=53238&_a=runCharts 2026-03-09T00:27:33.0961716Z Flaky failed test results are opted out of pass percentage 2026-03-09T00:27:33.2034488Z ##[section]Async Command End: Publish test results 2026-03-09T00:27:33.2035706Z ##[section]Finishing: Run DwSql Integration Tests