2026-03-08T05:44:14.0463997Z ##[section]Starting: Run DwSql Integration Tests
2026-03-08T05:44:14.0477673Z ==============================================================================
2026-03-08T05:44:14.0477868Z Task         : .NET Core
2026-03-08T05:44:14.0477982Z Description  : Build, test, package, or publish a dotnet application, or run a custom dotnet command
2026-03-08T05:44:14.0479497Z Version      : 2.269.0
2026-03-08T05:44:14.0479636Z Author       : Microsoft Corporation
2026-03-08T05:44:14.0479763Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/build/dotnet-core-cli
2026-03-08T05:44:14.0479932Z ==============================================================================
2026-03-08T05:44:14.4039510Z [command]C:\Windows\system32\chcp.com 65001
2026-03-08T05:44:14.4153346Z Active code page: 65001
2026-03-08T05:44:14.4182010Z 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-08T05:44:15.4053371Z [command]C:\hostedtoolcache\windows\dotnet\dotnet.exe test D:\a\1\s\src\Cli.Tests\Cli.Tests.csproj --logger trx --results-directory D:\a\_temp --filter TestCategory=DwSql --no-build --configuration Release --collect "XPlat Code coverage"
2026-03-08T05:44:16.1381432Z Test run for D:\a\1\s\src\out\tests\net8.0\Cli.Tests.dll (.NETCoreApp,Version=v8.0)
2026-03-08T05:44:16.2601623Z VSTest version 17.11.1 (x64)
2026-03-08T05:44:16.2642519Z 
2026-03-08T05:44:16.4460856Z Starting test execution, please wait...
2026-03-08T05:44:16.4987481Z A total of 1 test files matched the specified pattern.
2026-03-08T05:44:43.0119652Z No test matches the given testcase filter `TestCategory=DwSql` in D:\a\1\s\src\out\tests\net8.0\Cli.Tests.dll
2026-03-08T05:44:44.7379147Z Results File: D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-08_05_44_44.trx
2026-03-08T05:44:44.7379844Z 
2026-03-08T05:44:44.9581110Z 
2026-03-08T05:44:44.9594928Z Attachments:
2026-03-08T05:44:44.9600387Z   D:\a\_temp\416c4414-deca-45f8-9c8b-23ef9fec0c9f\coverage.cobertura.xml
2026-03-08T05:44:45.0228423Z 
2026-03-08T05:44:45.0344886Z [command]C:\hostedtoolcache\windows\dotnet\dotnet.exe test D:\a\1\s\src\Service.Tests\Azure.DataApiBuilder.Service.Tests.csproj --logger trx --results-directory D:\a\_temp --filter TestCategory=DwSql --no-build --configuration Release --collect "XPlat Code coverage"
2026-03-08T05:44:45.7860813Z Test run for D:\a\1\s\src\out\tests\net8.0\Azure.DataApiBuilder.Service.Tests.dll (.NETCoreApp,Version=v8.0)
2026-03-08T05:44:45.8568203Z VSTest version 17.11.1 (x64)
2026-03-08T05:44:45.8627666Z 
2026-03-08T05:44:45.9576398Z Starting test execution, please wait...
2026-03-08T05:44:45.9965998Z A total of 1 test files matched the specified pattern.
2026-03-08T05:45:35.6811986Z   Failed FindTestsWithFilterQueryStringOneOpFilter [824 ms]
2026-03-08T05:45:35.6816105Z   Error Message:
2026-03-08T05:45:35.6816596Z    Assert.IsTrue failed. 
2026-03-08T05:45:35.6816876Z Expected:<{
2026-03-08T05:45:35.6817119Z   "value": [
2026-03-08T05:45:35.6817370Z     {
2026-03-08T05:45:35.6817600Z       "id": 5,
2026-03-08T05:45:35.6817858Z       "journalname": "Journal5",
2026-03-08T05:45:35.6818104Z       "color": null,
2026-03-08T05:45:35.6818393Z       "ownername": "Abhishek"
2026-03-08T05:45:35.6818661Z     }
2026-03-08T05:45:35.6818889Z   ]
2026-03-08T05:45:35.6819172Z }>
2026-03-08T05:45:35.6819673Z Actual:<{
2026-03-08T05:45:35.6819922Z   "error": {
2026-03-08T05:45:35.6820202Z     "code": "AuthorizationCheckFailed",
2026-03-08T05:45:35.6820600Z     "message": "Authorization Failure: Access Not Allowed.",
2026-03-08T05:45:35.6820913Z     "status": 403
2026-03-08T05:45:35.6821159Z   }
2026-03-08T05:45:35.6821398Z }>
2026-03-08T05:45:35.6821649Z   Stack Trace:
2026-03-08T05:45:35.6822144Z      at Azure.DataApiBuilder.Service.Tests.SqlTests.SqlTestHelper.PerformTestEqualJsonStrings(String expected, String actual) in D:\a\1\s\src\Service.Tests\SqlTests\SqlTestHelper.cs:line 180
2026-03-08T05:45:35.6824530Z    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 D:\a\1\s\src\Service.Tests\SqlTests\SqlTestHelper.cs:line 451
2026-03-08T05:45:35.6826311Z    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 D:\a\1\s\src\Service.Tests\SqlTests\SqlTestBase.cs:line 603
2026-03-08T05:45:35.6827623Z    at Azure.DataApiBuilder.Service.Tests.SqlTests.RestApiTests.Find.FindApiTestBase.FindTestsWithFilterQueryStringOneOpFilter() in D:\a\1\s\src\Service.Tests\SqlTests\RestApiTests\Find\FindApiTestBase.cs:line 584
2026-03-08T05:45:35.6827988Z 
2026-03-08T05:45:35.6828265Z   Standard Output Messages:
2026-03-08T05:45:35.6828666Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6829155Z        143da026-dff0-41d9-84eb-417ed7730d16 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6829591Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6830588Z        143da026-dff0-41d9-84eb-417ed7730d16 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] = @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6831601Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6832094Z        9d66915c-d1b7-4c67-84a6-8f065c977e56 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6832543Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6833540Z        9d66915c-d1b7-4c67-84a6-8f065c977e56 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE (@param0 = [id]) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6834536Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6835206Z        411922ab-8d76-4fa2-8dfa-7006724890b4 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6835611Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6836613Z        411922ab-8d76-4fa2-8dfa-7006724890b4 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] > @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6838219Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6838716Z        9db4eda3-8638-4b55-ab11-a53c2bf15252 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6839155Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6840140Z        9db4eda3-8638-4b55-ab11-a53c2bf15252 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] >= @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6841212Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6841689Z        92acc9e9-78b5-4551-bbd6-d8a889b2931d AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6842088Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6843038Z        92acc9e9-78b5-4551-bbd6-d8a889b2931d Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] < @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6844134Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6844628Z        bbf542a7-a964-44df-891e-e0255db7a8ce AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6845071Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6846407Z        bbf542a7-a964-44df-891e-e0255db7a8ce Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] <= @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6847471Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6847967Z        8356ce20-900b-430b-ba78-5001bbd7d3c4 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6848554Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6849551Z        8356ce20-900b-430b-ba78-5001bbd7d3c4 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([id] != @param0) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6850690Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6851209Z        f9650aa8-6837-4e6d-ac0c-8090ec74ace8 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6851638Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6852627Z        f9650aa8-6837-4e6d-ac0c-8090ec74ace8 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE (NOT ([id] < @param0) ) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6853682Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6854165Z        9c0561d8-477d-4b90-86c9-1d9d0885a322 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6854616Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6855597Z        9c0561d8-477d-4b90-86c9-1d9d0885a322 Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE (NOT ([title] IS NULL) ) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6856680Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6857167Z        66556de4-9fed-4361-ba62-e9ab71094abc AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6857608Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:45:35.6858604Z        66556de4-9fed-4361-ba62-e9ab71094abc Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"title":' + ISNULL('"'+STRING_ESCAPE([title],'json')+'"','null')+','+N'"publisher_id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [publisher_id]),'json'),'null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_books].[id] AS [id], [dbo_books].[title] AS [title], [dbo_books].[publisher_id] AS [publisher_id]  FROM [dbo].[books] AS [dbo_books] WHERE ([title] IS NOT NULL) ORDER BY [dbo_books].[id] ASC) AS [dbo_books]
2026-03-08T05:45:35.6859683Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:45:35.6860174Z        2ddb0843-c0e9-4801-a9eb-b3af43d11183 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:45:35.6860582Z 
2026-03-08T05:45:35.6860693Z 
2026-03-08T05:46:05.9504419Z   Failed FindTestOnTableWithDatabasePolicy [488 ms]
2026-03-08T05:46:05.9527223Z   Error Message:
2026-03-08T05:46:05.9549143Z    Assert.IsTrue failed. 
2026-03-08T05:46:05.9561964Z Expected:<{
2026-03-08T05:46:05.9562605Z   "value": [
2026-03-08T05:46:05.9563152Z     {
2026-03-08T05:46:05.9564247Z       "id": 1156,
2026-03-08T05:46:05.9564974Z       "name": "The First Publisher"
2026-03-08T05:46:05.9565920Z     },
2026-03-08T05:46:05.9566463Z     {
2026-03-08T05:46:05.9567008Z       "id": 1940,
2026-03-08T05:46:05.9567578Z       "name": "Policy Publisher 01"
2026-03-08T05:46:05.9568134Z     },
2026-03-08T05:46:05.9568656Z     {
2026-03-08T05:46:05.9569197Z       "id": 1941,
2026-03-08T05:46:05.9569762Z       "name": "Policy Publisher 02"
2026-03-08T05:46:05.9570316Z     },
2026-03-08T05:46:05.9570855Z     {
2026-03-08T05:46:05.9571451Z       "id": 2323,
2026-03-08T05:46:05.9572023Z       "name": "TBD Publishing One"
2026-03-08T05:46:05.9572629Z     },
2026-03-08T05:46:05.9573151Z     {
2026-03-08T05:46:05.9573689Z       "id": 2324,
2026-03-08T05:46:05.9574280Z       "name": "TBD Publishing Two Ltd"
2026-03-08T05:46:05.9574843Z     },
2026-03-08T05:46:05.9575392Z     {
2026-03-08T05:46:05.9575925Z       "id": 2345,
2026-03-08T05:46:05.9576577Z       "name": "Small Town Publisher"
2026-03-08T05:46:05.9577512Z     }
2026-03-08T05:46:05.9578135Z   ]
2026-03-08T05:46:05.9578683Z }>
2026-03-08T05:46:05.9579185Z Actual:<{
2026-03-08T05:46:05.9579692Z   "value": [
2026-03-08T05:46:05.9580141Z     {
2026-03-08T05:46:05.9580586Z       "id": 1156,
2026-03-08T05:46:05.9581052Z       "name": "The First Publisher"
2026-03-08T05:46:05.9581517Z     },
2026-03-08T05:46:05.9581951Z     {
2026-03-08T05:46:05.9582389Z       "id": 1234,
2026-03-08T05:46:05.9582864Z       "name": "Big Company"
2026-03-08T05:46:05.9583305Z     },
2026-03-08T05:46:05.9583739Z     {
2026-03-08T05:46:05.9584171Z       "id": 1940,
2026-03-08T05:46:05.9584643Z       "name": "Policy Publisher 01"
2026-03-08T05:46:05.9585099Z     },
2026-03-08T05:46:05.9585521Z     {
2026-03-08T05:46:05.9585972Z       "id": 1941,
2026-03-08T05:46:05.9586439Z       "name": "Policy Publisher 02"
2026-03-08T05:46:05.9586879Z     },
2026-03-08T05:46:05.9587304Z     {
2026-03-08T05:46:05.9587737Z       "id": 2323,
2026-03-08T05:46:05.9588209Z       "name": "TBD Publishing One"
2026-03-08T05:46:05.9588665Z     },
2026-03-08T05:46:05.9589100Z     {
2026-03-08T05:46:05.9589547Z       "id": 2324,
2026-03-08T05:46:05.9590013Z       "name": "TBD Publishing Two Ltd"
2026-03-08T05:46:05.9590555Z     },
2026-03-08T05:46:05.9590990Z     {
2026-03-08T05:46:05.9591432Z       "id": 2345,
2026-03-08T05:46:05.9591902Z       "name": "Small Town Publisher"
2026-03-08T05:46:05.9592355Z     }
2026-03-08T05:46:05.9592784Z   ]
2026-03-08T05:46:05.9593207Z }>
2026-03-08T05:46:05.9593687Z   Stack Trace:
2026-03-08T05:46:05.9594361Z      at Azure.DataApiBuilder.Service.Tests.SqlTests.SqlTestHelper.PerformTestEqualJsonStrings(String expected, String actual) in D:\a\1\s\src\Service.Tests\SqlTests\SqlTestHelper.cs:line 180
2026-03-08T05:46:05.9595456Z    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 D:\a\1\s\src\Service.Tests\SqlTests\SqlTestHelper.cs:line 451
2026-03-08T05:46:05.9597092Z    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 D:\a\1\s\src\Service.Tests\SqlTests\SqlTestBase.cs:line 603
2026-03-08T05:46:05.9599220Z    at Azure.DataApiBuilder.Service.Tests.SqlTests.RestApiTests.Find.FindApiTestBase.FindTestOnTableWithDatabasePolicy() in D:\a\1\s\src\Service.Tests\SqlTests\RestApiTests\Find\FindApiTestBase.cs:line 1413
2026-03-08T05:46:05.9599799Z 
2026-03-08T05:46:05.9601133Z   Standard Output Messages:
2026-03-08T05:46:05.9601725Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:46:05.9602419Z        d743f9be-b111-4257-9859-aa8294b8ba8e AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:46:05.9603057Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-08T05:46:05.9604092Z        d743f9be-b111-4257-9859-aa8294b8ba8e Executing query: SELECT COALESCE('['+STRING_AGG('{'+N'"id":' + ISNULL(STRING_ESCAPE(CONVERT(NVARCHAR(MAX), [id]),'json'),'null')+','+N'"name":' + ISNULL('"'+STRING_ESCAPE([name],'json')+'"','null')+'}',', ')+']','[]') FROM (SELECT TOP 101 [dbo_publishers].[id] AS [id], [dbo_publishers].[name] AS [name]  FROM [dbo].[publishers] AS [dbo_publishers] WHERE 1 = 1 ORDER BY [dbo_publishers].[id] ASC) AS [dbo_publishers]
2026-03-08T05:46:05.9604892Z 
2026-03-08T05:46:05.9605171Z 
2026-03-08T05:47:29.8647231Z   Skipped TestConfigTakesPrecedenceForRelationshipFieldsOverDB
2026-03-08T05:47:34.2806610Z   Failed InsertMutationFailingDatabasePolicy [627 ms]
2026-03-08T05:47:34.2832153Z   Error Message:
2026-03-08T05:47:34.2859289Z    Assert.IsTrue failed. Message "Could not insert row with given values." not found in error [{"message":"The current user is not authorized to access this resource.","locations":[{"line":3,"column":21}],"path":["createPublisher"],"extensions":{"code":"AUTH_NOT_AUTHENTICATED"}}]
2026-03-08T05:47:34.2939394Z   Stack Trace:
2026-03-08T05:47:34.3013285Z      at Azure.DataApiBuilder.Service.Tests.SqlTests.SqlTestHelper.TestForErrorInGraphQLResponse(String response, String message, String statusCode, String path) in D:\a\1\s\src\Service.Tests\SqlTests\SqlTestHelper.cs:line 194
2026-03-08T05:47:34.3059505Z    at Azure.DataApiBuilder.Service.Tests.SqlTests.GraphQLMutationTests.GraphQLMutationTestBase.InsertMutationFailingDatabasePolicy(String dbQuery, String errorMessage, String roleName, String graphQLMutationName, String graphQLMutationPayload) in D:\a\1\s\src\Service.Tests\SqlTests\GraphQLMutationTests\GraphQLMutationTestBase.cs:line 113
2026-03-08T05:47:34.3175589Z    at Azure.DataApiBuilder.Service.Tests.SqlTests.GraphQLMutationTests.DwSqlGraphQLMutationTests.InsertMutationFailingDatabasePolicy() in D:\a\1\s\src\Service.Tests\SqlTests\GraphQLMutationTests\DwSqlGraphQLMutationTests.cs:line 132
2026-03-08T05:47:34.3238316Z 
2026-03-08T05:47:34.3262654Z   Standard Output Messages:
2026-03-08T05:47:34.3277701Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:47:34.3278662Z        79499b61-8a3e-498f-886c-5b51fd59d4b4 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:47:34.3285645Z  fail: Azure.DataApiBuilder.Service.Startup[0]
2026-03-08T05:47:34.3286380Z        Error code: AUTH_NOT_AUTHENTICATED
2026-03-08T05:47:34.3287043Z Error message: The current user is not authorized to access this resource.
2026-03-08T05:47:34.3287886Z  GraphQL error: [{"message":"The current user is not authorized to access this resource.","locations":[{"line":3,"column":21}],"path":["createPublisher"],"extensions":{"code":"AUTH_NOT_AUTHENTICATED"}}]
2026-03-08T05:47:34.3288846Z  [{"message":"The current user is not authorized to access this resource.","locations":[{"line":3,"column":21}],"path":["createPublisher"],"extensions":{"code":"AUTH_NOT_AUTHENTICATED"}}]
2026-03-08T05:47:34.3289769Z  [{"message":"The current user is not authorized to access this resource.","locations":[{"line":3,"column":21}],"path":["createPublisher"],"extensions":{"code":"AUTH_NOT_AUTHENTICATED"}}]
2026-03-08T05:47:34.3313084Z 
2026-03-08T05:47:34.3313465Z 
2026-03-08T05:47:34.3314097Z   Failed InsertMutationWithDatabasePolicy [780 ms]
2026-03-08T05:47:34.3314714Z   Error Message:
2026-03-08T05:47:34.3315727Z    Assert.AreEqual failed. Expected:<1>. Actual:<0>. 
2026-03-08T05:47:34.3318692Z   Stack Trace:
2026-03-08T05:47:34.3319679Z      at Azure.DataApiBuilder.Service.Tests.SqlTests.GraphQLMutationTests.GraphQLMutationTestBase.InsertMutationWithDatabasePolicy(String dbQuery, String roleName, String graphQLMutationName, String graphQLMutationPayload) in D:\a\1\s\src\Service.Tests\SqlTests\GraphQLMutationTests\GraphQLMutationTestBase.cs:line 137
2026-03-08T05:47:34.3336252Z    at Azure.DataApiBuilder.Service.Tests.SqlTests.GraphQLMutationTests.DwSqlGraphQLMutationTests.InsertMutationWithDatabasePolicy() in D:\a\1\s\src\Service.Tests\SqlTests\GraphQLMutationTests\DwSqlGraphQLMutationTests.cs:line 165
2026-03-08T05:47:34.3337068Z 
2026-03-08T05:47:34.3337669Z   Standard Output Messages:
2026-03-08T05:47:34.3338361Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-08T05:47:34.3339147Z        92a3e5bd-d703-4f56-8616-e915bc953751 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-08T05:47:34.3339936Z  fail: Azure.DataApiBuilder.Service.Startup[0]
2026-03-08T05:47:34.3346835Z        Error code: AUTH_NOT_AUTHENTICATED
2026-03-08T05:47:34.3347922Z Error message: The current user is not authorized to access this resource.
2026-03-08T05:47:34.3348782Z  GraphQL error: [{"message":"The current user is not authorized to access this resource.","locations":[{"line":3,"column":21}],"path":["createPublisher"],"extensions":{"code":"AUTH_NOT_AUTHENTICATED"}}]
2026-03-08T05:47:34.3349294Z 
2026-03-08T05:47:34.3349598Z 
2026-03-08T05:47:51.9190032Z   Skipped TestDbPolicyForCreateOperationReferencingFieldAbsentInRequest
2026-03-08T05:47:51.9605980Z   Skipped TestTryInsertMutationForVariableNotNullDefault
2026-03-08T05:47:51.9686050Z   Skipped TestParallelInsertMutationPKNonAutoGenerated
2026-03-08T05:47:51.9770849Z   Skipped TestParallelInsertMutationPKAutoGenerated
2026-03-08T05:47:52.0381898Z Results File: D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-08_05_45_13.trx
2026-03-08T05:47:52.0394610Z 
2026-03-08T05:47:52.0444968Z Failed!  - Failed:     4, Passed:   278, Skipped:     5, Total:   287, Duration: 2 m 49 s - Azure.DataApiBuilder.Service.Tests.dll (net8.0)
2026-03-08T05:47:52.4476152Z 
2026-03-08T05:47:52.4507527Z Attachments:
2026-03-08T05:47:52.4517091Z   D:\a\_temp\0965eb57-9f40-44bc-871b-01f315a461b9\coverage.cobertura.xml
2026-03-08T05:47:52.5495760Z 
2026-03-08T05:47:52.5602539Z ##[error]Error: The process 'C:\hostedtoolcache\windows\dotnet\dotnet.exe' failed with exit code 1
2026-03-08T05:47:55.4015677Z Result Attachments will be stored in LogStore
2026-03-08T05:47:55.4672004Z Run Attachments will be stored in LogStore
2026-03-08T05:47:55.8536844Z No Result Found to Publish 'D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-08_05_44_44.trx'.
2026-03-08T05:47:55.8851354Z ##[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-08T05:47:55.8852405Z 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-08T05:47:55.8853560Z ##[error]Dotnet command failed with non-zero exit code on the following projects : [
  'D:\\a\\1\\s\\src\\Service.Tests\\Azure.DataApiBuilder.Service.Tests.csproj'
]
2026-03-08T05:47:55.8879956Z ##[section]Async Command Start: Publish test results
2026-03-08T05:47:56.1782043Z Publishing test results to test run '53170'.
2026-03-08T05:47:56.1792868Z TestResults To Publish 287, Test run id:53170
2026-03-08T05:47:56.1815251Z Test results publishing 287, remaining: 0. Test run id: 53170
2026-03-08T05:47:59.2522374Z Published Test Run : https://dev.azure.com/sqldab/Data%20API%20builder%20Dependency%20Packages/_TestManagement/Runs?runId=53170&_a=runCharts
2026-03-08T05:47:59.6731728Z Flaky failed test results are opted out of pass percentage
2026-03-08T05:47:59.7428529Z ##[section]Async Command End: Publish test results
2026-03-08T05:47:59.7430020Z ##[section]Finishing: Run DwSql Integration Tests