Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Peter Zehrer Absent Member.
Absent Member.
367 views

Error while upgrading from 7.5 to 8.0 version

Hello,

 

I got an error message while upgrading from 7.5 to 8.0 version. Please find the attached log file. please let mr know the resolution.

 

Thanks,

Vamsee.

Tags (1)
0 Likes
2 Replies
Absent Member.. Niraj Prabhu Absent Member..
Absent Member..

Re: Error while upgrading from 7.5 to 8.0 version

Peter,

 

Not sure if you did this already, but you can open the kcrt_request_types_nls_800_1.sql from the upgrade bundle and try to see what it does to determine the issue. I am guessing it is something to do with the multiple records that select query is returning while making the update.

 

Regards,

Niraj

Niraj P.
Absent Member.. Oscar_Pereira Absent Member..
Absent Member..

Re: Error while upgrading from 7.5 to 8.0 version


Run the following query in order to indentify the problematic constraint:

 
select b.table_name, b.column_name, b.position from user_constraints a, user_cons_columns b
where a.constraint_name=b.constraint_name and a.constraint_name like '%SYS_C00128755%'

 
I remember a customer that received this same error and they found two fields with the same token name in an old request type. This was causing the upgrade failure in procedure to set the reference codes. He removed the problematic data entry and the upgrade completed successfully

 
Another possible cause:

Two or more REQUEST_TYPE_NAME in table KCRT_REQUEST_TYPES may be causing duplicated REFERENCE_CODE.


Check the content of table KCRT_REQUEST_TYPES

select * from KCRT_REQUEST_TYPES

 

Verify the integrity for this table content, especially duplicate values for REFERENCE_CODE

 

Thanks
Oscar Pereira

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.