Space Manager immediately crashed after entering login details
Hint Ref: 021001140011
Hint Date: 14/01/2010
Hint Details:
ISSUE
A customer reported that they could not access their demo service as every time anyone tried to log in, Space Manager immediately crashed.
SYMPTOMS
As soon as the user's login details has been entered and OK clicked, the user got a brief glimpse of the orange time and date screen, and the main program window before everything disappeared.
CAUSE
An analysis of the translated log file found that a user had set the 'Minutes Before Logoff' in the custom settings to 10,000,000 just before the issue started.
SOLUTION
This custom setting is stored as a text string in the table but is evaluated as a SMALLINT in use. A SMALLINT can only deal with a maximum value of 32,767, which means that a larger figure caused Space Manager to crash.
The solution was to connect to the database and to manually set this custom setting to a smaller value.
It should be noted that a value of 32,767 minutes represents an inactivity delay before automatically logging users off of over 3 weeks.
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)