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
How to remove all user data stored in the RSA Identity Governance and Lifecycle application database Number of Views How to increase the max-pool-size for the Workpoint data source (WPDS) in RSA Identity Governance & Lifecycle Number of Views AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and mule_e… Number of Views Collection is stuck in the data collection phase in RSA Identity Governance & Lifecycle 6.9.1 Number of Views RSA Identity Governance & Lifecycle authentication fails if the authentication sources uses Aveksa Data Collector (ADC) an… Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
