question Re: Couldn't Start Cloudera Manager after upgrading from 6.1.1 to 7.7.1 in Support Questions

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

itdm_bmi — Sat, 04 Nov 2023 10:44:26 GMT

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

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

Scharan — Sun, 05 Nov 2023 05:31:11 GMT

@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

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

VidyaSargur — Fri, 10 Nov 2023 04:41:53 GMT

@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.

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

itdm_bmi — Mon, 13 Nov 2023 05:17:29 GMT

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

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

Scharan — Mon, 13 Nov 2023 14:55:34 GMT

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

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

FelipeG — Mon, 13 Nov 2023 23:55:37 GMT

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/

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

VidyaSargur — Thu, 23 Nov 2023 06:57:00 GMT

@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?