I having all global access rights and when I am trying to create a new resource and new project but the following error is displaying while clicking the save button.
Error : Error System error. Contact system administrator.
while checking the logs following error is throwing :
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.CMN_AUDITS_PK) violated
Could anyone let me know why dose the error occurs.
I assume the database schema in question might have been refreshed with another instance and these errors are quite common in such scenarios when Online back up is taken.
You can run below query and see what is the next sequence number being generated
select CMN_AUDITS_S1.NEXTVAL from dual
and then run below query to see what is the last sequence number used
select MAX(ID) from CMN_AUDITS
You should observe that result from query 1 is less than that of query 2. If so, modify the sequence CMN_AUDITS_S1 to ensure the next number is greater than result from query2
Did this happened after you refreshed the database?
yes it due to sequence please increase the next val and you should be ok
Could you please let me know how can we increase the value.
select CMN_AUDITS_S1.nextval from dual --take the count Execute the following alter sequence CMN_AUDITS_S1 increment by 5000 alter sequence CMN_AUDITS_S1 increment by 1
Restart the services and then test
I have given as 5000 but you need to check select MAX(ID) from CMN_AUDITS and then increment accordingly