Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hello, I am facing an error whilte trying to save permmision on umbraco backoffice. details are below.
url: umbraco/users/PermissionsHandler.asmx/SaveNodePermissions
request:
{"Message":"Violation of PRIMARY KEY constraint \u0027PK_umbracoUser2NodePermission\u0027. Cannot insert duplicate key in object \u0027dbo.umbracoUser2NodePermission\u0027. The duplicate key value is (2, 1108, A).\r\nThe statement has been terminated.","StackTrace":" 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\u0026 dataReady)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)\r\n at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)\r\n at Umbraco.Core.Persistence.PetaPocoExtensions.BulkInsertRecordsSqlServer[T](Database db, SqlServerSyntaxProvider sqlSyntaxProvider, PocoData pd, IEnumerable`1 collection)\r\n at Umbraco.Core.Persistence.PetaPocoExtensions.NativeSqlPlatformBulkInsertRecords[T](Database db, ISqlSyntaxProvider syntaxProvider, PocoData pd, IEnumerable`1 collection, Int32\u0026 processed)\r\n at Umbraco.Core.Persistence.PetaPocoExtensions.BulkInsertRecordsTry[T](Database db, IEnumerable`1 collection, Transaction tr, ISqlSyntaxProvider syntaxProvider, Boolean useNativeSqlPlatformBulkInsert, Boolean commitTrans)\r\n at Umbraco.Core.Persistence.PetaPocoExtensions.BulkInsertRecords[T](Database db, IEnumerable`1 collection, Transaction tr, ISqlSyntaxProvider syntaxProvider, Boolean useNativeSqlPlatformBulkInsert, Boolean commitTrans)\r\n at Umbraco.Core.Persistence.Repositories.PermissionRepository`1.ReplaceUserPermissions(Int32 userId, IEnumerable`1 permissions, Int32[] entityIds)\r\n at Umbraco.Core.Services.UserService.ReplaceUserPermissions(Int32 userId, IEnumerable`1 permissions, Int32[] entityIds)\r\n at umbraco.cms.presentation.user.UserPermissions.SaveNewPermissions(Int32[] nodeIDs, List`1 actions, Boolean replaceChildren)\r\n at umbraco.cms.presentation.user.PermissionsHandler.SaveNodePermissions(Int32 userID, String nodes, String permissions, Boolean replaceChild)","ExceptionType":"System.Data.SqlClient.SqlException"}
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
User permission error
Hello, I am facing an error whilte trying to save permmision on umbraco backoffice. details are below.
url: umbraco/users/PermissionsHandler.asmx/SaveNodePermissions
request:
is working on a reply...