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

[#1]

Article Number

000033626

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. 
 

Image description

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.

Image description

Workaround