Defaulted container “pega-web-tomcat” out of: pega-web-tomcat, wait-for-pegasearch (init). Trying to run with embedded search and kafka. Attached the logs. Let me know if any one faced similar issue and please provide recommended solutions for it.
web node logs.txt (19.1 KB)
@SHALINI KOPURI I noticed this in the attached logfile:
Database: Microsoft SQL Server 12.00.2000
This version seems to be for Microsoft SQL Server 2014, which is not on the Supported DB list for Pega 8.7
Microsoft SQL Server 2017, 2019, and 2022 are all options from the supported DB list.
More details available here at the Platform Support Guide
@PhilipShannon Thanks for the reply Philip. This is Azure MI SQL instance and has the latest version. The same is working fine on Azure VM Pega deployment.
@SHALINI KOPURI Thanks for the clarification on that.
How about this, also seen in the attached logfile? When I search Microsoft website it shows this version of the jdbc driver as being older and unsupported.
Driver: Microsoft JDBC Driver 8.2 for SQL Server 8.2.0.0
From this webpage Support matrix - JDBC Driver for SQL Server | Microsoft Learn
The End of Mainstream Support for version 8.2 was January 2025
@PhilipShannonI did try with 10.2.3 sql driver jar and still face the same issue. Azure MI SQL version is Microsoft 2019.
web node with new jar logs.txt (19.2 KB)
@SHALINI KOPURI , Actual root cause of this issue is stream nodes are not running. We had to fix this by truncating data in pr_data_stream_nodes, pr_data_stream_node_updates and pr_data_stream_sessions tables.