Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Error while installing PPM 7.5 SP 6

Highlighted
sheik abdullah
Acclaimed Contributor

Oracle Error while installing PPM 7.5 SP 6

Hello,

When we install PPM 7.5 SP 6 below oracle error is thrown.

SQLM: ORA-00001: unique constraint (ITG_NSN_TEST.KDRV_WORKING_DAYS_U2) violated
ORA-06512: at line 201

Please help how to rectify this error.

Thanks,
Sheik
2 REPLIES
sonaliashah
Super Collector

Re: Oracle Error while installing PPM 7.5 SP 6

Hello,

Was wonering if you could also post your resolution to this issue of unique constraint?

Will also help me in a different issue with unique constraint.

Thank you,

Sonali

Utkarsh_Mishra
Honored Contributor

Re: Oracle Error while installing PPM 7.5 SP 6

Hi,

 

Run these sql...

 

select max(CALENDAR_ID) from KDRV_CALENDARS

 

Get the max value..... then

 

select KDRV_CALENDARS_S.nextval from dual

 

Get the next_val....... now

 

if the next_val is less than max_values then  you need to increment the sequence till the values, which is larger than max_val

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event