Network Management

 View Only
  • 1.  Error when upgrading NA 7.3 E0504

    Posted Aug 12, 2021 07:11 PM

    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?


    #imc


  • 2.  RE: Error when upgrading NA 7.3 E0504

    Posted Aug 14, 2021 05:11 PM

    Hello @rocharox ,

     

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

    Can you check this?

    Thanks!



  • 3.  RE: Error when upgrading NA 7.3 E0504

    Posted Aug 15, 2021 01:41 PM

    Ty, will do

    Rodrigo



  • 4.  RE: Error when upgrading NA 7.3 E0504

    Posted Aug 16, 2021 10:10 AM

    Thanks for the reply.

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



  • 5.  RE: Error when upgrading NA 7.3 E0504

    Posted Aug 19, 2021 02:23 AM

    Hello @rocharox ,

    I believe  you have to manually alter the sql table.

    Thanks!