Fresh install of 5.0 PU10 - Admin User not created - Object Reference Exception (3 replies)
I checked the Event Viewer and I see the following entry:
Process Date - 2022-09-07 19:26:43Z
Error Type - NonTransformSpecific
Process Id -
Transform Id -
Result Code -
Reason - An exception occurred communicating with the data source.
Action: Membership.CreateUser
Exception: Invalid column name 'LastPasswordChangedDate'.
Invalid column name 'LastActivityDate'.
Invalid column name 'LastLockedOutDate'.
Invalid column name 'FailedPasswordAttemptCount'.
Invalid column name 'FailedPasswordAttemptWindowStart'.
Invalid column name 'FailedPasswordAnswerAttemptCount'.
Invalid column name 'FailedPasswordAnswerAttemptWindowStart'.
Hi Randy,
It appears that your SQL database has been created with a binary collation that Iman does not support. We recommend you recreate the database using Latin1_General_CI_AS.
The invalid column names specified above should appear in all Capital letters.
Thanks, Erica. That worked.
I just installed IMan 5.0 PU10, and the Admin user was not created in the USERS table.
When attempting to login, the following error in written to Errors.txt:
2022-09-07 19:26:43:043 - System.NullReferenceException: Object reference not set to an instance of an object.
at Realisable.Membership.RealisableMembershipProvider.CheckCreateDefaultAdminUser(String username, String password)
at Realisable.Membership.RealisableMembershipProvider.ValidateUser(String username, String password)