Cannot change Username/Domain

[William]

Hello,

I was adding another user to Teampulse when I had mistyped the domain name. After the user couldn't access the site, I found out that you cannot edit the username and domain for the users! I figured I'd simply delete the user and re-add them. Then I was greeted with the following error:

Create was unsuccessful. Please correct the errors and try again.

• User already exists.

However this user is no longer visible on the users list.

Help?

[David Harris]

Hi William,

Unfortunately this is a problem that can only be solved by updating data directly in the database, as deleted users are only 'soft deleted' and technically still exist under the hood. This issue will be resolved in our upcoming release, but in the meantime the easiest solution is probably use a SQL script to modify the domain value of the deleted user to something different, and then undelete the user.

What follows is a SQL script that you can run against the TeamPulse database to modify the domain value of the deleted user that is causing your problem and then undelete the user (please note that you will need to modify the values contained in <> to reflect the correct values for your circumstance):

USE [TeamPulse]
UPDATE [User]
SET Domain = '<CORRECTDOMAINVALUE>',
    DeletionDate = null
WHERE Username = '<USERNAME>'
AND DeletionDate IS NOT NULL

Please let us know if you have any issues executing this script. I have awarded you with some Telerik points as compensation for your inconvenience. 

All the best,
David Harris
the Telerik team

[William]

Well that at least has changed the error message for him when he tries to login.

Error Text:

 

Exception Type: System.Data.Services.Client.DataServiceQueryException

Exception Message: An error occurred while processing this request.

   at System.Data.Services.Client.QueryResult.EndExecute[TElement](Object source, IAsyncResult asyncResult)

   at System.Data.Services.Client.DataServiceRequest.EndExecute[TElement](Object source, DataServiceContext context, IAsyncResult asyncResult)

   at System.Data.Services.Client.DataServiceContext.EndExecute[TElement](IAsyncResult asyncResult)

   at TeamPulse.Client.Managers.ProjectManager.<>c__DisplayClass313.<GetUser>b__310(IAsyncResult ar)

   at TeamPulse.Client.DataService.TeamPulseDataContext.<>c__DisplayClass10`1.<>c__DisplayClass13.<BeginExecute>b__f()

(Inner Exception)

Exception Type: System.Data.Services.Client.DataServiceClientException

Exception Message: <?xml version="1.0" encoding="utf-8" standalone="yes"?>

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

  <code></code>

  <message xml:lang="en-US">Unlicensed users cannot access the data service</message>

</error>

   at System.Data.Services.Client.BaseAsyncResult.EndExecute[T](Object source, String method, IAsyncResult asyncResult)

   at System.Data.Services.Client.QueryResult.EndExecute[TElement](Object source, IAsyncResult asyncResult)

 

When I look at his account in the User & License management edit page, Licensed is checked. 

[Joel]

Hi William,

You might have to make sure that there are no old login cookies on the user's machine.  You can get rid of them by logging out.  If you can't get to any place in the app that allows you to log out, then you can force a logout by hitting this URL:

http://<teampulse-server>/WebLogin/Login.aspx?Logout=true

Regards,
Joel
the Telerik team