Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gary Merdinian (GaryM712)
Accenture Federal

Accenture Federal
US
GaryM712 Member since 2016 2 posts
Accenture Federal
Posted: Jul 22, 2021
Last activity: Jul 23, 2021
Posted: 22 Jul 2021 9:28 EDT
Last activity: 23 Jul 2021 5:54 EDT
Closed

SQL 2019 in sql 2016 compatibility mode

Using Pega 8.4.2 we are upgrading out sql server 2016 database to sql 2019. After the upgrade if we change to SQL server 2016 compatibility mode will it work as expected and be supported. ?

***Edited by Moderator: Pooja Gadige to change category from Upgrade to Product, add platform capability tag***
To see attachments, please log in.
Pega Platform 8.4.2
Case Management
System Administration
Government

Posted: 3 years ago
Updated: 3 years ago
Posted: 22 Jul 2021 15:54 EDT
Updated: 22 Jul 2021 18:23 EDT
Suman Gumudavelly (SUMAN_GUMUDAVELLY)
Ford Motor Company
Pega Operations, CoE and Administration
Ford Motor Company
US

@GaryM712 As per Pega Support guide, Pega v8.4.2 is not compatible with MS SQL 2019. Application might work as expected, however, you will be operating your environment in an unsupported versions. 

In other words to say, Pega isn't  tested and certified MS SQL 2019 for Pega v84x

There are know issues with different versions of PEGA and MS SQL combination aka Starting MS SQL 2016, SQL Server started  supporting datetime2 for all its datetime fields with compatibility of 130, where as MS SQL 2019, SQL Server Engine started supporting datetime3 fields with compatibility of 140.

Unfortunately Pega not yet supporting datetime2 and datetime3, hence the support guide explicitly calling out to change the with compatibility to 120 i.e., acting MS SQL 2016/2019 like MS SQL 2014.

I suggest, you would consider platform upgrade to 8.5.4 or later , some of these nuances will be addressed with upgrade itself. 

 

Refer Page #15 and 16:

https://community.pega.com/knowledgebase/documents/platform-support-guide 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice