Article Content
Article Number | 000038569 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x |
Issue | When exporting metadata in RSA Identity Governance & LifecycRSA Identity Governance (Admin > Import/Export > Export), the metadata export fails with: The request could not be handled |
Cause | This issue has two known root causes:
When exporting metadata, if any of the table definitions being exported have invalid or corrupt data in those tables, the metadata export will fail.
When exporting metadata, if any of the table definitions being exported belong to a custom table to which avuser does not have select privileges, the metadata export will fail. |
Resolution | To resolve this issue, the corrupt data needs to be fixed and the select privilege needs to be granted on any custom tables in the avuser schema. If corrupt data is suspected, one known corruption has been reported in RSA Knowledge Base Article 000035732 -- 'Request could not be handled' and 'No enum constant com.aveksa.server.core.DataCollector.Status.InActive' errors exporting metadata from RSA Identity Governance & Lifecycle. For any other suspected data corruption issues that might be affecting the metadata export, please contact RSA Identity Governance & Lifecycle Support for further assistance. For any custom tables in the avuser schema, follow these steps to grant the proper privileges to those tables:
For example:
|
Notes | When the avdb schema is initially created, the avdwuser is given select privileges on all tables using the following script file: $AVEKSA_HOME/database/Create Scripts/Grant_Select_To_Reports.sql Any tables created after the avdb schema has been created need to have the grant select statement executed manually. |