Project and Portfolio Management Practitioners Forum
cancel

Upgrade Error

Highlighted
Peter Zehrer
Super Contributor.

Upgrade Error

Hi,

 

I am trying upgrade teh PPMC from 7.5 to 8.0 and the get the error could not upgrade. Attached is the log.

 

Thanks,

Vamsee.

3 REPLIES
Kerim KILIC
Honored Contributor.

Re: Upgrade Error

i believe you have 2 request types with same reference code, check the table plz

d4y4n4
Honored Contributor.

Re: Upgrade Error

Hi Peter,

Two or more REQUEST_TYPE_NAME in table KCRT_REQUEST_TYPES may be causing duplicated REFERENCE_CODE.
Can you help to provide the content of table KCRT_REQUEST_TYPES?

select * from KCRT_REQUEST_TYPES

Regards,
Dayana
d4y4n4
Honored Contributor.

Re: Upgrade Error

Also run this query

select rt.REFERENCE_CODE ,count(*) from KCRT_REQUEST_TYPES_NLS rt
group by rt.REFERENCE_CODE
having count(*)>1