AnsweredAssumed Answered

Error on team page while saving custom created lookup attribute value CA PPM

Question asked by suhas_bhat on Mar 18, 2019
Latest reply on Mar 19, 2019 by suhas_bhat

Hi All,


I am facing error on saving custom created lookup on team tab. When i select value in lookup in team tab(Staff Member Properties) for a resource and hit save. i am getting "ERROR System error. Contact system administrator." 

The error is thrown when i enable audit trail for attribute created.


So i checked in logs i found following error logs.


Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "CLARITY.ODF_AUD_5001357_FCT", line 5
ORA-06512: at "CLARITY.T_TEAM_OODF_CA_TEAM", line 12
ORA-04088: error during execution of trigger 'CLARITY.T_TEAM_OODF_CA_TEAM'

at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.logicalcobwebs.proxool.ProxyStatement.invoke(
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$7bec191a.execute(<generated>)
at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute(
at com.niku.union.persistence.PersistenceController.processSql(
... 96 more


The "CLARITY.T_TEAM_OODF_CA_TEAM" is a OOTB trigger which gets created when we enable audit trail for attributes in team tab. So above trigger is using an OOTB function "CLARITY.ODF_AUD_5001357_FCT" which is created based on custom lookup attribute which i have created in team tab. The function is returning more then 1 records which is causing error.  If i remove audit trail for attribute which i have created and then try to save team page by selecting value in the lookup is working fine. 


Please suggest on me on this issue. 


The version of CA PPM is