U00003592 UCUDB - Status: '42S21' Native error: '2705' Msg: 'Column names in each table must be unique. Column name 'EH_Description' in table 'EH' is specified more than once.'

Document ID : KB000097927
Last Modified Date : 27/08/2018
Show Technical Document Details
Issue:
Error running DB Load during upgrade:
DB error: 'SQLExecDirect', 'ERROR ', '42S21', 'Column names in each table must be unique. Column name 'EH_Description' in table 'EH' is specified more than once.

 
Resolution:
This is an error coming back from SQL server. By definition this indicates each column has a unique name. This can happen when upgrading if a copy of the database was made and the tables were modified to include a user ID instead of dbo.

To resolve this make sure the table names are the same when making a copy of the database.