Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • sagi tsofan 1 post 71 karma points
    Nov 22, 2017 @ 14:31
    sagi tsofan
    0

    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:

    {"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"}
    
Please Sign in or register to post replies

Write your reply to:

Draft