{ "application": "/LM/W3SVC/4/ROOT", "host": "EC2AMAZ-JQV702F", "type": "System.Data.SqlClient.SqlException", "message": "The INSERT statement conflicted with the FOREIGN KEY constraint \"FK__AspNetUse__RoleI__628FA481\". The conflict occurred in database \"Semsark_v1\", table \"dbo.AspNetRoles\", column 'Id'.\r\nThe statement has been terminated.", "source": ".Net SqlClient Data Provider", "detail": "System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint \"FK__AspNetUse__RoleI__628FA481\". The conflict occurred in database \"Semsark_v1\", table \"dbo.AspNetRoles\", column 'Id'.\r\nThe statement has been terminated.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n   at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)\r\n   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   --- End of inner exception stack trace ---\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute(EntityCommand entityCommand, CommandBehavior behavior)\r\n   at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteNonQuery()\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunctionCommand(EntityCommand entityCommand)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass4b.<ExecuteFunction>b__49()\r\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction(String functionName, ObjectParameter[] parameters)\r\n   at Semsark.Models.SemsarkEntities.SP_insertUserRole(Nullable`1 roleid, String userid)\r\n   at Semsark.Controllers.AccountController.<Register>d__20.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult)\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<BeginInvokeAsynchronousActionMethod>b__36(IAsyncResult asyncResult)\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()\r\n   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)", "time": "2026-04-13T22:24:34.2661416Z", "serverVariables": { "ALL_HTTP": "HTTP_CONNECTION:close\r\nHTTP_PRAGMA:no-cache\r\nHTTP_CONTENT_LENGTH:3075\r\nHTTP_CONTENT_TYPE:multipart/form-data; boundary=e82bbbe90123e\r\nHTTP_ACCEPT:*/*\r\nHTTP_COOKIE:__RequestVerificationToken=OogCmSpeo4aa9ScOfC1lA9WDdnbZlFgdr6An7JjoyhVyxpX_5_1OGm0QNNYZvZMPVc68rdU4QsLq_-He3o_EKcK2oFBOwXvtvJ_6Z2BTRyY1\r\nHTTP_HOST:www.semsark.com\r\nHTTP_REFERER:https://www.semsark.com/Account/Register\r\nHTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 CCleaner/130.0.0.0\r\n", "ALL_RAW": "Connection: close\r\nPragma: no-cache\r\nContent-Length: 3075\r\nContent-Type: multipart/form-data; boundary=e82bbbe90123e\r\nAccept: */*\r\nCookie: __RequestVerificationToken=OogCmSpeo4aa9ScOfC1lA9WDdnbZlFgdr6An7JjoyhVyxpX_5_1OGm0QNNYZvZMPVc68rdU4QsLq_-He3o_EKcK2oFBOwXvtvJ_6Z2BTRyY1\r\nHost: www.semsark.com\r\nReferer: https://www.semsark.com/Account/Register\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 CCleaner/130.0.0.0\r\n", "APPL_MD_PATH": "/LM/W3SVC/4/ROOT", "APPL_PHYSICAL_PATH": "C:\\inetpub\\wwwroot\\Semsark2\\", "AUTH_PASSWORD": "*****", "CERT_KEYSIZE": "256", "CERT_SECRETKEYSIZE": "2048", "CERT_SERVER_ISSUER": "C=US, O=Let's Encrypt, CN=R13", "CERT_SERVER_SUBJECT": "CN=www.semsark.com", "CONTENT_LENGTH": "3075", "CONTENT_TYPE": "multipart/form-data; boundary=e82bbbe90123e", "GATEWAY_INTERFACE": "CGI/1.1", "HTTPS": "on", "HTTPS_KEYSIZE": "256", "HTTPS_SECRETKEYSIZE": "2048", "HTTPS_SERVER_ISSUER": "C=US, O=Let's Encrypt, CN=R13", "HTTPS_SERVER_SUBJECT": "CN=www.semsark.com", "INSTANCE_ID": "4", "INSTANCE_META_PATH": "/LM/W3SVC/4", "LOCAL_ADDR": "172.31.24.199", "PATH_INFO": "/Account/Register", "PATH_TRANSLATED": "C:\\inetpub\\wwwroot\\Semsark2\\Account\\Register", "REMOTE_ADDR": "82.147.84.29", "REMOTE_HOST": "82.147.84.29", "REMOTE_PORT": "65460", "REQUEST_METHOD": "POST", "SCRIPT_NAME": "/Account/Register", "SERVER_NAME": "www.semsark.com", "SERVER_PORT": "443", "SERVER_PORT_SECURE": "1", "SERVER_PROTOCOL": "HTTP/1.0", "SERVER_SOFTWARE": "Microsoft-IIS/10.0", "URL": "/Account/Register", "HTTP_CONNECTION": "close", "HTTP_PRAGMA": "no-cache", "HTTP_CONTENT_LENGTH": "3075", "HTTP_CONTENT_TYPE": "multipart/form-data; boundary=e82bbbe90123e", "HTTP_ACCEPT": "*/*", "HTTP_COOKIE": "__RequestVerificationToken=OogCmSpeo4aa9ScOfC1lA9WDdnbZlFgdr6An7JjoyhVyxpX_5_1OGm0QNNYZvZMPVc68rdU4QsLq_-He3o_EKcK2oFBOwXvtvJ_6Z2BTRyY1", "HTTP_HOST": "www.semsark.com", "HTTP_REFERER": "https://www.semsark.com/Account/Register", "HTTP_USER_AGENT": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 CCleaner/130.0.0.0" }, "form": { "__RequestVerificationToken": "_M0vAXpJk5aXm01xw6RmUpY5Odenf1wTNoVkoXwcA4RTrp-qxgUqg4R-_te5_yCzPOscF-CL1YjN-gpOKJZH7TnQU3VYIT_18qb7fZ9aieQ1", "UserName": "Victortrubs", "PhoneNumber": "84279383322", "Email": "iteration-2@roadreg.ru", "Password": "Q8Lh#zu18wbD", "ConfirmPassword": "Q8Lh#zu18wbD", "Usertype": "?????", "g-recaptcha-response": "0cAFcWeA5btoN7yfjuKWl8YVzmrwgwF1PaVu97S70OHxcIIkQbN04foWKwiLhgFsun5Waznown8M8_nlxV5d21pQiXpKPETtLTzW7OVulX08-zq-h4HUdz5jsU_Y8AngcPo9pebWT4DdVoL6IA5c0nb4IefXOJBpZSDruNbuXJUVQN1awjHnPc_Lb-tKRS_J4XtyPvwFSJ_vQPxMbMLoRWZ8bsJT6Hfn2AwyRDTCvEzwDdoBqeCNwSOyvRv8x5FckuQkLBZma5Q3SrSKk6QpfsEVI4YoWSKEscG3Hw1fuCzezIIaDVtYaC10lMX9Kp2WLFegzsU2BRZS19EkFDaB9dxHujUyXzXKEy64_u4NfwoGEmM4-tj5H5CVpDfskJR9-utIeEyiN8oRh_WjhooqcvFHrizXcTPNxJSZPxFhnfo87YRC2u-RVKhe-1cbLB1up7DhMFg450Gl6LUKuKFgPv-lBDAzgrCXz8eE5AjoQa3-oVEXNlEZAdN8wIIUpR0QqGSnJBTN6n8Aox0QYhuYJlpdEE4oO0ksL_gPTNaG0and8VAvcgEIZ8QmcZ0Z7MwPMo-qjUPI8K7XfXZL8d0ey9UvOaq9Q2Ow-yZ4O6XsL1V5Vp6d9x0pNY1AWr3YkR09uI9CTf40TVlFDshpOhGW-EABz9_1vaLxoDKqwzhn-ys069NWZY7V7QrLPRdreyhD7bY2FsKHYG4Nu4AFCSHXJDEPuyFWIJiEhiv22wT9JrMRXtOXvCHzG29qXaFZfvyAp0Kn0ppX9wKptd-s9Ip3n6YhZe_jp0xzFxI4a4qpRJFRZVwLDCY9vhZ-O9IcI8ZEh_BeiFiElZFrUO2QBK4UpY-xMb_vxMDaMMGrPfWzbOyeqKeeTLHLTGRrzptcPlA4o2FjlLqT0Id1WXouFvuQGvSwH3xbnES1D7bO0HFmBcSdsTFpBcLEgpEm-HHAsx-YMoAr2-khYAHbKk3koiMJoIpOt_kpcaZIyicSxce1UcGgauHpJLtPYu9TusOYyk_eJzVIqNv0dTlW94d4JOM0CQtFoZvfRZmqRQcXr8MmUYCtDj91gNO7tQ7qaZErFTaEvrfm5ola52VEyIYGCRQbdz1qgiPKRYGpWHNsSE-lBEC3Dpsd_YgV1chZr1MJ8pqNGkV9IfnmT0POEFCn9mvBI88bomnn7QrxsFcyxNi-HFeWiEarJ0MBUyVjVTZLSqWiQRGeKdcRTKIVZQ4smyqOQ0NUXxdyoNzKXnZJTZCUeYzAKjW6unKKBZpeN-1Ka-Sq9ee3UkqHOCP1-McUz01EEyBFC33ri-QZP3q18BRNzfbRyQgEPj5CwhvO6-IWfsfQi4nbXLPWFR7Cg4JyIMAdLz5ZAtX7M01MyvxTYAWcoIdxJdoM61PhhIMljG7tBOFf9OgwuZCSmf9x3SOae4HyoK5xIKkdkfwF2MZE2GnRuY5CIgm1BE2V7WufqFJB1vgxJ3i5Tf79Qlw4lRg7R0XETUNYfwE2jx4bZDrVhO9Xa97MB9CwP8tMxEtHeDwOnQ204Ya94zHOON5-qQ4Dcb3pOlgRxJAew5CtTNquRuWNBbGTuwcQZCJumGnhgGCnQRkED276lggfwV9ykV-uTiW2n92AKELoOTeHO0og-kPB0-STWOcL0knt2IcTCB3Gl9snBe94SIA7olLsfSgVULviAPjt8jXCp8xr4BLGGBZXp0uEmYI88cA1_mXfhiQolLhPRu1SEsS4xCpNDmfQkwLXTmSsJ-KTYXeZYa6Zurc7PnebIKLjbfetipAmjpYvZKQ189pb5V0kbiZy-6XnS07DDPhlzH84kRCkSKYk0XcVCrDByPhCTFjLWiXqm6QwgLfYAmIImEfuw6Rt5iBTC6O3oclSHGLQXYCRHQkG9zxrtV7voBkc8kfOdb3uTX_3RqMYiw0uN33Qopye1p6Eeb4kKlizIgFpPazodDd0bpcqUZW3dOousGuR0w3uL4xopLqpm2NvG1NH_y3-wadBhRkKtuEE8FrT5aXountxoJrcyyv3d9y2bEzgdHyXSNEQK61HAqcRv55XgXxh-TerMOVq6dxTXzZ0aL8PnF6l36MAzO4au5Fs-p-4_F_nskiENa2CP7maDjHOth4qhw5xCQXbYhx7rxtaspwoEYrjNuOPOFwEoChZ7qX6jHwcIEcvKAp9k11J3jD-XZYYM9Hft3Ranu91HWKa_5TNINiw" }, "cookies": { "__RequestVerificationToken": "OogCmSpeo4aa9ScOfC1lA9WDdnbZlFgdr6An7JjoyhVyxpX_5_1OGm0QNNYZvZMPVc68rdU4QsLq_-He3o_EKcK2oFBOwXvtvJ_6Z2BTRyY1" } }