1832950 Members
2806 Online
110048 Solutions
New Discussion

Error when upgrading NA 7.3 E0504

 
rocharox
Occasional Advisor

Error when upgrading NA 7.3 E0504

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?

4 REPLIES 4
akg7
HPE Pro

Re: Error when upgrading NA 7.3 E0504

Hello @rocharox ,

 

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

Can you check this?

Thanks!

Note: While I am an HPE Employee, all of my comments (whether noted or not), are my own and are not any official representation of the companyAccept or Kudo
rocharox
Occasional Advisor

Re: Error when upgrading NA 7.3 E0504

Ty, will do

Rodrigo

rocharox
Occasional Advisor

Re: Error when upgrading NA 7.3 E0504

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
HPE Pro

Re: Error when upgrading NA 7.3 E0504

Hello @rocharox ,

I believe  you have to manually alter the sql table.

Thanks!

Note: While I am an HPE Employee, all of my comments (whether noted or not), are my own and are not any official representation of the companyAccept or Kudo