Error when upgrading NA 7.3 E0504

[rocharox]

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?

[akg7]

Hello @rocharox ,

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

Can you check this?

Thanks!

[rocharox]

Ty, will do

Rodrigo

[rocharox]

Thanks for the reply.

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

[akg7]

Hello @rocharox ,

I believe  you have to manually alter the sql table.

Thanks!