2024-06-24 14:22:33.412 +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-24 14:22:33.805 +05:30 INF Application started. Press Ctrl+C to shut down. 2024-06-24 14:22:33.807 +05:30 INF Hosting environment: Production 2024-06-24 14:22:33.808 +05:30 INF Content root path: C:\inetpub\wwwroot\SangSecurityAPI 2024-06-24 14:22:33.828 +05:30 0120e7e7-7c55-4ad7-a305-9e92484b6764 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/index.html - null null 2024-06-24 14:22:34.062 +05:30 0120e7e7-7c55-4ad7-a305-9e92484b6764 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/index.html - 200 null text/html;charset=utf-8 235.7933ms 2024-06-24 14:22:34.827 +05:30 0e392b1c-4b91-4956-b77e-9ce812e745ae INF Request starting HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/v1/swagger.json - null null 2024-06-24 14:22:35.105 +05:30 0e392b1c-4b91-4956-b77e-9ce812e745ae INF Request finished HTTP/1.1 GET http://103.120.178.195/SangSecurityAPI/swagger/v1/swagger.json - 200 null application/json;charset=utf-8 277.8479ms 2024-06-24 14:23:05.062 +05:30 15e4274c-5aeb-4144-bf04-577a02833cb3 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 86 2024-06-24 14:23:05.075 +05:30 15e4274c-5aeb-4144-bf04-577a02833cb3 INF CORS policy execution successful. 2024-06-24 14:23:05.093 +05:30 15e4274c-5aeb-4144-bf04-577a02833cb3 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-24 14:23:05.146 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-24 14:23:05.184 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d 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-24 14:23:05.802 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Database retrieved 2024-06-24 14:23:05.987 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Token generated 2024-06-24 14:23:05.990 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Token generated 2024-06-24 14:23:06.000 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d 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.45.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-24 14:23:06.055 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 861.8978ms 2024-06-24 14:23:06.061 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-24 14:23:06.064 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 15e4274c-5aeb-4144-bf04-577a02833cb3}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 837} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5MjE5MTg1LCJleHAiOjE3MTkyMjA5ODUsImlhdCI6MTcxOTIxOTE4NX0.f6asAI2tBMSd5H2oGQEIgqVPkURTgIt5cXDuA3Lg-Uw","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5MjE5MTg1LCJleHAiOjE3MTkyMjI3ODUsImlhdCI6MTcxOTIxOTE4NX0.NIjxCWMpfLTcncGObpTfenqSj0Mnz8YPFYkYBYn879c"}} 2024-06-24 14:23:06.072 +05:30 01dbe966-5bb8-4701-9a4a-086296b7af9d INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 837 application/json; charset=utf-8 1009.755ms 2024-06-24 14:24:31.924 +05:30 6b5e9a66-b568-42d7-b67b-a785ac31e473 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 185 2024-06-24 14:24:32.046 +05:30 6b5e9a66-b568-42d7-b67b-a785ac31e473 INF CORS policy execution successful. 2024-06-24 14:24:32.048 +05:30 6b5e9a66-b568-42d7-b67b-a785ac31e473 INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5MjE5MTg1LCJleHAiOjE3MTkyMjA5ODUsImlhdCI6MTcxOTIxOTE4NX0.f6asAI2tBMSd5H2oGQEIgqVPkURTgIt5cXDuA3Lg-Uw}, {Connection: keep-alive}, {Content-Length: 185}, {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 TestProfile", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 1, "actionId": 9 } ], "parentId": null, "remarks": "" } 2024-06-24 14:24:32.068 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-24 14:24:32.084 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 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-24 14:24:32.438 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF Executing ConflictObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-24 14:24:32.447 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF Executed action Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api) in 362.4712ms 2024-06-24 14:24:32.448 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-24 14:24:32.448 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF HTTP Response: StatusCode: 409 Headers: {X-Correlation-Id: 6b5e9a66-b568-42d7-b67b-a785ac31e473}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 99} Body: {"status":"Failure","statusCode":409,"message":"Error: Profile name already exists.","result":null} 2024-06-24 14:24:32.450 +05:30 200fc204-d0f9-46fa-b705-ab21aa0a0014 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 409 99 application/json; charset=utf-8 526.369ms 2024-06-24 14:24:51.163 +05:30 842979c0-494b-4894-a5ad-39f7eef1ab27 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - application/json-patch+json 185 2024-06-24 14:24:51.166 +05:30 842979c0-494b-4894-a5ad-39f7eef1ab27 INF CORS policy execution successful. 2024-06-24 14:24:51.166 +05:30 842979c0-494b-4894-a5ad-39f7eef1ab27 INF HTTP request: Path: /profile/upsertprofile QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiUEtUZXN0IiwidW5pcXVlX25hbWUiOiJQS1Rlc3QiLCJuYW1laWQiOiIxMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwibmJmIjoxNzE5MjE5MTg1LCJleHAiOjE3MTkyMjA5ODUsImlhdCI6MTcxOTIxOTE4NX0.f6asAI2tBMSd5H2oGQEIgqVPkURTgIt5cXDuA3Lg-Uw}, {Connection: keep-alive}, {Content-Length: 185}, {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": "PKTest Profile", "beId": 1, "isGroup": false, "menuAction": [ { "menuId": 1, "actionId": 9 } ], "parentId": null, "remarks": "" } 2024-06-24 14:24:51.171 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-24 14:24:51.171 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff 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-24 14:24:51.229 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF Executing CreatedAtActionResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-24 14:24:51.255 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF Executed action Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api) in 84.0503ms 2024-06-24 14:24:51.256 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.UpsertProfile (Sang.Security.Api)' 2024-06-24 14:24:51.256 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF HTTP Response: StatusCode: 201 Headers: {X-Correlation-Id: 842979c0-494b-4894-a5ad-39f7eef1ab27}, {Location: http://103.120.178.195/SangSecurityAPI/profile/upsertprofile}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 94} Body: {"status":"Success","statusCode":201,"message":"Profile inserted successfully.","result":"46"} 2024-06-24 14:24:51.256 +05:30 f7a7da51-eb58-4343-804c-c194a6586eff INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/profile/upsertprofile - 201 94 application/json; charset=utf-8 93.194ms 2024-06-24 14:25:12.266 +05:30 ddf36501-5512-4b88-aa4e-6fa166509a69 INF Request starting HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - application/json-patch+json 24 2024-06-24 14:25:12.269 +05:30 ddf36501-5512-4b88-aa4e-6fa166509a69 INF CORS policy execution successful. 2024-06-24 14:25:12.274 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:25:12.288 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Route matched with {action = "DeleteProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] DeleteProfile(System.Collections.Generic.List`1[Sang.Security.Api.Models.IdTableType]) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-24 14:25:12.513 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-24 14:25:12.514 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Executed action Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api) in 225.3622ms 2024-06-24 14:25:12.515 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:25:12.515 +05:30 28f10649-3fb1-4807-854c-8bc0bf89f6d3 INF Request finished HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - 200 109 application/json; charset=utf-8 249.6342ms 2024-06-24 14:25:23.250 +05:30 3308c1f2-d1b0-431d-b1f5-498e8dc92293 INF Request starting HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - application/json-patch+json 24 2024-06-24 14:25:23.253 +05:30 3308c1f2-d1b0-431d-b1f5-498e8dc92293 INF CORS policy execution successful. 2024-06-24 14:25:23.254 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:25:23.254 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Route matched with {action = "DeleteProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] DeleteProfile(System.Collections.Generic.List`1[Sang.Security.Api.Models.IdTableType]) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-24 14:25:23.325 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2024-06-24 14:25:23.326 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Executed action Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api) in 72.1017ms 2024-06-24 14:25:23.327 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:25:23.327 +05:30 4c3b0b76-4a50-4d48-8a14-120371c2a915 INF Request finished HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - 200 104 application/json; charset=utf-8 77.094ms 2024-06-24 14:28:22.126 +05:30 75e92a4d-84bc-46b9-9fc3-5238571671be INF Request starting HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - application/json-patch+json 24 2024-06-24 14:28:22.134 +05:30 75e92a4d-84bc-46b9-9fc3-5238571671be INF CORS policy execution successful. 2024-06-24 14:28:22.137 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Executing endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:28:22.139 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Route matched with {action = "DeleteProfile", controller = "Profile"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] DeleteProfile(System.Collections.Generic.List`1[Sang.Security.Api.Models.IdTableType]) on controller Sang.Security.Api.Controllers.ProfileController (Sang.Security.Api). 2024-06-24 14:28:22.238 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b ERR Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-24 14:28:22.283 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b ERR Database connection error: System.Data.SqlClient.SqlException (0x80131904): 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__DisplayClass12_0.<b__0>d.MoveNext() in D:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 242 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) ClientConnectionId:15cc92c9-4f63-43a7-8441-f6311fb51f5e Error Number:266,State:2,Class:16 2024-06-24 14:28:22.284 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b ERR Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 2024-06-24 14:28:22.288 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b ERR Deleting Profile Failed System.Data.SqlClient.SqlException (0x80131904): 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__DisplayClass12_0.<b__0>d.MoveNext() in D:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 242 --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.DbTransactionService.ExecuteTransactionAsync(Func`3 transactionAction) at Sang.Security.Api.Repositories.ProfileRepository.DeleteProfile(List`1 deleteId) in D:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Repositories\ProfileRepository.cs:line 228 at Sang.Security.Api.Services.ProfileService.DeleteProfile(List`1 deleteId) in D:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Services\ProfileService.cs:line 30 at Sang.Security.Api.Controllers.ProfileController.DeleteProfile(List`1 id) in D:\SOURCECODE\Apps\Sang.Security.Api\Sang.Security.Api\Controllers\ProfileController.cs:line 194 ClientConnectionId:15cc92c9-4f63-43a7-8441-f6311fb51f5e Error Number:266,State:2,Class:16 2024-06-24 14:28:22.290 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. 2024-06-24 14:28:22.316 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Executed action Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api) in 177.2876ms 2024-06-24 14:28:22.317 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Executed endpoint 'Sang.Security.Api.Controllers.ProfileController.DeleteProfile (Sang.Security.Api)' 2024-06-24 14:28:22.318 +05:30 c61c3680-1ea4-476d-ae1d-0698f3051f3b INF Request finished HTTP/1.1 DELETE http://103.120.178.195/SangSecurityAPI/profile/deleteprofile - 500 346 application/problem+json; charset=utf-8 192.0205ms 2024-06-24 17:25:20.707 +05:30 b92864d1-e55d-48b9-8d62-f21699e18534 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - application/json-patch+json 99 2024-06-24 17:25:20.713 +05:30 b92864d1-e55d-48b9-8d62-f21699e18534 INF HTTP request: Path: /login/login QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate, br}, {Cache-Control: no-cache}, {Connection: keep-alive}, {Content-Length: 99}, {Content-Type: application/json-patch+json}, {Host: 103.120.178.195}, {User-Agent: PostmanRuntime/7.39.0}, {Postman-Token: 17166998-8ad3-4b6d-a1c5-08b8bf786547} Host: 103.120.178.195 Body: { "loginName": "UserTest6", "password": "UserTest6", "entityId": 7, "channelId": 2 } 2024-06-24 17:25:20.717 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Executing endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-24 17:25:20.718 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 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-24 17:25:20.819 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Database retrieved 2024-06-24 17:25:21.029 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Token generated 2024-06-24 17:25:21.030 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Token generated 2024-06-24 17:25:21.031 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 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.45.0, Culture=neutral, PublicKeyToken=null]]'. 2024-06-24 17:25:21.033 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Executed action Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api) in 313.9172ms 2024-06-24 17:25:21.033 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Executed endpoint 'Sang.Security.Api.Controllers.LoginController.Login (Sang.Security.Api)' 2024-06-24 17:25:21.033 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: b92864d1-e55d-48b9-8d62-f21699e18534}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 851} Body: {"message":"Login successful.","tokens":{"accessToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiVXNlclRlc3Q2IiwidW5pcXVlX25hbWUiOiJVc2VyVGVzdDYiLCJuYW1laWQiOiI3IiwiQ3VzdG9tQ2xhaW1UeXBlIjpbIkRhdGFiYXNlS2V5IiwiRGF0YWJhc2VOYW1lIiwiQ2hhbm5lbElkIl0sIkRhdGFiYXNlS2V5IjoiNyIsIkRhdGFiYXNlTmFtZSI6IlNTMDAwMSIsIkNoYW5uZWxJZCI6IjIiLCJuYmYiOjE3MTkyMzAxMjEsImV4cCI6MTcxOTIzMTkyMSwiaWF0IjoxNzE5MjMwMTIxfQ.ex08heTHSgPkF4HDVW-RJEYD_WZvN0LmgO04ePwEsgY","refreshToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiVXNlclRlc3Q2IiwidW5pcXVlX25hbWUiOiJVc2VyVGVzdDYiLCJuYW1laWQiOiI3IiwiQ3VzdG9tQ2xhaW1UeXBlIjpbIkRhdGFiYXNlS2V5IiwiRGF0YWJhc2VOYW1lIiwiQ2hhbm5lbElkIl0sIkRhdGFiYXNlS2V5IjoiNyIsIkRhdGFiYXNlTmFtZSI6IlNTMDAwMSIsIkNoYW5uZWxJZCI6IjIiLCJuYmYiOjE3MTkyMzAxMjEsImV4cCI6MTcxOTIzMzcyMSwiaWF0IjoxNzE5MjMwMTIxfQ.FS4Sw9sisT8rIiJogc-QHM43_o1Od79a1IAd2MXwp28"}} 2024-06-24 17:25:21.035 +05:30 be042e12-2b36-4eb2-a444-cbf303d29c37 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangSecurityAPI/login/login - 200 851 application/json; charset=utf-8 328.3478ms 2024-06-24 21:29:54.371 +05:30 INF Application is shutting down...