2024-06-27 09:40:39.117 +05:30 INF User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-3006700770-424185619-1745488364-794895919-4004696415\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 2024-06-27 09:40:39.424 +05:30 INF Application started. Press Ctrl+C to shut down. 2024-06-27 09:40:39.425 +05:30 INF Hosting environment: Production 2024-06-27 09:40:39.425 +05:30 INF Content root path: C:\inetpub\wwwroot\SangSecurityAPI 2024-06-27 09:40:39.438 +05:30 0441efaf-2fda-4bad-aa1d-87e2da968168 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/index.html - null null 2024-06-27 09:40:39.615 +05:30 0441efaf-2fda-4bad-aa1d-87e2da968168 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/index.html - 200 null text/html;charset=utf-8 178.1526ms 2024-06-27 09:40:40.898 +05:30 ec2e8977-e910-42f9-9871-4bb2974d1922 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/v1/swagger.json - null null 2024-06-27 09:40:41.210 +05:30 ec2e8977-e910-42f9-9871-4bb2974d1922 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/v1/swagger.json - 200 null application/json;charset=utf-8 311.8868ms 2024-06-27 09:41:17.511 +05:30 8f7c45bd-8f38-491a-bf19-dea06e63f563 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 86 2024-06-27 09:41:17.522 +05:30 8f7c45bd-8f38-491a-bf19-dea06e63f563 INF CORS policy execution successful. 2024-06-27 09:41:17.536 +05:30 8f7c45bd-8f38-491a-bf19-dea06e63f563 INF HTTP request: Path: /login/login QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Connection: keep-alive}, {Content-Length: 86}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "loginName": "PKTest", "password": "PKTest", "entityId": 7, "channelId": 2 } 2024-06-27 09:41:17.574 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 09:41:17.614 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Route matched with {action = "Login", controller = "Login"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Login(Sang.Security.Api.Models.APIRequest.LoginRequest) on controller Sang.Security.Api.Controllers.LoginController (Sang.Security.Api). 2024-06-27 09:41:18.066 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Database retrieved 2024-06-27 09:41:18.150 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Token generated 2024-06-27 09:41:18.152 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Token generated 2024-06-27 09:41:18.161 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Executing OkObjectResult, writing value of type '<>f__AnonymousType0`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Sang.Service.Common.Models.Tokens, Sang.Service.Common, Version=1.0.49.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-27 09:41:18.204 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 583.3085ms 2024-06-27 09:41:18.204 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 09:41:18.206 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 8f7c45bd-8f38-491a-bf19-dea06e63f563}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 837} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDYxNDc4LCJleHAiOjE3MTk0NjMyNzgsImlhdCI6MTcxOTQ2MTQ3OH0.Uzjqnsrd5JSnfGJAAIkkcutBlwHR1064WPLvzt6Qn_o","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDYxNDc4LCJleHAiOjE3MTk0NjUwNzgsImlhdCI6MTcxOTQ2MTQ3OH0.c4RYA0M3Acz6v4cCJqxl1pK88w9AeSAmdklWmjSCHu8"}} 2024-06-27 09:41:18.210 +05:30 efe45300-2ea1-4951-bcf6-6ba64b3f1756 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 837 application/json; charset=utf-8 699.5734ms 2024-06-27 10:31:12.877 +05:30 6b55a87b-a812-414d-923b-12d2b3b11cd7 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofilesummary?refreshFlag=false - null null 2024-06-27 10:31:12.911 +05:30 658f8e5e-d155-42b7-818d-c753f21c1891 INF Authorization failed. These requirements were not met: DenyAnonymousAuthorizationRequirement: Requires an authenticated user. 2024-06-27 10:31:12.918 +05:30 658f8e5e-d155-42b7-818d-c753f21c1891 INF AuthenticationScheme: Bearer was challenged. 2024-06-27 10:31:12.922 +05:30 658f8e5e-d155-42b7-818d-c753f21c1891 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofilesummary?refreshFlag=false - 401 null null 45.9763ms 2024-06-27 10:31:22.968 +05:30 076e52cd-8a5c-4a9a-a95b-63bb0fec026b INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 86 2024-06-27 10:31:22.971 +05:30 076e52cd-8a5c-4a9a-a95b-63bb0fec026b INF CORS policy execution successful. 2024-06-27 10:31:22.974 +05:30 076e52cd-8a5c-4a9a-a95b-63bb0fec026b INF HTTP request: Path: /login/login QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Connection: keep-alive}, {Content-Length: 86}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "loginName": "PKTest", "password": "PKTest", "entityId": 7, "channelId": 2 } 2024-06-27 10:31:22.976 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 10:31:22.979 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Route matched with {action = "Login", controller = "Login"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Login(Sang.Security.Api.Models.APIRequest.LoginRequest) on controller Sang.Security.Api.Controllers.LoginController (Sang.Security.Api). 2024-06-27 10:31:23.030 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Database retrieved 2024-06-27 10:31:23.062 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Token generated 2024-06-27 10:31:23.062 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Token generated 2024-06-27 10:31:23.063 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Executing OkObjectResult, writing value of type '<>f__AnonymousType0`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Sang.Service.Common.Models.Tokens, Sang.Service.Common, Version=1.0.49.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-27 10:31:23.065 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 84.8336ms 2024-06-27 10:31:23.065 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 10:31:23.066 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 076e52cd-8a5c-4a9a-a95b-63bb0fec026b}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 837} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDY0NDgzLCJleHAiOjE3MTk0NjYyODMsImlhdCI6MTcxOTQ2NDQ4M30.f-GcrFc8ZTp-NKjGDRjv8Xoe6NZv_qVoqGuUHN1He4E","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDY0NDgzLCJleHAiOjE3MTk0NjgwODMsImlhdCI6MTcxOTQ2NDQ4M30.-IrBpYU_-5xTaWO5x0ZdhAB0oOeDnIlXxvo_v6w9_70"}} 2024-06-27 10:31:23.067 +05:30 b8e5566e-fe72-4310-bab7-5aef75441e34 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 837 application/json; charset=utf-8 98.2641ms 2024-06-27 10:31:57.299 +05:30 717b712e-149c-4339-a5f9-d06134567aa9 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofilesummary?refreshFlag=false - null null 2024-06-27 10:31:57.391 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileSummary (Sang.Security.Api)' 2024-06-27 10:31:57.408 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Route matched with {action = "GetProfileSummary", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetProfileSummary(Boolean, Int32, Int32, System.String) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:31:57.560 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:31:57.566 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Executed action Sang.Security.Api.Controllers.ProfileController.GetProfileSummary (Sang.Security.Api) in 157.5168ms 2024-06-27 10:31:57.566 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileSummary (Sang.Security.Api)' 2024-06-27 10:31:57.567 +05:30 e9f578a4-45d7-48c5-a399-d34a34a97fb2 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofilesummary?refreshFlag=false - 200 686 application/json; charset=utf-8 268.0582ms 2024-06-27 10:32:16.037 +05:30 2ccfd99f-d308-4d6d-99c1-332fface0eec INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/checkprofilenameexistence?profileId=0&profileName=PK%20Test - null null 2024-06-27 10:32:16.043 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.CheckProfileNameExistence (Sang.Security.Api)' 2024-06-27 10:32:16.050 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Route matched with {action = "CheckProfileNameExistence", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] CheckProfileNameExistence(Int32, System.String) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:32:16.087 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:32:16.089 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Executed action Sang.Security.Api.Controllers.ProfileController.CheckProfileNameExistence (Sang.Security.Api) in 38.7784ms 2024-06-27 10:32:16.090 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.CheckProfileNameExistence (Sang.Security.Api)' 2024-06-27 10:32:16.090 +05:30 478259a5-22ce-4127-aaf3-5efe9417a0d3 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/checkprofilenameexistence?profileId=0&profileName=PK%20Test - 200 91 application/json; charset=utf-8 52.8537ms 2024-06-27 10:32:27.534 +05:30 58594936-913a-49de-ad13-9bd24d1499e6 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofiledetails?profileId=27 - null null 2024-06-27 10:32:27.537 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api)' 2024-06-27 10:32:27.544 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Route matched with {action = "GetProfileDetails", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetProfileDetails(Int32) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:32:27.603 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:32:27.605 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Executed action Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api) in 59.9794ms 2024-06-27 10:32:27.605 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api)' 2024-06-27 10:32:27.605 +05:30 d8769607-fd00-4c1e-a50f-c35dd3c1191d INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofiledetails?profileId=27 - 200 387 application/json; charset=utf-8 71.0292ms 2024-06-27 10:32:39.125 +05:30 6dfe71fe-4cbb-458e-9658-90275adb4754 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofiledetails?profileId=7 - null null 2024-06-27 10:32:39.128 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api)' 2024-06-27 10:32:39.129 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Route matched with {action = "GetProfileDetails", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetProfileDetails(Int32) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:32:39.160 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:32:39.163 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Executed action Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api) in 33.7282ms 2024-06-27 10:32:39.163 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetProfileDetails (Sang.Security.Api)' 2024-06-27 10:32:39.163 +05:30 d9e4f559-910b-477e-8a8d-f0a671613f66 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getprofiledetails?profileId=7 - 200 421 application/json; charset=utf-8 38.1006ms 2024-06-27 10:32:56.875 +05:30 90e741a4-d430-4d34-aaa7-eb735609df99 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getrolesinprofile?profileId=7 - null null 2024-06-27 10:32:56.878 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api)' 2024-06-27 10:32:56.887 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Route matched with {action = "GetRolesInProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetRolesInProfile(Int32) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:32:56.921 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:32:56.922 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Executed action Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api) in 35.1388ms 2024-06-27 10:32:56.923 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api)' 2024-06-27 10:32:56.923 +05:30 2a564576-eaee-4194-9ed6-5ba2125908c6 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getrolesinprofile?profileId=7 - 200 125 application/json; charset=utf-8 48.4242ms 2024-06-27 10:33:06.399 +05:30 e5394c75-9aa2-4a17-a68e-233ced3af784 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getrolesinprofile?profileId=8 - null null 2024-06-27 10:33:06.401 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api)' 2024-06-27 10:33:06.401 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Route matched with {action = "GetRolesInProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetRolesInProfile(Int32) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:33:06.415 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Executing NotFoundObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:33:06.417 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Executed action Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api) in 16.0296ms 2024-06-27 10:33:06.417 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetRolesInProfile (Sang.Security.Api)' 2024-06-27 10:33:06.418 +05:30 43f996fc-a6c8-488b-a98e-296204b2c2ab INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getrolesinprofile?profileId=8 - 404 104 application/json; charset=utf-8 19.121ms 2024-06-27 10:34:04.814 +05:30 f1d35a98-dcde-43d7-8eaa-0387569c6f83 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getactiveprofiles - null null 2024-06-27 10:34:04.823 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.GetActiveProfile (Sang.Security.Api)' 2024-06-27 10:34:04.836 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Route matched with {action = "GetActiveProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetActiveProfile() on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 10:34:04.866 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-27 10:34:04.867 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Executed action Sang.Security.Api.Controllers.ProfileController.GetActiveProfile (Sang.Security.Api) in 31.0549ms 2024-06-27 10:34:04.868 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.GetActiveProfile (Sang.Security.Api)' 2024-06-27 10:34:04.868 +05:30 8d1fdb43-0625-4030-aafd-85fcad71952b INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/profile/getactiveprofiles - 200 333 application/json; charset=utf-8 54.1472ms 2024-06-27 12:10:43.658 +05:30 774164f4-bc4e-4d5a-a504-54b54fe105b0 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 173 2024-06-27 12:10:43.679 +05:30 774164f4-bc4e-4d5a-a504-54b54fe105b0 INF Failed to validate the token.Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 5:31:23 AM', Current time (UTC): '6/27/2024 6:40:43 AM'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateTokenPayloadAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateJWSAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) 2024-06-27 12:10:43.704 +05:30 774164f4-bc4e-4d5a-a504-54b54fe105b0 INF Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 5:31:23 AM', Current time (UTC): '6/27/2024 6:40:43 AM'. 2024-06-27 12:10:43.705 +05:30 774164f4-bc4e-4d5a-a504-54b54fe105b0 INF CORS policy execution successful. 2024-06-27 12:10:43.706 +05:30 774164f4-bc4e-4d5a-a504-54b54fe105b0 INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDY0NDgzLCJleHAiOjE3MTk0NjYyODMsImlhdCI6MTcxOTQ2NDQ4M30.f-GcrFc8ZTp-NKjGDRjv8Xoe6NZv_qVoqGuUHN1He4E}, {Connection: keep-alive}, {Content-Length: 173}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "id": 0, "name": "PK", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 0, "actionId": 0 } ], "parentId": null, "remarks": "" } 2024-06-27 12:10:43.711 +05:30 a4394e57-12cc-4545-8024-f22452b26396 INF Authorization failed. These requirements were not met: DenyAnonymousAuthorizationRequirement: Requires an authenticated user. 2024-06-27 12:10:43.715 +05:30 a4394e57-12cc-4545-8024-f22452b26396 INF AuthenticationScheme: Bearer was challenged. 2024-06-27 12:10:43.716 +05:30 a4394e57-12cc-4545-8024-f22452b26396 INF HTTP Response: StatusCode: 401 Headers: {X-Correlation-Id: 774164f4-bc4e-4d5a-a504-54b54fe105b0}, {X-Token-Expired: true}, {WWW-Authenticate: Bearer error="invalid_token", error_description="The token expired at '06/27/2024 05:31:23'"} Body: 2024-06-27 12:10:43.718 +05:30 a4394e57-12cc-4545-8024-f22452b26396 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 401 null null 60.9696ms 2024-06-27 12:10:56.129 +05:30 14f871bb-ca51-4ba4-a29d-1c73e2e40e29 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 86 2024-06-27 12:10:56.131 +05:30 14f871bb-ca51-4ba4-a29d-1c73e2e40e29 INF Failed to validate the token.Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 5:31:23 AM', Current time (UTC): '6/27/2024 6:40:56 AM'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateTokenPayloadAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateJWSAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) 2024-06-27 12:10:56.131 +05:30 14f871bb-ca51-4ba4-a29d-1c73e2e40e29 INF Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 5:31:23 AM', Current time (UTC): '6/27/2024 6:40:56 AM'. 2024-06-27 12:10:56.131 +05:30 14f871bb-ca51-4ba4-a29d-1c73e2e40e29 INF CORS policy execution successful. 2024-06-27 12:10:56.132 +05:30 14f871bb-ca51-4ba4-a29d-1c73e2e40e29 INF HTTP request: Path: /login/login QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDY0NDgzLCJleHAiOjE3MTk0NjYyODMsImlhdCI6MTcxOTQ2NDQ4M30.f-GcrFc8ZTp-NKjGDRjv8Xoe6NZv_qVoqGuUHN1He4E}, {Connection: keep-alive}, {Content-Length: 86}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "loginName": "PKTest", "password": "PKTest", "entityId": 7, "channelId": 2 } 2024-06-27 12:10:56.133 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 12:10:56.134 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Route matched with {action = "Login", controller = "Login"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Login(Sang.Security.Api.Models.APIRequest.LoginRequest) on controller Sang.Security.Api.Controllers.LoginController (Sang.Security.Api). 2024-06-27 12:10:56.226 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Database retrieved 2024-06-27 12:10:56.257 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Token generated 2024-06-27 12:10:56.258 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Token generated 2024-06-27 12:10:56.259 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Executing OkObjectResult, writing value of type '<>f__AnonymousType0`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Sang.Service.Common.Models.Tokens, Sang.Service.Common, Version=1.0.49.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-27 12:10:56.261 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 127.1522ms 2024-06-27 12:10:56.261 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 12:10:56.262 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 14f871bb-ca51-4ba4-a29d-1c73e2e40e29}, {X-Token-Expired: true}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 837} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDcwNDU2LCJleHAiOjE3MTk0NzIyNTYsImlhdCI6MTcxOTQ3MDQ1Nn0.6M_MxVNZAs00CN6Kqj9uJXjcWbkHLx3JXgCNXTHsDdE","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDcwNDU2LCJleHAiOjE3MTk0NzQwNTYsImlhdCI6MTcxOTQ3MDQ1Nn0.mcNH_3ZR2JzJnVyYhKPUPGw8RKwavItjiiNuh4xY_84"}} 2024-06-27 12:10:56.263 +05:30 91f83649-5114-4982-9d5e-54d278294507 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 837 application/json; charset=utf-8 133.1974ms 2024-06-27 12:12:12.741 +05:30 38c4933a-5889-4366-87a6-199b561afc40 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 173 2024-06-27 12:12:12.747 +05:30 38c4933a-5889-4366-87a6-199b561afc40 INF CORS policy execution successful. 2024-06-27 12:12:12.750 +05:30 38c4933a-5889-4366-87a6-199b561afc40 INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDcwNDU2LCJleHAiOjE3MTk0NzIyNTYsImlhdCI6MTcxOTQ3MDQ1Nn0.6M_MxVNZAs00CN6Kqj9uJXjcWbkHLx3JXgCNXTHsDdE}, {Connection: keep-alive}, {Content-Length: 173}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "id": 0, "name": "PK", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 0, "actionId": 0 } ], "parentId": null, "remarks": "" } 2024-06-27 12:12:12.752 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-27 12:12:12.771 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Route matched with {action = "UpsertProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] UpsertProfile(Sang.Security.Api.Models.APIRequest.ProfileRequest) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 12:12:12.963 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e ERR The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-27 12:12:13.007 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e ERR Database connection error: System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.ProfileRepository.<>c__DisplayClass11_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 209 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) ClientConnectionId:2064989b-d34f-4a70-8d4e-ada7b1b8f4ac Error Number:50000,State:1,Class:16 2024-06-27 12:12:13.009 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e ERR The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-27 12:12:13.013 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e ERR Upsert Failed System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.ProfileRepository.<>c__DisplayClass11_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 209 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) at Sang.Security.Api.Repositories.ProfileRepository.UpsertProfile(ProfileRequest profile) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 190 at Sang.Security.Api.Services.ProfileService.UpsertProfile(ProfileRequest profileDetails) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Services\ProfileService.cs:line 45 at Sang.Security.Api.Controllers.ProfileController.UpsertProfile(ProfileRequest profileDetails) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Controllers\ProfileController.cs:line 159 ClientConnectionId:2064989b-d34f-4a70-8d4e-ada7b1b8f4ac Error Number:50000,State:1,Class:16 2024-06-27 12:12:13.015 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 2024-06-27 12:12:13.049 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Executed action Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api) in 277.2809ms 2024-06-27 12:12:13.049 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-27 12:12:13.050 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF HTTP Response: StatusCode: 500 Headers: {X-Correlation-Id: 38c4933a-5889-4366-87a6-199b561afc40}, {Content-Type: application/problem+json; charset=utf-8}, {Content-Length: 533} Body: {"type":"https://tools.ietf.org/html/rfc9110#section-15.6.1","title":"An error occurred while processing your request.","status":500,"detail":"The INSERT statement conflicted with the FOREIGN KEY constraint \"FK__t_s_Profi__iMenu__2A164134\". The conflict occurred in database \"SS0001\", table \"dbo.t_c_Menu\", column 'iId'.\r\nTransaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.","traceId":"00-10f5c7534b28847d5854aed30e042d28-d923ceca3673eafb-00"} 2024-06-27 12:12:13.051 +05:30 3f83f006-e60a-4183-a8af-0ec697cf684e INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 500 533 application/problem+json; charset=utf-8 310.5871ms 2024-06-27 14:48:28.438 +05:30 7382d393-944b-47ac-bc46-1456c970088a INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 173 2024-06-27 14:48:28.446 +05:30 7382d393-944b-47ac-bc46-1456c970088a INF Failed to validate the token.Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 7:10:56 AM', Current time (UTC): '6/27/2024 9:18:28 AM'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateTokenPayloadAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateJWSAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) 2024-06-27 14:48:28.456 +05:30 7382d393-944b-47ac-bc46-1456c970088a INF Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 7:10:56 AM', Current time (UTC): '6/27/2024 9:18:28 AM'. 2024-06-27 14:48:28.457 +05:30 7382d393-944b-47ac-bc46-1456c970088a INF CORS policy execution successful. 2024-06-27 14:48:28.459 +05:30 7382d393-944b-47ac-bc46-1456c970088a INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDcwNDU2LCJleHAiOjE3MTk0NzIyNTYsImlhdCI6MTcxOTQ3MDQ1Nn0.6M_MxVNZAs00CN6Kqj9uJXjcWbkHLx3JXgCNXTHsDdE}, {Connection: keep-alive}, {Content-Length: 173}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "id": 0, "name": "PK", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 0, "actionId": 0 } ], "parentId": null, "remarks": "" } 2024-06-27 14:48:28.461 +05:30 e01b269e-3d31-440a-a916-676fd0190dda INF Authorization failed. These requirements were not met: DenyAnonymousAuthorizationRequirement: Requires an authenticated user. 2024-06-27 14:48:28.463 +05:30 e01b269e-3d31-440a-a916-676fd0190dda INF AuthenticationScheme: Bearer was challenged. 2024-06-27 14:48:28.463 +05:30 e01b269e-3d31-440a-a916-676fd0190dda INF HTTP Response: StatusCode: 401 Headers: {X-Correlation-Id: 7382d393-944b-47ac-bc46-1456c970088a}, {X-Token-Expired: true}, {WWW-Authenticate: Bearer error="invalid_token", error_description="The token expired at '06/27/2024 07:10:56'"} Body: 2024-06-27 14:48:28.465 +05:30 e01b269e-3d31-440a-a916-676fd0190dda INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 401 null null 27.7212ms 2024-06-27 14:48:47.773 +05:30 8a636529-ea7a-4b5c-a2d6-485221857b5f INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 86 2024-06-27 14:48:47.775 +05:30 8a636529-ea7a-4b5c-a2d6-485221857b5f INF Failed to validate the token.Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 7:10:56 AM', Current time (UTC): '6/27/2024 9:18:47 AM'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateTokenPayloadAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateJWSAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) 2024-06-27 14:48:47.776 +05:30 8a636529-ea7a-4b5c-a2d6-485221857b5f INF Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '6/27/2024 7:10:56 AM', Current time (UTC): '6/27/2024 9:18:47 AM'. 2024-06-27 14:48:47.776 +05:30 8a636529-ea7a-4b5c-a2d6-485221857b5f INF CORS policy execution successful. 2024-06-27 14:48:47.777 +05:30 8a636529-ea7a-4b5c-a2d6-485221857b5f INF HTTP request: Path: /login/login QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDcwNDU2LCJleHAiOjE3MTk0NzIyNTYsImlhdCI6MTcxOTQ3MDQ1Nn0.6M_MxVNZAs00CN6Kqj9uJXjcWbkHLx3JXgCNXTHsDdE}, {Connection: keep-alive}, {Content-Length: 86}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "loginName": "PKTest", "password": "PKTest", "entityId": 7, "channelId": 2 } 2024-06-27 14:48:47.777 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 14:48:47.778 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Route matched with {action = "Login", controller = "Login"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Login(Sang.Security.Api.Models.APIRequest.LoginRequest) on controller Sang.Security.Api.Controllers.LoginController (Sang.Security.Api). 2024-06-27 14:48:47.842 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Database retrieved 2024-06-27 14:48:47.871 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Token generated 2024-06-27 14:48:47.871 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Token generated 2024-06-27 14:48:47.872 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Executing OkObjectResult, writing value of type '<>f__AnonymousType0`2[[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[Sang.Service.Common.Models.Tokens, Sang.Service.Common, Version=1.0.49.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-27 14:48:47.873 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 94.2011ms 2024-06-27 14:48:47.873 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-27 14:48:47.873 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 8a636529-ea7a-4b5c-a2d6-485221857b5f}, {X-Token-Expired: true}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 837} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDc5OTI3LCJleHAiOjE3MTk0ODE3MjcsImlhdCI6MTcxOTQ3OTkyN30.Zl0R3gOfjnhOwFQBO-z8akTqey-UGQNcGgr5mGlbLCU","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDc5OTI3LCJleHAiOjE3MTk0ODM1MjcsImlhdCI6MTcxOTQ3OTkyN30.uruPSJf5Xd23JbBy0T3xwhqtBGP4ka48UzVJS366lDQ"}} 2024-06-27 14:48:47.874 +05:30 df222a81-4f97-47f9-b822-53144945fe95 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 837 application/json; charset=utf-8 101.271ms 2024-06-27 14:49:24.711 +05:30 a62544f3-1fd2-4d28-be67-18375b3f3956 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 173 2024-06-27 14:49:24.716 +05:30 a62544f3-1fd2-4d28-be67-18375b3f3956 INF CORS policy execution successful. 2024-06-27 14:49:24.718 +05:30 a62544f3-1fd2-4d28-be67-18375b3f3956 INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5NDc5OTI3LCJleHAiOjE3MTk0ODE3MjcsImlhdCI6MTcxOTQ3OTkyN30.Zl0R3gOfjnhOwFQBO-z8akTqey-UGQNcGgr5mGlbLCU}, {Connection: keep-alive}, {Content-Length: 173}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {Referer: http://103.120.178.195/SangSecurityAPI/swagger/index.html}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36}, {Origin: http://103.120.178.195} Host: 103.120.178.195 Body: { "id": 0, "name": "PK", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 0, "actionId": 0 } ], "parentId": null, "remarks": "" } 2024-06-27 14:49:24.720 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-27 14:49:24.721 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Route matched with {action = "UpsertProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] UpsertProfile(Sang.Security.Api.Models.APIRequest.ProfileRequest) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-27 14:49:24.844 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-27 14:49:24.848 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 ERR Database connection error: System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.ProfileRepository.<>c__DisplayClass11_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 209 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) ClientConnectionId:c3ac0e8f-fc69-4f0a-b8aa-72b09472d7cb Error Number:50000,State:1,Class:16 2024-06-27 14:49:24.848 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 ERR The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-27 14:49:24.850 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 ERR Upsert Failed System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__t_s_Profi__iMenu__2A164134". The conflict occurred in database "SS0001", table "dbo.t_c_Menu", column 'iId'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchOutput(SqlConnection connection, SqlTransaction transaction, String procedureName, SqlParameter[] parameters) at Sang.Security.Api.Repositories.ProfileRepository.<>c__DisplayClass11_0.<b__0>d.MoveNext() in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 209 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) at Sang.Security.Api.Repositories.ProfileRepository.UpsertProfile(ProfileRequest profile) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 190 at Sang.Security.Api.Services.ProfileService.UpsertProfile(ProfileRequest profileDetails) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Services\ProfileService.cs:line 45 at Sang.Security.Api.Controllers.ProfileController.UpsertProfile(ProfileRequest profileDetails) in C:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Controllers\ProfileController.cs:line 159 ClientConnectionId:c3ac0e8f-fc69-4f0a-b8aa-72b09472d7cb Error Number:50000,State:1,Class:16 2024-06-27 14:49:24.851 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 2024-06-27 14:49:24.852 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Executed action Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api) in 130.1173ms 2024-06-27 14:49:24.852 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-27 14:49:24.852 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF HTTP Response: StatusCode: 500 Headers: {X-Correlation-Id: a62544f3-1fd2-4d28-be67-18375b3f3956}, {Content-Type: application/problem+json; charset=utf-8}, {Content-Length: 533} Body: {"type":"https://tools.ietf.org/html/rfc9110#section-15.6.1","title":"An error occurred while processing your request.","status":500,"detail":"The INSERT statement conflicted with the FOREIGN KEY constraint \"FK__t_s_Profi__iMenu__2A164134\". The conflict occurred in database \"SS0001\", table \"dbo.t_c_Menu\", column 'iId'.\r\nTransaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.","traceId":"00-03dfe11b862d676e8b9c6566de364382-b62135e405b1cf26-00"} 2024-06-27 14:49:24.854 +05:30 61538775-dfb5-4d87-acce-1f0452f263e7 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 500 533 application/problem+json; charset=utf-8 143.3662ms