RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0, 7.1
When defining a new field on a Request Form under the Request Forms
tab on the Requests
> Requests Configuration
menu the following error displays when you choose a new Display Value pair in the Options for List of values to display and associated values to set when set when selected:
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"=?
This issue occurs if you attempt to add too many fields to a dialog box in a form. There is a practical limit to the number of variables that can be used as selection options in form dialogs such as Multi Select Drop Down boxes and Drop Down Select boxes. The practical limit is about 50 items, but this may vary depending on the content of the data. The actual limit is a limit to the size of the database object used to store the XML that defines the name value pairs. This object is limited to 4000 characters in size.
If you encounter the error you can be certain that you have reached this limitation.
This is currently an internal limitation of the product.
There are several possible ways to work around this limitation.
- 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.