2026-03-07T19:33:27.8213100Z ##[section]Starting: Run DwSql Integration Tests
2026-03-07T19:33:27.8227012Z ==============================================================================
2026-03-07T19:33:27.8227226Z Task         : .NET Core
2026-03-07T19:33:27.8227342Z Description  : Build, test, package, or publish a dotnet application, or run a custom dotnet command
2026-03-07T19:33:27.8227548Z Version      : 2.269.0
2026-03-07T19:33:27.8227664Z Author       : Microsoft Corporation
2026-03-07T19:33:27.8227804Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/build/dotnet-core-cli
2026-03-07T19:33:27.8227987Z ==============================================================================
2026-03-07T19:33:28.5133184Z [command]C:\Windows\system32\chcp.com 65001
2026-03-07T19:33:28.5374538Z Active code page: 65001
2026-03-07T19:33:28.5424181Z 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-07T19:33:30.0425535Z [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-07T19:33:30.7978640Z Test run for D:\a\1\s\src\out\tests\net8.0\Cli.Tests.dll (.NETCoreApp,Version=v8.0)
2026-03-07T19:33:30.9016771Z VSTest version 17.11.1 (x64)
2026-03-07T19:33:30.9055756Z 
2026-03-07T19:33:31.0824586Z Starting test execution, please wait...
2026-03-07T19:33:31.1509150Z A total of 1 test files matched the specified pattern.
2026-03-07T19:33:57.5307015Z No test matches the given testcase filter `TestCategory=DwSql` in D:\a\1\s\src\out\tests\net8.0\Cli.Tests.dll
2026-03-07T19:33:59.4718190Z Results File: D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-07_19_33_59.trx
2026-03-07T19:33:59.4723066Z 
2026-03-07T19:34:00.7231480Z 
2026-03-07T19:34:00.7232196Z Attachments:
2026-03-07T19:34:00.7232548Z   D:\a\_temp\4ee838f5-915f-463c-95be-49d9ed863782\coverage.cobertura.xml
2026-03-07T19:34:00.7232735Z 
2026-03-07T19:34:00.7233259Z [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-07T19:34:00.7233906Z Test run for D:\a\1\s\src\out\tests\net8.0\Azure.DataApiBuilder.Service.Tests.dll (.NETCoreApp,Version=v8.0)
2026-03-07T19:34:00.7234284Z VSTest version 17.11.1 (x64)
2026-03-07T19:34:00.7234420Z 
2026-03-07T19:34:01.7459469Z Starting test execution, please wait...
2026-03-07T19:34:01.7460145Z A total of 1 test files matched the specified pattern.
2026-03-07T19:34:39.2510832Z   Failed FindTestsWithFilterQueryStringOneOpFilter [627 ms]
2026-03-07T19:34:39.2518939Z   Error Message:
2026-03-07T19:34:39.2536274Z    Assert.IsTrue failed. 
2026-03-07T19:34:39.2558511Z Expected:<{
2026-03-07T19:34:39.2581645Z   "value": [
2026-03-07T19:34:39.2605015Z     {
2026-03-07T19:34:39.2639667Z       "id": 5,
2026-03-07T19:34:39.2666465Z       "journalname": "Journal5",
2026-03-07T19:34:39.2688746Z       "color": null,
2026-03-07T19:34:39.2716186Z       "ownername": "Abhishek"
2026-03-07T19:34:39.2827276Z     }
2026-03-07T19:34:39.2838387Z   ]
2026-03-07T19:34:39.2856267Z }>
2026-03-07T19:34:39.2898675Z Actual:<{
2026-03-07T19:34:39.2903698Z   "error": {
2026-03-07T19:34:39.2904299Z     "code": "AuthorizationCheckFailed",
2026-03-07T19:34:39.2904858Z     "message": "Authorization Failure: Access Not Allowed.",
2026-03-07T19:34:39.2905385Z     "status": 403
2026-03-07T19:34:39.2905833Z   }
2026-03-07T19:34:39.2906347Z }>
2026-03-07T19:34:39.2906832Z   Stack Trace:
2026-03-07T19:34:39.2907539Z      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-07T19:34:39.2911232Z    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-07T19:34:39.2912924Z    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-07T19:34:39.2914423Z    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-07T19:34:39.2914976Z 
2026-03-07T19:34:39.2915472Z   Standard Output Messages:
2026-03-07T19:34:39.2916073Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2916772Z        37476725-0daa-4ee7-9b2f-06a0f0792137 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2917420Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2918867Z        37476725-0daa-4ee7-9b2f-06a0f0792137 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-07T19:34:39.2920151Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2920815Z        c36f4a7c-f6be-4796-be96-2cff4b276ff2 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2921392Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2922517Z        c36f4a7c-f6be-4796-be96-2cff4b276ff2 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-07T19:34:39.2923688Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2924333Z        7e4fb7dc-445a-49be-9b19-400fd09d596e AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2924921Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2928199Z        7e4fb7dc-445a-49be-9b19-400fd09d596e 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-07T19:34:39.2930591Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2931293Z        fb2976f2-3764-45f3-9427-448f9f8614d5 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2931878Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2932999Z        fb2976f2-3764-45f3-9427-448f9f8614d5 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-07T19:34:39.2934186Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2934821Z        0f131d6d-bd57-49bc-986d-f67f25e9ecc2 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2935403Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2936517Z        0f131d6d-bd57-49bc-986d-f67f25e9ecc2 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-07T19:34:39.2937963Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2938604Z        9f92f71d-0431-445a-b83c-155def5ebf98 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2939189Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2940323Z        9f92f71d-0431-445a-b83c-155def5ebf98 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-07T19:34:39.2941490Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2942125Z        a4357d24-8858-4bf3-82f5-08d6a3220a94 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2942705Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2944196Z        a4357d24-8858-4bf3-82f5-08d6a3220a94 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-07T19:34:39.2945775Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2946900Z        1b4b52f9-aefe-4ee7-bbc8-f709a32e69e9 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2947527Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2948664Z        1b4b52f9-aefe-4ee7-bbc8-f709a32e69e9 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-07T19:34:39.2949846Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2950502Z        0dbd6310-0958-4b1d-88f6-26c42de9718a AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2951076Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2952210Z        0dbd6310-0958-4b1d-88f6-26c42de9718a 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-07T19:34:39.2953578Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2954197Z        6ffec5d2-e939-4918-9120-84eabab322cf AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2954796Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:34:39.2955919Z        6ffec5d2-e939-4918-9120-84eabab322cf 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-07T19:34:39.2957086Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:34:39.2957714Z        d5e17b7c-9edc-4807-85d0-e64ace70a03c AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:34:39.2958058Z 
2026-03-07T19:34:39.2958263Z 
2026-03-07T19:35:03.3625508Z   Failed FindTestOnTableWithDatabasePolicy [539 ms]
2026-03-07T19:35:03.3657384Z   Error Message:
2026-03-07T19:35:03.3670636Z    Assert.IsTrue failed. 
2026-03-07T19:35:03.3673210Z Expected:<{
2026-03-07T19:35:03.3673869Z   "value": [
2026-03-07T19:35:03.3674488Z     {
2026-03-07T19:35:03.3675063Z       "id": 1156,
2026-03-07T19:35:03.3675686Z       "name": "The First Publisher"
2026-03-07T19:35:03.3676930Z     },
2026-03-07T19:35:03.3677485Z     {
2026-03-07T19:35:03.3678048Z       "id": 1940,
2026-03-07T19:35:03.3678642Z       "name": "Policy Publisher 01"
2026-03-07T19:35:03.3679244Z     },
2026-03-07T19:35:03.3679795Z     {
2026-03-07T19:35:03.3680823Z       "id": 1941,
2026-03-07T19:35:03.3681490Z       "name": "Policy Publisher 02"
2026-03-07T19:35:03.3682109Z     },
2026-03-07T19:35:03.3682696Z     {
2026-03-07T19:35:03.3683278Z       "id": 2323,
2026-03-07T19:35:03.3683866Z       "name": "TBD Publishing One"
2026-03-07T19:35:03.3685155Z     },
2026-03-07T19:35:03.3686593Z     {
2026-03-07T19:35:03.3687221Z       "id": 2324,
2026-03-07T19:35:03.3687821Z       "name": "TBD Publishing Two Ltd"
2026-03-07T19:35:03.3688466Z     },
2026-03-07T19:35:03.3689015Z     {
2026-03-07T19:35:03.3689575Z       "id": 2345,
2026-03-07T19:35:03.3690195Z       "name": "Small Town Publisher"
2026-03-07T19:35:03.3690775Z     }
2026-03-07T19:35:03.3691306Z   ]
2026-03-07T19:35:03.3691909Z }>
2026-03-07T19:35:03.3692465Z Actual:<{
2026-03-07T19:35:03.3693041Z   "value": [
2026-03-07T19:35:03.3693528Z     {
2026-03-07T19:35:03.3694000Z       "id": 1156,
2026-03-07T19:35:03.3694486Z       "name": "The First Publisher"
2026-03-07T19:35:03.3694972Z     },
2026-03-07T19:35:03.3695425Z     {
2026-03-07T19:35:03.3695897Z       "id": 1234,
2026-03-07T19:35:03.3696377Z       "name": "Big Company"
2026-03-07T19:35:03.3696929Z     },
2026-03-07T19:35:03.3697403Z     {
2026-03-07T19:35:03.3697872Z       "id": 1940,
2026-03-07T19:35:03.3698383Z       "name": "Policy Publisher 01"
2026-03-07T19:35:03.3698870Z     },
2026-03-07T19:35:03.3699327Z     {
2026-03-07T19:35:03.3699784Z       "id": 1941,
2026-03-07T19:35:03.3700277Z       "name": "Policy Publisher 02"
2026-03-07T19:35:03.3701255Z     },
2026-03-07T19:35:03.3702137Z     {
2026-03-07T19:35:03.3702614Z       "id": 2323,
2026-03-07T19:35:03.3703113Z       "name": "TBD Publishing One"
2026-03-07T19:35:03.3703589Z     },
2026-03-07T19:35:03.3704065Z     {
2026-03-07T19:35:03.3704540Z       "id": 2324,
2026-03-07T19:35:03.3705034Z       "name": "TBD Publishing Two Ltd"
2026-03-07T19:35:03.3705524Z     },
2026-03-07T19:35:03.3705965Z     {
2026-03-07T19:35:03.3706407Z       "id": 2345,
2026-03-07T19:35:03.3706907Z       "name": "Small Town Publisher"
2026-03-07T19:35:03.3707389Z     }
2026-03-07T19:35:03.3707829Z   ]
2026-03-07T19:35:03.3708283Z }>
2026-03-07T19:35:03.3708819Z   Stack Trace:
2026-03-07T19:35:03.3709533Z      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-07T19:35:03.3710671Z    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-07T19:35:03.3712339Z    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-07T19:35:03.3713839Z    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-07T19:35:03.3714420Z 
2026-03-07T19:35:03.3716112Z   Standard Output Messages:
2026-03-07T19:35:03.3716792Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:35:03.3717514Z        cab514f3-004e-4b9c-b640-98befafa652e AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:35:03.3719190Z  dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
2026-03-07T19:35:03.3720733Z        cab514f3-004e-4b9c-b640-98befafa652e 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-07T19:35:03.3721588Z 
2026-03-07T19:35:03.3721895Z 
2026-03-07T19:35:59.8452216Z   Skipped TestConfigTakesPrecedenceForRelationshipFieldsOverDB
2026-03-07T19:36:04.5686491Z   Failed InsertMutationFailingDatabasePolicy [521 ms]
2026-03-07T19:36:04.5686960Z   Error Message:
2026-03-07T19:36:04.5687516Z    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-07T19:36:04.5688347Z   Stack Trace:
2026-03-07T19:36:04.5688810Z      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-07T19:36:04.5690038Z    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-07T19:36:04.5691481Z    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-07T19:36:04.5692253Z 
2026-03-07T19:36:04.5699863Z   Standard Output Messages:
2026-03-07T19:36:04.5701015Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:36:04.5701703Z        34ad28d3-3499-4b69-92a7-c7711264e26b AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:36:04.5702323Z  fail: Azure.DataApiBuilder.Service.Startup[0]
2026-03-07T19:36:04.5702833Z        Error code: AUTH_NOT_AUTHENTICATED
2026-03-07T19:36:04.5703350Z Error message: The current user is not authorized to access this resource.
2026-03-07T19:36:04.5704054Z  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-07T19:36:04.5704842Z  [{"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-07T19:36:04.5705634Z  [{"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-07T19:36:04.5706079Z 
2026-03-07T19:36:04.5706318Z 
2026-03-07T19:36:06.0757498Z   Failed InsertMutationWithDatabasePolicy [505 ms]
2026-03-07T19:36:06.0761590Z   Error Message:
2026-03-07T19:36:06.0763176Z    Assert.AreEqual failed. Expected:<1>. Actual:<0>. 
2026-03-07T19:36:06.0764526Z   Stack Trace:
2026-03-07T19:36:06.0765817Z      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-07T19:36:06.0774995Z    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-07T19:36:06.0775755Z 
2026-03-07T19:36:06.0776297Z   Standard Output Messages:
2026-03-07T19:36:06.0776859Z  dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
2026-03-07T19:36:06.0777362Z        9e1a9608-ab31-4149-bbd0-0c4ce0b8de90 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
2026-03-07T19:36:06.0777829Z  fail: Azure.DataApiBuilder.Service.Startup[0]
2026-03-07T19:36:06.0778509Z        Error code: AUTH_NOT_AUTHENTICATED
2026-03-07T19:36:06.0778876Z Error message: The current user is not authorized to access this resource.
2026-03-07T19:36:06.0779386Z  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-07T19:36:06.0779695Z 
2026-03-07T19:36:06.0779799Z 
2026-03-07T19:36:18.4881255Z   Skipped TestDbPolicyForCreateOperationReferencingFieldAbsentInRequest
2026-03-07T19:36:18.4882155Z   Skipped TestTryInsertMutationForVariableNotNullDefault
2026-03-07T19:36:18.4882667Z   Skipped TestParallelInsertMutationPKNonAutoGenerated
2026-03-07T19:36:18.4883112Z   Skipped TestParallelInsertMutationPKAutoGenerated
2026-03-07T19:36:18.6269217Z Results File: D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-07_19_34_21.trx
2026-03-07T19:36:18.6273250Z 
2026-03-07T19:36:18.6345747Z Failed!  - Failed:     4, Passed:   278, Skipped:     5, Total:   287, Duration: 2 m 2 s - Azure.DataApiBuilder.Service.Tests.dll (net8.0)
2026-03-07T19:36:18.9400634Z 
2026-03-07T19:36:18.9412457Z Attachments:
2026-03-07T19:36:18.9430150Z   D:\a\_temp\29a49204-0f5d-4231-9b68-091cefacbd37\coverage.cobertura.xml
2026-03-07T19:36:19.0040693Z 
2026-03-07T19:36:19.0188112Z ##[error]Error: The process 'C:\hostedtoolcache\windows\dotnet\dotnet.exe' failed with exit code 1
2026-03-07T19:36:20.4118141Z Result Attachments will be stored in LogStore
2026-03-07T19:36:20.4501439Z Run Attachments will be stored in LogStore
2026-03-07T19:36:20.6815118Z No Result Found to Publish 'D:\a\_temp\VssAdministrator_runnervmzcrer_2026-03-07_19_33_59.trx'.
2026-03-07T19:36:20.7097308Z ##[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-07T19:36:20.7099637Z 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-07T19:36:20.7101527Z ##[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-07T19:36:20.7108751Z ##[section]Async Command Start: Publish test results
2026-03-07T19:36:20.8870383Z Publishing test results to test run '53124'.
2026-03-07T19:36:20.8879964Z TestResults To Publish 287, Test run id:53124
2026-03-07T19:36:20.8903992Z Test results publishing 287, remaining: 0. Test run id: 53124
2026-03-07T19:36:22.8157084Z Published Test Run : https://dev.azure.com/sqldab/Data%20API%20builder%20Dependency%20Packages/_TestManagement/Runs?runId=53124&_a=runCharts
2026-03-07T19:36:22.9596211Z Flaky failed test results are opted out of pass percentage
2026-03-07T19:36:23.0098507Z ##[section]Async Command End: Publish test results
2026-03-07T19:36:23.0099945Z ##[section]Finishing: Run DwSql Integration Tests