Troubleshooting
Problem
The Login Tracking data base attribute (maxvar.logintracking) may not be enabled for certain Manage versions by default. It should always be set to 1 with any install or upgrade of Manage. This setting is needed for login tracking, and Electronic signature features to work, as well as for entitlement purposes
Symptom
The Manage Login Tracking feature located in the Manage Users application, as well as the Electronic signature feature in Manage will not work.
Cause
A script needs to be added to set MAXVAR.LOGINTRACKING value in the Manage database =1 when Manage is installed, or upgraded
Environment
Manage 8.5, Manage 8.6
Diagnosing The Problem
If you use Login Tracking feature , or the Electronic Signature feature in Manage you will see this issue if MAXVAR.LOGINTRACKING is not = 1 (varvalue)
Validate by running this query below.
SELECT VARNAME ,VARVALUE FROM MAXVARS WHERE VARNAME = 'LOGINTRACKING'
Resolving The Problem
1- Run this SQL update :
UPDATE MAXVARS SET VARVALUE = 1 WHERE VARNAME ='LOGINTRACKING'
UPDATE MAXVARS SET VARVALUE = 1 WHERE VARNAME ='LOGINTRACKING'
2- Check the statement was successful by running query below
SELECT VARNAME ,VARVALUE FROM MAXVARS WHERE VARNAME = 'LOGINTRACKING'
SELECT VARNAME ,VARVALUE FROM MAXVARS WHERE VARNAME = 'LOGINTRACKING'
Result should be LOGINTRACKING , Varvalue = 1
3- Either enter Manage system into Admin mode in Manage in DB configuration application, then exit out of Admin mode to reload the Cache, or restart the Manage server.
This issue is planned to be fixed in Manage 8.7
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000hB0QAAU","label":"Manage"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.0;8.6.0"}]
Was this topic helpful?
Document Information
Modified date:
28 March 2023
UID
ibm16964852