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

Document created by RSA Customer Support Employee on Mar 7, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036047
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0, 7.1
IssueWhen defining a new field on a Request Form under the Request Forms tab on the RequestsRequests 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

User-added image

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"=?
CauseThis 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. 
ResolutionThis is currently an internal limitation of the product.  
WorkaroundThere 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.   

User-added image

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