Clarity PPM1

Expand all | Collapse all

Error : Error System error. Contact system administrator.

Jump to Best Answer
  • 1.  Error : Error System error. Contact system administrator.

    Posted 01-30-2018 01:26 AM

    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 



  • 2.  Re: Error : Error System error. Contact system administrator.
    Best Answer

    Posted 01-30-2018 01:52 AM

    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



  • 3.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 01:57 AM

    Did this happened after you refreshed the database? 



  • 4.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 02:09 AM

    yes Suman. 



  • 5.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 02:32 AM

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



  • 6.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 03:02 AM

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



  • 7.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 03:05 AM

    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 



  • 8.  Re: Error : Error System error. Contact system administrator.

    Posted 01-30-2018 03:49 AM

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