Maximum number of licences has been reached message: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
# Enter the following. | # Enter the following. | ||
#: <code>use ''sw_systemdb''; </code> | #: <code>use ''sw_systemdb''; </code> | ||
#: <code>update swgroups set reservedlicenses = '';</code> | #: <code>update swgroups set reservedlicenses = '0';</code> | ||
# Be sure to include the semi colon at the end of each statement above otherwise the command will not execute. | # Be sure to include the semi colon at the end of each statement above otherwise the command will not execute. | ||
Revision as of 16:16, 20 August 2015
If you encounter this particular error message when attempting to login it is likely that all available licences have been reserved to one or more Service desk groups that the user is not a member of.
Resolution : Set the reserved licence within the swgroups table to 0. To do this carry out the following:
- Run the Interactive SQL program. (Start > Programs > Hornbill Core Services > Interactive SQL.)
- Enter the following.
use sw_systemdb;update swgroups set reservedlicenses = '0';
- Be sure to include the semi colon at the end of each statement above otherwise the command will not execute.