000033626 - A java.lang.RuntimeException when viewing RSA Via Lifecycle and Governance My Activities page sorted By Work Item

Document created by RSA Customer Support Employee on Jul 28, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033626
Applies ToRSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G)
RSA Version/Condition: All
 
IssueWhen attempting to view the RSA Via L&G My Activities page sorted By Work Item a user receives a java.lang.RuntimeException.  In addition when this exception occurs, other users may notice a performance degradation of the RSA Via L&G console. 
 
User-added image

The following exceptions are logged in the /home/oracle/jboss-4.2.2.GA/server/default/deploy/aveksa.ear/aveksa.war/log/aveksaServer.log:
05/16/2016 11:12:18.299 ERROR (WebContainer : 2) [com.aveksa.gui.components.table.special.SQLTable] Error getting Object List 
Caused by: 
java.sql.SQLSyntaxErrorException: ORA-00962: too many group-by / order-by expressions

or
05/10/2016 10:57:12.977 ERROR (WebContainer : 35) [com.aveksa.UI] com.aveksa.gui.components.table.core.DefaultTableModel.getObjects(DefaultTableModel.java:184) - 
java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: Executing JDBC query failed [select * from (select * from (SELECT...
CauseThis issue may occur if the column list and sort order for the individual users Work Items are overly complex. 
ResolutionReset the custom column options for the user that is causing the problem.  
  1. From the My Activities tab of the problem user select Table Options.
  2. Then under the Columns tab select Reset to default column settings.
  3. Click OK to save.
  4. The user will have to setup new columns and sort options for this view.
If you do not know the user who has the problem view, or if there is a risk that there is more than one user and you cannot identify them all, then the administrator should reset the view for all users.
  1. From the My Activities tab of the problem user select Table Options.
  2. Then under the Columns tab select Reset to default column settings.
  3. Then, in addition to the above, under the Columns”tab select Set current columns as default for all users.
  4. Click OK to save.
  5. All users will have to setup new column and sort options for this view.
User-added image
Workaround
 

Attachments

    Outcomes