Problem
You attempt to retrieve information about a bad call reported by a user so you launch the Skype for Business Monitoring Reports, drill down to the Peer-to-Peer Session Detail Report reports, expand the Media Quality Report section but noticed that No media quality data is available. Is displayed and there is no data logged:
Reviewing the event logs on the Skype for Business Front-End server reveals that the following error is logged:
Log Name: Lync Server
Source: LS Data Collection
Event ID: 56407
Level: Error
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).
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Rtc.Common.Data.DBCore.Execute(SprocContext sprocContext, SqlConnection sqlConnection, SqlTransaction sqlTransaction)
ClientConnectionId:26e8fcf1-c35d-4284-adf6-7bfa82b60d24
Error Number:500,State:1,Class:16
Cause: Configuration issues, an unreachable back-end or an unexpected condition has resulted in the error.
Resolution:
Verify the back-end is up and this Skype for Business Server has connectivity to it. If the problem persists, notify your organization’s support team with the relevant details.
Solution
One of the possible causes to this would be if you have a version mismatch between the ExpectedVersion and InstalledVersion for the QoEMetrics database. To determine whether this is the cause, execute the following cmdlet:
Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn <SQLserverHostingMonitoringDatabase>
Note the difference between the ExpectedVersion and InstalledVersion for the QoEMetrics database:
ExpectedVersion: 62.93.12
InstalledVersion: 62.93.8
In the event that the environment does have a mismatched version for SQL, execute the following cmdlet:
Install-CsDatabase -DatabaseType Monitoring -SqlServerFqdn <SQLserverHostingMonitoringDatabase> -DatabasePaths “Z:DataMonitoringStore(default)DbPath”,”Y:LogsMonitoringStore(default)LogPath”
**Replace the paths with the appropriate paths to the database and logs
A similar output will be displayed:
Execute the following cmdlet again to confirm that the database no longer has a mismatched version:
Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn <SQLserverHostingMonitoringDatabase>
Note the matching versions between the ExpectedVersion and InstalledVersion for the QoEMetrics database:
ExpectedVersion: 62.93.12
InstalledVersion: 62.93.12
With the mismatched database version corrected, the Media Quality Report section will now have data recorded:
