Skype for Business – Failed to execute a stored procedure on the back-end

I recently ran an “In-Place” upgrade from Lync 2013 to Skype for Business 2015 on a 3 node Enterprise Front End pool.  After the upgrade all 3 Front Ends were logging the following error every 10-15 minutes.

I gathered something was wrong with the QOEMetrics database due to “Component QOE Adaptor”.  I ran the following PowerShell command to test the databases on my SQL Backend:

(Where -SqlServerFqdn matches your Backend SQL server.)

SfB-DBs01

You can see immediately that the QOEMetrics InstalledVersion is a point release lower than the ExpectedVersion.  To resolve this I ran the following PowerShell command:

(Where -SqlServerFqdn & -SqlInstanceName matches your Backend SQL server.)  Note, I only specified Monitoring for -DatabaseType.

I then ran Test-CsDatabase again:

SfB-DBs02

You can see that the ExpectedVersion and InstalledVersion now match.  This resolved this problem and the Event ID is no longer generated on the Front End Servers.

8 Replies to “Skype for Business – Failed to execute a stored procedure on the back-end”

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.