Mono Support error on Create Account 

Viewed 536993 time(s), 14 post(s), 2/3/2015 2:37:10 PM - by extremeandy
2/3/2015 2:37:10 PM
40 Reputation 6 Total posts

when recording a new user
</br>after confirmation of the button "create account"

an error has occured in the application.

here is my log file:

2015-02-03 14:56:02,107 [26] ERROR MonoX [::1] - Error
</br>SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AuditInfo_aspnet_Users". The conflict occurred in database "eMonoX", table "dbo.aspnet_Users", column 'UserId'.
</br>The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AuditInfo_aspnet_Users". The conflict occurred in database "eMonoX", table "dbo.aspnet_Users", column 'UserId'.
</br>The statement has been terminated.
</br>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
</br>   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
</br>   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
</br>   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
</br>   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
</br>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
</br>   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
</br>   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute()
</br>   --- End of inner exception stack trace ---
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute()
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteActionQuery(IActionQuery queryToExecute)
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PersistQueue(List`1 queueToPersist, Boolean insertActions)
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit)
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntityCollection(IEntityCollection2 collectionToSave, Boolean refetchSavedEntitiesAfterSave, Boolean recurse)
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.GatherAndFlushAuditData()
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.Commit()
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse)
</br>   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave)
</br>   at MonoSoftware.LLBLGen.Repository.SaveEntity(IEntity2 entityToSave)
</br>   at MonoSoftware.MonoX.Repositories.UserProfileRepository.GetUserProfile(Guid userId)
</br>   at MonoSoftware.MonoX.BusinessLayer.UserProfileBLL.GetUserProfile(Guid userId)
</br>   at MonoSoftware.MonoX.ModuleGallery.MembershipEditor.#Jp(Object sender, EventArgs e)
</br>   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
</br>   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

1
2/3/2015 2:50:39 PM
3016 Reputation 428 Total posts

Hi,

can you please let us know what MonoX version are you using? Also, did you make any changes to the existing MonoX funtionality?

Regards.

2
2/3/2015 2:55:38 PM
40 Reputation 6 Total posts

Hi Ivan,

thanks for your kind and true rapid response

MonoX_5_1_40_5065

no, any changes

3
2/4/2015 8:07:33 AM
3016 Reputation 428 Total posts

Hi,

just checked and we already have that issue addressed. Fix will be available to download most probably today or tomorrow.

Regards

4
2/10/2015 3:24:47 PM
3016 Reputation 428 Total posts

Hi,

sorry for the delay. You can check the latest version here.

Regards.

5
2/10/2015 3:51:48 PM
40 Reputation 6 Total posts

Hi Ivan

thank you

I'll try it in a few days

ciao

andrea

6
2/21/2015 11:25:47 PM
11 Reputation 2 Total posts

I have the same problem on version 5_1_40_5107.

I can't register and i can't use usermanager on admin page.





This event has been logged and will be addressed by the maintenance department. We appreciate your patience.

Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)
at SD.LLBLGen.Pro.LinqSupportClasses.MappingTracker..ctor(Boolean selfServicing) at SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.HandleExpressionTree(Expression expression) at SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.Execute(Expression expression) at SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.System.Linq.IQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source) at MonoSoftware.MonoX.Repositories.MembershipRepository.GetAllUsersRoleId() at MonoSoftware.MonoX.BusinessLayer.MembershipBLL.GetAllUsersRoleId() at MonoSoftware.MonoX.Utilities.SecurityUtility.#Sk() at MonoSoftware.MonoX.Utilities.SecurityUtility.get_AllUsersRoleId() at MonoSoftware.MonoX.Repositories.MembershipRepository.GetRoles(Boolean includeAllUsersRole, Guid applicationId) at MonoSoftware.MonoX.BusinessLayer.MembershipBLL.GetRoles(Boolean includeAllUsersRole, Guid applicationId) at MonoSoftware.MonoX.Admin.UserManager.#0v() at MonoSoftware.MonoX.Admin.UserManager.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
To continue working with the application please click here

7
4/18/2015 10:00:55 AM
11 Reputation 2 Total posts

nothing for that ?

8
4/20/2015 7:33:03 AM
15993 Reputation 2214 Total posts

We are looking into an issue and we will get back to you with a workaround or new nightly build.

Regards

9
8/5/2015 1:23:53 PM
40 Reputation 6 Total posts

Hi @Kristijan,

no solution?

10
1 2
This is a demo site for MonoX. Please visit Mono Software for more info.