"Error editing the Location update T_AV_CRSUBMISSION_FIELDS" when defining new Form Fields in RSA Identity Governance & Lifecycle
Originally Published: 2018-02-20
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.0, 7.1
Issue
Error editing the Location update T_AV_CRSUBMISSION_FIELDS
The following corresponding error is displayed in the /home/oracle/wildfly-8.2.0.Final/standalone/log/aveksaServer.log:
02/16/2018 13:53:16.950 ERROR (default task-21) [com.aveksa.gui.pages.changeRequest.edit.container.BaseEditAdditionalInformationFieldDialogData] com.aveksa.server.db.PersistenceException: update T_AV_CRSUBMISSION_FIELDS set "FIELD_ORDER"=?
Cause
If you encounter the error you can be certain that you have reached this limitation.
Resolution
Workaround
- Since the limitation is actually in the total number of characters in the object, and not the number of items, you may be able to reduce the character size of the Display or Value items until the size of the object is below the limit.
- You can refactor your question so that you split the data into multiple more manageable objects where each variable is below the limit.
- You use the custom JavaScript Block object type to dynamically populate the dialog box at run time from a WebService call.
* This requires knowledge of JavaScript and WebServices which is beyond the scope of what can be provided in a knowledge article. If you require assistance with the design of custom JavaScript code, please consult RSA Professional Services for assistance.
Related Articles
Performance improvements related to T_AV_MODEL_EXPLODEDUSERENTS table in RSA Identity Governance & Lifecycle 50Number of Views RSA Identity Governance and Lifecycle 7.0.1 HTML source edit doesn't work with workflow email node 27Number of Views The approval workflow isn't working as expected when grouping by business source in the request form with the provisioning… 33Number of Views The T_AV_ROLE_METRICS table is very large in RSA Identity Governance & Lifecycle 35Number of Views PuTTY fatal error (Couldn't agree a key exchange algorithm) after upgrading to RSA Authentiation Manager 8.4 patch 2 or pa… 116Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?