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:

<Severity>FATAL</Severity>

<Description>Project Object insert failed</Description>

<Exception><![CDATA[

  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.

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

Outcomes