Method Community

 

Updating TenantID field in Users table

Last post 10-28-2012 3:15 PM by Matt. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-24-2012 4:37 PM

    • Matt
    • Top 10 Contributor
    • Joined on 11-03-2008
    • Posts 877

    Updating TenantID field in Users table

    I am trying to update the TenantID field in the Users table. and keep getting the following error:

    1 could not be found as a possible value to insert. Please check the spelling.

    ! is definately a value in the table, in fact it is the current value in the field. For testing pusposes I was trying to change the value from 1 to 1 and still got the error. Any ideas?


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 10-25-2012 3:32 PM In reply to

    Re: Updating TenantID field in Users table


    Hi Matt,

     

    What function are you using.? I've tried to update the tenantid field of the users table from 1 to 1 like you are doing and the message I get back is "The field TenantID does not support edit". Which is different than the message you are getting.

    Dave

  • 10-26-2012 7:44 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-03-2008
    • Posts 877

    Re: Updating TenantID field in Users table

    Hi Dave,

    I got the error with both MethodAPIUpdate and MethodAPIUpdateV2.

    The error you are getting sounds like an issue I was having earlier http://www.methodintegration.com/cs/forums/t/3672.aspx


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 10-26-2012 2:47 PM In reply to

    Re: Updating TenantID field in Users table

    Answer

    Hi Matt,

     

    I wasn't testing a multitenant account...that's why  my error was different than yours.

    The issue is now solved and you should be able to update the tenantid

    Dave


  • 10-28-2012 3:15 PM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-03-2008
    • Posts 877

    Re: Updating TenantID field in Users table

    Thanks Dave!


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


Page 1 of 1 (5 items)