Scenario, WHD encounters an error when upgrading to higher version (11.2.1 to 12.x or 12.0 to 12.1, 12.2-12.3) and database is either MSSQL or MySQL.
"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:
Violation of PRIMARY KEY constraint 'PK__[primary key name]__[primary key value]'. Cannot insert duplicate key in object 'dbo.[name of table here]'."
Access the database server, connect to the whd database and run the below script.
Delete from EO_PK_TABLE;
What it means?
EO_PK_TABLE holds the next count for every Private Key on each table and if the count is not accurate, it will generate an error when WHD will reference to it. Clearing and restarting WHD service will regenerate the proper count.
**Generally. external databases such as MSSQL and MySQL aren't supported but the above mentioned is for informational purposes only.