At times, duplicate records can get generated in the odf_view_attributes table (exact steps are unknown), which leads to users not being able to modify the view.
Steps to Reproduce:
Expected Results: Save to be processed.
Actual Results: Received the following error: "System error. Contact system administrator." The app-ca log contains the following:
In MSSQL: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'dbo.odf_view_attributes' with unique index 'ODF_VIEW_ATTRIBUTES_U3'.
In Oracle: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (SC52133P.ODF_VIEW_ATTRIBUTES_U3) violated
Perform the following steps: