"Error editing the Location update T_AV_CRSUBMISSION_FIELDS" when defining new Form Fields in RSA Identity Governance & Lifecycle

[#1]

Article Number

000036047

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
 

Image description

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.

1. 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. 
2. You can refactor your question so that you split the data into multiple more manageable objects where each variable is below the limit. 
3. You use the custom JavaScript Block object type to dynamically populate the dialog box at run time from a WebService call.   

Image description

* 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.