User cannot access the Projects page

Products

• Clarity PPM On Premise

Issue/Introduction

One user getting "Error System error. Contact system administrator" on Project List after configuring their filters.

We tried restoring defaults for the specific user and cleared cache but it was unsuccessful.

Error found in app-ca.log:

ERROR 2020-02-06 14:01:27,417 [http-nio-8081-exec-909] niku.xql2 (clarity:userid:35301648__D0A7FA62-4CFD-40C1-A15C-63A661A74F20:mainnav.work) Internal Processing exception
com.niku.odf.griphendor.GriphendorException: com.niku.union.persistence.PersistenceException:
SQL error code: 1460
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01460: unimplemented or unreasonable conversion requested

 

Environment

Release : All Supported Clarity versions

Resolution

Issue is caused by a corrupted Saved Filter, this is why Restore to Defaults does not work.

Identify the saved filter by running:

     SELECT  a.*
          FROM     cmn_attribute_value_sets a
          WHERE    a.view_code = 'projectList'
          AND      a.user_id = <enter here the affected user id>

 

Now fill the data in the below workaround.

Solution:

1. Backup tables cmn_attribute_values and cmn_attribute_value_sets
2. Run the queries: 

delete from cmn_attribute_values
where attribute_set_id in (
<enter the id(s) returned from the query above>
)
commit

          delete from  cmn_attribute_value_sets a
          WHERE    a.view_code = 'projectList'
          AND      a.user_id = <insert here the user id>

commit

 

3. Ask the user to try again and it should work