Deleting a Custom Object deletes all the records in the Captions table instead of specific records that are only related to the object being deleted. This can cause the Audit Trail functionality to fail on other fields associated with other objects that are still in the system.
STEPS TO REPRODUCE:
Expected Results: Only entries that pertain to the specific Custom Object should be deleted.
Actual Results: All Caption records are deleted causing issues with Audit Trail if other object fields are being audited. The Audit Trail tab (Administration -->
Data Administration --> Audit Trail) shows the message: ERROR System error. Contact system administrator in PostgreSQL database only
Audit Trail tab shows below error.
ERRORSystem error. Contact system administrator.
App- ca logs show the error stack .
CF4E5439886D:odf.auditTrail) Internal Processing exception
java.lang.Exception: Invalid expression audits: com.niku.union.persistence.PersistenceException:
SQL error code: 0
Error message: ERROR: query returned no rows
Where: PL/pgSQL function odf_aud_value_fct(text,numeric,text) line 25 at SQL statement
Release : 16.0.0, 16.0.1
Component : CLARITY STUDIO
This is Caused by DE64154 which removed the data from ODF_AUD_LOOKUP_CAPTIONS when a custom object is deleted.
Resolved in 16.0.2 and in 16.0.1 Patch #1 (16.0.1.1)
On Premise Customers:
GCP SaaS Customers:
For DE63809, reference: Audit trail tab for the projects is throwing System Error