|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.0, 7.1
|Issue||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"=?
|Cause||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.
|Resolution||This is currently an internal limitation of the product.|
|Workaround||There are several possible ways to work around this limitation.|