Add support for Microsoft SQL Server 2019

Idea ID 2818095

Add support for Microsoft SQL Server 2019

We are forced to move to MSSQL 2019 - I would like to see this platform beeing supported.

3 Comments
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes
 
Lieutenant
Lieutenant

Our database team is also looking at upgrading from 2016 to 2019 in the next few months.  We would like to see this supported as well.  SmallOne have you experienced any issues since your migration that might serve as a heads up for those looking at this?

 

Cadet 1st Class
Cadet 1st Class

hiho,

for Central all seems ok - we are running 2020.02 until now with MSSQL 2019.

For Workflow Designer it seems bad, as you will not be able to install it if you are not going to manipulate all internal database creation files.
This of course is nothing you should do, but even if you try it will consume a lot of time and your database wont look like it should be and Workflow Designer will even fail to start.
So after days of analysis and even a support cases we droped our plan to run Workflow Designer for now.

For Self Service Portal you will also need to manipulate the internal database creation files, but here its only one single hack to get it running.

All problems are related to a "NVARCHAR / VARCHAR" issue. The internal classes and libraries from Workflow Designer and Self Service Portal (also 3rd party open source tools) are not able to detect MSSQL 2019 and so using some very old definition for MSSQL as failover.
Even if its written in the documentation

[...]If the installer is used in order to create a new SQL Server database, selecting your language in the language selection page sets the correct collation for the new database. Using one of the above collations enables using the varchar datatype for textual columns instead of the nvarchar data type. Using the varchar data type is more efficient and reduces overall database size.[...]

it will use NVARCHAR to create the tables but trying to validate them as VARCHAR

[...]Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [BRANCH_ID] in table [OO_EXECUTION_STATE]; found [nvarchar (Types#NVARCHAR)], but expecting [varchar(255) (Types#VARCHAR)][...]

Greetz Small

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.