java.lang.StackOverflowerror when viewing the Request Activities page in RSA Identity Management and Governance
2 years ago
Originally Published: 2017-01-12
Article Number
000040224
Applies To
RSA Product Set: RSA Identity Management and Governance
RSA Version/Condition: 6.9.0
 
Issue
In the RSA Identity Management and Governance user interface when accessing the Requests > Activities tab, the following error occurs and the user is unable to access the page: 
java.lang.StackOverflowerror



 
Cause
It is possible that the user's entry in T_SYSTEM_UI_SETTINGS.SETTING exceeds the size of a CLOB (4000 bytes).

To verify that this is the cause,
  1. Run the query below as 'avuser' replacing the AveksaAdmin user with the USER_ID of the affected user.
SELECT Meu.id,Meu.User_Id, Meu.Last_Name, Meu.First_Name, Meu.Email_Address, Sus.*
FROM t_system_ui_settings SUS JOIN t_master_enterprise_users MEU ON MEU.ID=SUS.USER_MEUID WHERE MEU.USER_ID = 'AveksaAdmin';
  1. Look for the SETTING_TYPE 'Table Data', and the value in the SETTING column.
Resolution
  1. Copy and paste the content of the SETTING column field with SETTING_TYPE 'Table Data' into Notepad++ or another technical editor.  You may see, as in this case, over 1200 entries for this entry:
<string>SortDir</string>
        <com.aveksa.server.utils.collections.sorting.SortCriteria>
          <list>
            <com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
              <property>WORKITEM_ID</property>
              <order>ASC</order>
            </com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
            <com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
              <property>PRIORITY_ORDER</property>
              <order>ASC</order>
            </com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
            <com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
              <property>PRIORITY_ORDER</property>
              <order>ASC</order>
            </com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
            <com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
              <property>PRIORITY_ORDER</property>
              <order>ASC</order>
            </com.aveksa.server.utils.collections.sorting.SortCriteria_-SortProperty>
These duplicates might be spread over more than one Property.
  1. Save the original content to a file.
  2. Delete the duplicates, being mindful of xml begin and end tags.
  3. Copy the resulting, much shorter, file back into the SETTING column and save the entry.
  4. Have the user login and logout and try the Activities tab again. It should now work.
Don't see what you're looking for?