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
How to enable SSL debug when using the WebSphere application server with RSA Identity Governance & Lifecycle Number of Views RCM CRL not being generated automatically per crl timer configuration Number of Views Service Provider hangs at throughput of 5 assertions per second 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 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
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
