• ×
    Information
    Windows update impacting certain printer icons and names. Microsoft is working on a solution.
    Click here to learn more
    Information
    Need Windows 11 help?
    Check documents on compatibility, FAQs, upgrade information and available fixes.
    Windows 11 Support Center.
  • post a message
  • ×
    Information
    Windows update impacting certain printer icons and names. Microsoft is working on a solution.
    Click here to learn more
    Information
    Need Windows 11 help?
    Check documents on compatibility, FAQs, upgrade information and available fixes.
    Windows 11 Support Center.
  • post a message
Guidelines
We have new content about Hotkey issue, Click here to check it out!
HP Recommended
HP Device Manager
Microsoft Windows Server 2016

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

1 ACCEPTED SOLUTION

Accepted Solutions
HP Recommended

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.

View solution in original post

1 REPLY 1
HP Recommended

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.

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the <a href="https://www8.hp.com/us/en/terms-of-use.html" class="udrlinesmall">Terms of Use</a> and <a href="/t5/custom/page/page-id/hp.rulespage" class="udrlinesmall"> Rules of Participation</a>.