search cancel

Portlets are displaying system errors

book

Article ID: 188377

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We have a few portlets that are showing Error: System Error. Contact System Administrator. Will not allow us to update them.

Environment

Release : 15.7.1

Component : CA PPM SAAS INSTALLATION AND UPGRADE

Cause

SQL error code: 1422
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SCHEMA.ODF_AUD_5002182_FCT", line 5
ORA-06512: at "SCHEMA.T_ISSUE_OODF_CA_ISSUE", line 30
ORA-04088: error during execution of trigger 'SCHEMA.T_ISSUE_OODF_CA_ISSUE'

Resolution

Issue was caused by custom attribute which we had to remove from the audit trail for an issue object.