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 (Zatvorena) (Mono Support )

15038 put(a) pogledan, 3 odgovor(a) 6.11.2011. 20:26:08Kreirao(la) grant.stone007
grant-stone007

grant.stone007

6.11.2011. 20:26:08
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()

Ovaj sadržaj još nije ocijenjen. 
647 Reputacija 69 Ukupno objava
khorvat

khorvat

7.11.2011. 11:03:50
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
Ocjena 5,00, 1 glas(ova). 
15993 Reputacija 2214 Ukupno objava
grant-stone007

grant.stone007

7.11.2011. 14:07:09
That fixed it.

Once again, I thank you for your excellent support.

- Grant.
Ovaj sadržaj još nije ocijenjen. 
647 Reputacija 69 Ukupno objava