AnsweredAssumed Answered

Error when saving or creating projects (T_PROJECT_OODF_CA_PROJECT)

Question asked by Neil_Goodwin on Jun 7, 2016
Latest reply on Jun 13, 2016 by Neil_Goodwin

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:


<Description>Project Object insert failed</Description>


  1. 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

  1. 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.


Cleared cache


Turned on auditing on one attribute on project object


Removed auditing on one attribute on project object



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.