Force RUM to truncate username field before inserting in MySql database

Idea ID 2798537

Force RUM to truncate username field before inserting in MySql database

0 Votes

When the extracted username is longer than a certain size allowed by the MySql database field RUM returns an error.
The impact of this error is that those data, along with more data that was gathered and should be recorded in the database at the same time, is lost. A error is recorded in the log and a "SessionCacheDeadLetter" is created.
A simple truncate, before inserting the username in the database should fix this problem. The only workaround to this problem is to enable the DEUG level log and manually change the username detection extraction method from extracting between two strings to a regular expression one. Besides requiring manual intervention, this will be power processor intensive.

Best regards,
Paulo Antonio Ismenio - paulo.ismenio@Parceiros.nos.pt

Tags (2)
1 Comment
Micro Focus Contributor
Micro Focus Contributor
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.