User license problem.

Thomas Rosenbusk

Hi,

We got this issue, we got an AD group that we add users to, this control who need access to Jira, we have 10 licenses, and when we add 10 users we get this message from Jira, and the error is gone when we remove one user, so the total user count is 9, why can't we add the last user without getting that message?

Your JIRA Software license's user limit is exceeded. Users with this license only can't create issues until you have upgraded your license or reduced the number of users.

Regards:
Thomas H Pedersen.

Andy Heinzer

Hi Thomas,

Sorry to hear about this problem.  It sounds like a frustrating experience in managing Jira user license limits.  I understand that adding a group of 10 users from your AD/LDAP is having the effect in Jira of exceeding the user license limit by exactly one user.  A 10 user license should certainly allow up to 10 users on that site.

I have a theory that perhaps the Jira administrator account that is logged in at the time these AD/LDAP users are added might also be getting counted as a licensed Jira user here.  That is one way to explain the behavior as being off by one user.  There is also some SQL database queries you can use to verify user count.  Check out Get list of licensed users in Jira server.

For example, if using Jira Software, you can find which users are licensed by a query of

<span>SELECT</span> <span>DISTINCT</span> u<span>.</span>lower_user_name
<span>FROM</span>   cwd_user u
       <span>JOIN</span> cwd_membership m
         <span>ON</span> u<span>.</span>id <span>=</span> m<span>.</span>child_id
            <span>AND</span> u<span>.</span>directory_id <span>=</span> m<span>.</span>directory_id
       <span>JOIN</span> licenserolesgroup lrg
         <span>ON</span> Lower<span>(</span>m<span>.</span>parent_name<span>)</span> <span>=</span> Lower<span>(</span>lrg<span>.</span>group_id<span>)</span>
       <span>JOIN</span> cwd_directory <span>d</span>
         <span>ON</span> m<span>.</span>directory_id <span>=</span> <span>d</span><span>.</span>id
<span>WHERE</span>  <span>d</span><span>.</span>active <span>=</span> <span>'1'</span>
       <span>AND</span> u<span>.</span>active <span>=</span> <span>'1'</span>
 <span>AND</span> license_role_name <span>=</span> <span>'jira-software'</span><span>;</span>

If it is indeed this other administrator account that is in the license count unexpectedly, then try following the steps in Creating A Jira Administrator That Does Not Count Towards License.  This has steps you can follow to make sure that you can still have a Jira system admin account on the system that does not technically use a product license.

If that is not the case, then please let me know more about your environment here.

Andy