This started the other day and it was first only on xogging, then it started to affect the UI (Creating & saving projects). It is an error on the audit trail trigger (I think).
I opened a case with CA, but with the impact of this issue, I am looking for any feedback I can get.
Original error when I opened the case yesterday:
<Severity>FATAL</Severity>
<Description>Project Object insert failed</Description>
<Exception><![CDATA[
- java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SC51339T.ODF_AUD_5001168_FCT", line 5
ORA-06512: at "SC51339T.T_PROJECT_OODF_CA_PROJECT", line 289
ORA-04088: error during execution of trigger 'SC51339T.T_PROJECT_OODF_CA_PROJECT'
Current Error:
ERROR 2016-06-07 10:31:20,352 [http-nio-14001-exec-22] niku.xql2 (clarity:admin:25559636__D8A5EE38-2DBB-40F7-A461-B3C17920ED13:projmgr.projectNewPost) Internal Processing exception
- com.niku.union.persistence.PersistenceException:
SQL error code: 4098
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'SC51339T.T_PROJECT_OODF_CA_PROJECT' is invalid and failed re-validation
I turned off auditing on ALL attributes from project object and all subobjects.
-Tested-
Cleared cache
-Tested-
Turned on auditing on one attribute on project object
-Tested-
Removed auditing on one attribute on project object
-Tested-
Nothing has helped. Support recommended an app server restart which I am waiting on. Anyone seen this before, that has more feedback then the KB article on the error which advised to turn off auditing.