RSA Identity Governance and Lifecycle 6.9.1 Application Role-to-Entitlement mapping rejection with a MySQL data source
Originally Published: 2017-01-05
Article Number
Applies To
RSA Version/Condition: 6.9.1
Third Party Product: MySQL
Third Party Product Version: My SQL v5.1.6
Issue
Entitlement Data Validation: Resource Data is invalid. Fully Qualified Name cannot be NULL
Cause
Description:
The DB driver is not recognizing the column alias names, it is referring original column names instead. To use column alias, we have to explicitly set useAliasMetadaBehavior driver property to true. We would rather prefer to have it have default value of true.
How to repeat:
Try the following query:
SELECT company_name AS customer FROM db_customers
'customer' is not recognized, but company_name is recognized.
Suggested fix:
Force the driver url to have useOldAliasMetadataBehavior as true (which has default value of false in v5.1.6)
ex:
url = "jdbc:mysql://localhost:3306/mydb?useOldAliasMetadataBehavior=true"
Resolution
url = "jdbc:mysql://localhost:3306/mydb?useOldAliasMetadataBehavior=true"
Related Articles
Use of KBA in UAT environment Number of Views How to create and manage Entitlement Attributes through the User Interface in RSA Identity Governance & Lifecycle Number of Views FileNotFoundException while creating an entitlement collector in RSA Identity Governance and Lifecycle Number of Views Access denied insufficient privileges error when clicking on entitlement Information icon in RSA Identity Governance and L… Number of Views Entitlement(app-role/group/ent) revocation request with multiple accounts in an application fails with error:"Expected 1 a… Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
