enter image description here

After the latest updates in September 2020 I couldn't succeed to complete SharePoint Product Configuration Wizard on my developing machine. We get the following error on database upgrade phase (see attachment photo).

Error: Must declare the scalar variable "@newViewUID".

My Machine Configuration: Windows Server 2019 - MSSQL Server 2017 - SharePoint 2019

We have tried to upgrade Databases through PowerShell and we got the same error. Also same error when we add New Content Database through Central Administration.

Today I have build new machine with Configuration. Windows Server 2019 - MSSQL Server 2019 - SharePoint 2019

I Install MSSQL Server 2019, SharePoint 2019 successfully. I have done the updates and run Configuration wizard. Faced with same Error.

Error: Must declare the scalar variable "@newViewUID"

I appreciate for any help in advance.

1 Answer 1


Finally found what is causing the issue! It's because of MSSQL Server in Turkish collation. After SharePoint September 2020 updates SharePoint Configuration wizard fails.

Here is what I did to find the issue: I have build up new system: Windows Server 2019 - MSSQL Server 2019 - SharePoint 2019

During Setup of MSSQL server I change default Collation(Turkish_CI_AS) to Latin1_General_CI_AS_KS_WS and everything works fine. Configuration wizard succeed! Databases successfully Upgraded!

Hoping to help someone having the same issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.