Cannot change Username/Domain

4 posts, 0 answers
  1. William
    William avatar
    2 posts
    Member since:
    Nov 2011

    Posted 19 Jan 2012 Link to this post

    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?

  2. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 19 Jan 2012 Link to this post

    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
    New TeamPulse release is here!
    Want to know what’s New and how TeamPulse could help you better tight with your clients?
    Reserve a seat for the TeamPulse R3 Webinar today!
  3. William
    William avatar
    2 posts
    Member since:
    Nov 2011

    Posted 20 Jan 2012 Link to this post

    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. 

  4. Joel
    Admin
    Joel avatar
    300 posts

    Posted 24 Jan 2012 Link to this post

    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
    New TeamPulse release is here!
    Want to know what’s New and how TeamPulse could help you better tight with your clients?
    Reserve a seat for the TeamPulse R3 Webinar today!
Back to Top