Maximum number of licences has been reached message: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Template:Basic Cover | |||
| title=Maximum number of licences has been reached message | |||
| type=FAQ | |||
}} | |||
{{Template:Basic Status | |||
| status=Published | |||
| version=1.1 | |||
| authors=Hornbill Support | |||
| applicableto=Supportworks ESP Version 7.4.0 upwards | |||
}} | |||
If you encounter this particular error message when attempting to login it is likely that all available licences have been reserved to | 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. | one or more Service desk groups that the user is not a member of. | ||
| Line 8: | Line 20: | ||
# 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. | ||
Latest revision as of 16:18, 20 August 2015
| Status: | Published |
|---|---|
| Version: | 1.1 |
| Authors: | Hornbill Support |
| Applies to: | Supportworks ESP Version 7.4.0 upwards |
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.