Search This Blog

Tuesday, February 16, 2016

Skype for Business Error 56407 Failed to execute a stored procedure on the back-end.

The error like this

Log Name:      Lync Server
Source:        LS Data Collection
Event ID:      56407
Task Category: (2271)
Level:         Error

Description:
Failed to execute a stored procedure on the back-end.

Component: QoE Adaptor
Stored Procedure: QoeInsertSessionReport2

Error: System.Data.SqlClient.SqlException (0x80131904): Trying to pass a table-valued parameter with 109 column(s) where the corresponding user-defined table type requires 101 column(s).

Is usually means you have not upodated the monitoring database after a cumulative update.

It can be fixed by running powershell like this:

Install-CsDatabase -DatabaseType Monitoring -SqlServerFqdn sql.domain.local -SqlInstanceName SFB2015

No comments: