topic Re: Error when upgrading NA 7.3 E0504 in IMC

Error when upgrading NA 7.3 E0504

rocharox — Wed, 08 Sep 2021 17:25:01 GMT

When running the bach upgrade, I get the error below:

Begin install nta database...
update nta 7.3 E0504L03 database, please wait.
(1 row affected)
Msg 2705, Level 16, State 4, Server PMS-SQL\IMCSQL, Line 2
Column names in each table must be unique. Column name 'clearpass_name' in
table 'tbl_uba_save_audit_condition' is specified more than once.

Anyone ever saw an error like this one?

Re: Error when upgrading NA 7.3 E0504

akg7 — Sat, 14 Aug 2021 21:10:40 GMT

Hello @rocharox ,

It seems there is a duplicate entry of 'clearpass_name' in database.

Can you check this?

Thanks!

Re: Error when upgrading NA 7.3 E0504

rocharox — Sun, 15 Aug 2021 18:35:16 GMT

Ty, will do

Rodrigo

Re: Error when upgrading NA 7.3 E0504

rocharox — Mon, 16 Aug 2021 14:09:50 GMT

Thanks for the reply.

Just a question, do I need to edit this manually or is there an automated way of fixing the db?

Re: Error when upgrading NA 7.3 E0504

akg7 — Thu, 19 Aug 2021 06:23:21 GMT

Hello @rocharox ,

I believe you have to manually alter the sql table.

Thanks!