Home » discuss » Public forums » iMIS Community

Reassign Full User License

Posted April 26th, 2010 by mxiong
|

I need to reassign a full user license. I followed the iMIS insights November 2009 directions on how to reassign user classes, but I still get an error stating "Error - Addition of this user for this user class exceeds the number of licenses available at this site" when trying to assign a full user license to the new designee and when trying to assign it to the previous owner.  I have asked ASI to look into this for me and tech support said that this was an issue with my version of iMIS (15.0.3.2384).  The log number is 213623.

Has anyone run into this problem and/or have a solution?

Thanks.

‹ change sa password on SQL ServerLooking for feedback on extender and Auto Draft product ›
login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

When you disable the user...

On April 30th, 2010 Henry Huey says:

...is the user count reduced?  Here's a SQL query you can use to check the before and after count (or you can use the Security Administration query described in the iMIS Insights article).

      SELECT COUNT(1) AS TotalUserCount, ISNULL(SUM(CAST(us.IsCasualUser AS INT)), 0) AS CasualUserCount FROM UserMain um
      INNER JOIN Users us ON um.UserId = us.UserId WHERE
      um.UserId NOT IN ('MANAGER', 'ADMINISTRATOR', 'GUEST') AND ISNULL(um.ProviderKey, '') <> ''
      AND um.IsDisabled = 0 AND ISNULL(um.EffectiveDate, CAST('19000101' AS DATETIME)) <= GETDATE()
      AND ISNULL(um.ExpirationDate, CAST('30000101' AS DATETIME)) > GETDATE()

If UserMain.IsDisabled isn't being set properly for some reason, try updating it to 1 via SQL as a workaround.  The checkbox works properly for me, but I'm running a later version of iMIS.

UPDATE UserMain SET IsDisabled = 1 WHERE UserId = 'JOEUSER'

login or register to post comments