Error : Error System error. Contact system administrator.

[Legacy User]

Hi All,

 

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. 

 

Regards,

Frederic 

[Sridhar Bandaru]

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

[Suman Pramanik]

Did this happened after you refreshed the database? 

[Legacy User]

yes Suman. 

[Suman Pramanik]

yes it due to sequence please increase the next val and you should be ok 

[Legacy User]

Could you please let me know how can we increase the value. 

[Suman Pramanik]

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 

[Suman Pramanik]

I have given as 5000 but you need to check  select MAX(ID) from CMN_AUDITS and then increment accordingly