A java.lang.RuntimeException when viewing RSA Via Lifecycle and Governance My Activities page sorted By Work Item
Originally Published: 2016-07-26
Last Modified: 2022-06-20
Article Number
000064518
Applies To
RSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G)
RSA Version/Condition: All
 
Issue
When 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...
Cause
This issue may occur if the column list and sort order for the individual users Work Items are overly complex. 
Resolution
Reset 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

 
Don't see what you're looking for?