Issue creating new user from Office365

Hello,

When you select the error in the DVLS Logs dialog, do you have further information about this error message?




Have you set the Only from this group property in the Automatic user creation section?



Best regards,

Hello Erica,

This is the full error message:

SqlException - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UserRoamingSettings_UserID". The conflict occurred in database "Devolutions", table "dbo.UserAccount", column 'ID'.
The statement has been terminated.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Devolutions.Server.DatabaseManager.c843895dfc7829d351f9eb41abc3610db.cc902ee7f757050da3322ae94b0862221(DbCommand c469787a81372d641f189d46c8cbb1738)
   at Devolutions.Server.DatabaseManager.c0cced03e774635c6035f19bccecbcaf0(DbConnection cc8ffdaea2e23db4129bef3df37e0e2f5, DbTransaction c5a0ca8eaa594113c2f0b3cfe13dedff9, String c18a861f9b67a3be20238a264f7a3df12, IEnumerable`1 cd859b08da59abe612143bd1559182965, CommandType c24bc7a37e7769fa709bb027e16b894dd, Action`1 c6cc9ab02b2ea9ccd42c7c0497677bcc2)
   at Devolutions.Server.DatabaseManager.cbcc45115c47c83b663184443aeecaccc(DbConnection cc8ffdaea2e23db4129bef3df37e0e2f5, DbTransaction c5a0ca8eaa594113c2f0b3cfe13dedff9, String c18a861f9b67a3be20238a264f7a3df12, IEnumerable`1 cd859b08da59abe612143bd1559182965, CommandType c24bc7a37e7769fa709bb027e16b894dd)
   at Devolutions.Server.DatabaseManager.ExecuteNonQuery(String sql, IEnumerable`1 parameters, CommandType commandType)
   at Devolutions.Server.UserManager.c3634fbdf95e6dcc446c96cd01a2adcab(ISessionContext c7f73d40d473700e7f67b5ed4acf6d298, UserRoamingSettingEntity c05982ef72f43a9d309dd3c22a6e5c06e)

We have not set to Only from this AD group

Hello,

Thank you for the full call stack.

An engineer will have a look on this and once I will get any information, I will let you know.

Thank you for your patience.

Best regards,

Hello,

Is the attempt to create the user made from the DVLS web UI or from RDM? If it's RDM, what version are you using?

Are you able to manually create the account?

Do you see anything else in the DVLS logs or in Reports - Login Attempt on the DVLS web UI?

How many users are already created? You can get the information in the lower right corner of Administration - Users.

Best regards,

When trying to import users manually.
I search for the user, mark the person, click import.
Get promted with "You will import 0 users"

When adding a user, I enter all the details and click "Add" and nothing happens, no error logs or error messages appears.

Nothing regarding these users have any entries in Login Attempts log

We have 58users created.

Hello,

Thank you for your feedback.

The issue you have is related to the number of users created and the DVLS Enterprise license you have which is limited to 50 users.

I will ask someone from our sales department to contact you on that matter.

Best regards,

Hello,

Following your discussion with my colleague regarding the number of users, have you been able to remove the accounts of the users that have quit your organization to lower it down under 50 accounts?

Then is the automatic user account creation works?

Best regards,