HPDM Upgrade 5.0.3 to 5.0.6 - Database Setup Failed

[SEFL]

Upgrading HPDM to 5.0.6 from 5.0 (5.0.3 version) on 2016 Server x64. All components upgrade successfully but DM server service will not start due to database (Microsoft SQL Server 2019 with SQL server Authentication) update failure. Current version works as excepted. HPDM server log "hpdm-dbsetup" has the following message list below. We have tried backing up DB and restoring it to DB after upgrade but server service still fails to start due to database update failure. Any assistance would be helpful. Thank you.

2021-07-27 10:49:34 [main ] INFO DMConnectionProvider - Using Device Manager built-in connection pool.
2021-07-27 10:49:34 [main ] INFO DMConnectionProvider - Hibernate connection pool size: 50
2021-07-27 10:49:34 [main ] INFO DMConnectionProvider - autocommit mode: false
2021-07-27 10:49:34 [main ] INFO DMConnectionProvider - using driver: com.microsoft.sqlserver.jdbc.SQLServerDriver at URL: jdbc:sqlserver://CSCVGENSQL1:1433;SelectMethod=cursor;DatabaseName=50_HPDM_DB
2021-07-27 10:49:34 [main ] DEBUG DMConnectionProvider - opening new JDBC connection
2021-07-27 10:49:34 [main ] DEBUG DMConnectionProvider - created connection to: jdbc:sqlserver://CSCVGENSQL1:1433;SelectMethod=cursor;DatabaseName=50_HPDM_DB, Isolation Level: 2
2021-07-27 10:49:34 [main ] DEBUG DMConnectionProvider - Checked out count:1
2021-07-27 10:49:35 [main ] DEBUG DMConnectionProvider - Checked out count:0
2021-07-27 10:49:35 [main ] WARN UUIDHexGenerator - HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
2021-07-27 10:49:35 [main ] WARN RootClass - HHH000038: Composite-id class does not override equals(): com.hp.hpdm.model.entity.TemplateFolderId
2021-07-27 10:49:35 [main ] WARN RootClass - HHH000039: Composite-id class does not override hashCode(): com.hp.hpdm.model.entity.TemplateFolderId
2021-07-27 10:49:37 [main ] DEBUG DMConnectionProvider - Checked out count:1
2021-07-27 10:49:38 [main ] DEBUG DMConnectionProvider - Checked out count:0
2021-07-27 10:49:38 [main ] WARN HibernateUtil - Error executing DDL "alter table 50_HPDM_DB.dbo.dm_user add salt nvarchar(64)" via JDBC Statement
2021-07-27 10:49:38 [main ] WARN HibernateUtil - Failed to update database schema
2021-07-27 10:49:38 [main ] WARN DBSetupUtil - Upgrade DB process fail.
2021-07-27 10:49:38 [main ] INFO DBObject - Database setup failed.
2021-07-27 10:49:38 [main ] INFO MainApplication - Result code:-1

[SEFL · Accepted solution]

This issue was resolved by our DBA. Database statement was added manually that was failing in log. DBA statement below.

The 'hpdm' user is the db_owner, so I don't think this is a permissions issue.

This is "alter table 50_HPDM_DB.dbo.dm_user add salt nvarchar(64)" statement seems to be failing, so I have taken a backup and run this statement manually.