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 com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.y(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.u(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dddz.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$7bec191a.execute(<generated>)
at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute(SQLTracePreparedStatement.java:112)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2848)
... 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 15.4.1.115