TIBCO LogLogic LMI - User Profile Changes to Phone Number Field Starting LMI Version 6.2.1

TIBCO LogLogic LMI - User Profile Changes to Phone Number Field Starting LMI Version 6.2.1

book

Article ID: KB0077411

calendar_today

Updated On:

Products Versions
TIBCO LogLogic Enterprise Virtual Appliance 6.2.1

Description

Starting 6.2.1 TIBCO LogLogic LMI introduced pattern validation for the 'Phone Number' field under user profiles. The pattern used for this field starting version 6.2.1 in LMI dictates that the minimum required number of characters inside that field is now set to ten. Having less number of digits inside the field either including or excluding the country code would cause the GUI to error out when user data is accessed. In most cases users wouldn't see an error when they login. But the error will occur when the user attempts to perform actions like password reset, access privileges page for the user, etc.

The error users will encounter in the GUI is: "The value in the Phone Number field should contain only combination of numeric, space,+,-,. characters" as shown in the image below.
 
  User-added image

Issue/Introduction

This article explains the changes done to Phone Number field under User Profile settings for TIBCO LogLogic LMI users starting version 6.2.1.

Environment

Users must be running version 6.2.1 of TIBCO LogLogic LMI.

Resolution

To resolve this error, set the phone number field to a valid 10 digit phone number or set it to any ten numbers. Users who upgraded their LMI to 6.2.1 version from a version older than 5.5.0 will likely have many users who will encounter this problem. Instead of setting the phone number field for all values individually per profile, it's easier to change these values from database end for all users on the system. This can be achieved using the following steps:
  1. Login to LMI appliance via SSH session as 'toor' user.
  2. Execute the command '$ mysql logappconfig' (no quotes). This should drop users into MySQL command line.
  3. mysql > update admUser set phoneNum='';
That above command will set the phoneNumber field for all users including users that belong to Active Directory to an empty value. As the Phone Number field is not a mandatory field, the above procedure will resolve the issues as described in the Details section of the article. Users who need to have this field populated with a valid value, will have to change it accordingly from the GUI.