RSA Identity Governance and Lifecycle 6.9.1 Application Role-to-Entitlement mapping rejection with a MySQL data source
Originally Published: 2017-01-05
Last Modified: 2023-09-25
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
RCM CRL not being generated automatically per crl timer configuration Number of Views How to enable SSL debug when using the WebSphere application server with RSA Identity Governance & Lifecycle Number of Views Request from Account Access and Ownership Review stuck in Fulfillment Phase when "Create a job per group, grouping by " us… Number of Views Service Provider hangs at throughput of 5 assertions per second Number of Views RSA Via Lifecycle and Governance Fulfillment Workflows "Create a job per group, grouping by user" creates a single job for… Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme AFX Server and Remote Collection Agents fail to start after updating Java to version 1.8u241 (1.8.0_241) / 1.7u251 (1.7.0_… RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?
