MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Error when Saving changes to Users (Closed) (Mono Support )

Viewed 14054 time(s), 3 post(s) 11/6/2011 8:26:08 PMby grant.stone007
grant-stone007

grant.stone007

11/6/2011 8:26:08 PM
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()

This content has not been rated yet. 
647 Reputation 69 Total posts
khorvat

khorvat

11/7/2011 11:03:50 AM
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
Rated 5.00, 1 vote(s). 
15993 Reputation 2214 Total posts
grant-stone007

grant.stone007

11/7/2011 2:07:09 PM
That fixed it.

Once again, I thank you for your excellent support.

- Grant.
This content has not been rated yet. 
647 Reputation 69 Total posts