Couldn't Start Cloudera Manager after upgrading from 6.1.1 to 7.7.1

[#1]

Hi All, 

I am upgrading cloudera manager from version 6.1.1 to 7.7.1 and when starting the cloudera-scm-server service I get the following error

2023-11-04 15:53:32,946 ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'DISPLAY_NAME'

What should I do to handle the error?

please your advice for me.

Thanks

[#2]

@itdm_bmi   Can you try the following:

- Stop cloudera-scm-server

- Backup the SCM database

- Try to remove the column: ALTER TABLE PARCELS DROP COLUMN DISPLAY_NAME;

-  Start cloudera-scm-server

[#3]

Hi @Scharan, I try it but the same error message still coming. 

[#4]

Hi @itdm_bmi  Can you share the complete stack trace of the error?

[#5]

@itdm_bmi, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

[#6]

May you also provide additional information about the CDP version installed ?

* You will find supported source/target versions in the following article.
>> https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade/topics/cdppvc-upgrade-paths.html

>> https://supportmatrix.cloudera.com/

[#7]

@itdm_bmi, Have any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  If you are still experiencing the issue, can you please provide the information @Scharan and @FelipeG have requested?