000034671 - java.lang.StackOverflowerror when viewing the Request Activities page in RSA Identity Management and Governance

Document created by RSA Customer Support Employee on Jan 13, 2017•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000034671
Applies ToRSA Product Set: RSA Identity Management and Governance
RSA Version/Condition: 6.9.0
 
IssueIn 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


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

Attachments

    Outcomes