ConnectAll UI Slowness issue in 3.8 version integrated with MS-SQL server database.

Products

• ConnectAll On-Prem

Issue/Introduction

Customers reported slowness/performance in ConnectAll UI post upgrading to 3.8.x version running on MS-SQL database.

Environment

3.8.x

Resolution

• Login to ConnectAll UI.
• Click on Settings icon on the right top corner of screen and click on "Database Settings" icon.
• Copy the URL in notepad and append below string at last.

sendStringParametersAsUnicode=false

Example:-

       Old URL:- jdbc:sqlserver://<IP:Port>;DatabaseName=<Database Name>

    New URL:- jdbc:sqlserver://<IP:Port>;DatabaseName=<Database Name>;sendStringParametersAsUnicode=false

• Replace the old URL with new URL and Save the configuration after passing the respective database password.

• Restart all ConnectAll services.
• Re-Login to UI and monitor to application performance.