Mono Support Error when Saving changes to Users (Closed)

Viewed 14779 time(s), 3 post(s), 11/6/2011 8:26:08 PM - by grant.stone007
11/6/2011 8:26:08 PM
647 Reputation 69 Total posts

I get the following error on the /MonoX/Admin/UserManager.aspx page when I click the Save button after editing a user. My current version is 4.5.3128.40. I am pretty sure I executed all upgrade SQL scripts and without error.

Please advise. Thank you.

SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: Violation of PRIMARY KEY constraint 'PK__aspnet_U__AF2760AD37703C52'. Cannot insert duplicate key in object 'dbo.aspnet_UsersInRoles'. The duplicate key value is (f142f623-8d89-45d6-99ba-9f5000c3ed63, ebaf7b92-bb12-40c3-b3e4-fd40b9932e3e). The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__aspnet_U__AF2760AD37703C52'. Cannot insert duplicate key in object 'dbo.aspnet_UsersInRoles'. The duplicate key value is (f142f623-8d89-45d6-99ba-9f5000c3ed63, ebaf7b92-bb12-40c3-b3e4-fd40b9932e3e). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() --- End of inner exception stack trace --- at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.BatchActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteActionQuery(IActionQuery queryToExecute) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PersistQueue(List`1 queueToPersist, Boolean insertActions, Int32& totalAmountSaved) at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit) at MonoSoftware.LLBLGen.Repository.CommitUnitOfWork(UnitOfWork2 unitOfWork, Boolean autoCommit) at MonoSoftware.MonoX.Admin.UserManager.#8j(Object sender, CancelEventArgs e)




System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK__aspnet_U__AF2760AD37703C52'. Cannot insert duplicate key in object 'dbo.aspnet_UsersInRoles'. The duplicate key value is (f142f623-8d89-45d6-99ba-9f5000c3ed63, ebaf7b92-bb12-40c3-b3e4-fd40b9932e3e). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute()

1
11/7/2011 11:03:50 AM
15993 Reputation 2214 Total posts

Hi,

I have send you a direct message that should solve your issue, let us know if the error is gone after applying the MonoX build version 4.5.3138.40

Note: There is a chance that you will need a newer version of Mono Software framework, so let me know if you do?

Regards

2
11/7/2011 2:07:09 PM
647 Reputation 69 Total posts

That fixed it.

Once again, I thank you for your excellent support.

- Grant.

3
This is a demo site for MonoX. Please visit Mono Software for more info.