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
Release : All Supported Clarity versions
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:
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