Forum Discussion
Error after Update to CU5 (6.0.9319.281)
After an Update to CU5 (6.0.9319.281) on the first Server of a Skype for Business Enterprise Pool the following Error is showing, around every 3 Minutes:
Warning: EventID 57006 "RtcDb Sync Agent sproc failed"
Error: EventID 57005 "Error encountered pushing data to RtcXds Blob Store"
Bevor I will Update the other Server I need to know what that error means and how to fix it. Any Idee? Or should I update all Server and Update the Database and the Error disappear?
Regards
Adrian
Event ID 57006:
RtcDb Sync Agent sproc failed
#CTX#{ctx:{traceId:10006, activityId:"944e5513-5bea-4b4d-87f9-6724e271ca2d"}}#CTX#
Sproc: [XdsQueryCriticalDocumentSignatures]
Exception: [System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'XdsQueryCriticalDocumentSignatures'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Rtc.Common.Data.DBCore.Execute(SprocContext sprocContext, SqlConnection sqlConnection, SqlTransaction sqlTransaction)
ClientConnectionId:fe8376da-4987-43e9-9d2a-4c12dfd128a1
Error Number:2812,State:62,Class:16]
Event ID 57005:
Error encountered pushing data to RtcXds Blob Store
#CTX#{ctx:{traceId:10006, activityId:"944e5513-5bea-4b4d-87f9-6724e271ca2d"}}#CTX#
Push cycle identifier: [srvbalyfe08.bag.int.2fd688f5-0f3a-407f-bab5-3fa5c3757443]
ItemCount: [0]
Error Message: [PushController: XdsQueryCriticalDocumentSignatures failed: System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'XdsQueryCriticalDocumentSignatures'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Rtc.Common.Data.DBCore.Execute(SprocContext sprocContext, SqlConnection sqlConnection, SqlTransaction sqlTransaction)
ClientConnectionId:fe8376da-4987-43e9-9d2a-4c12dfd128a1
Error Number:2812,State:62,Class:16]
Cause: Possible issues with back-end database.
Resolution:
Ensure the back-end is functioning correctly
7 Replies
Hi you need to update your backend databases -
- If this is an Enterprise Edition Back End Server and there are no collocated databases on this server, such as Archiving or Monitoring databases, then type the following at a command line:
Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <SQL Server FQDN>
- If this is an Enterprise Edition Back End Server and there are collocated databases on this server, then type the following at a command line:
Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <SQL Server FQDN> -ExcludeCollocatedStores
- If this is an Standard Edition server, type the following at a command line:
Install-CsDatabase -Update -LocalDatabases
We are facing similar issue after installing December CU
- Issue: KB 2982006 is automatically removed after installing CU from all frontend server.
- Issue: Multiple Event ID 57005 on FE due to SQL express edition SP pushed accidentally,
- Express edition SQL version was higher so we have resolve the issue after removing SP.
11.0.602... 15.13.11
11.0.602... 5.0.1
11.0.602... 62.42.12
11.0.602... 5.5.1
11.0.602... 2.2.1
11.0.602... 1.1.2
12.0.520... 125.48.41
12.0.520... 12.36.5
12.0.520... 10.15.4 - 11.0.602... 15.13.11
11.0.602... 5.0.1
11.0.602... 62.42.12
11.0.602... 5.5.1
11.0.602... 2.2.1
11.0.602... 1.1.2
12.0.200... 125.48.41
12.0.200... 12.36.5
12.0.200... 10.15.4- As per MS we can install January 2018 cumulative update 6.0.9319.514 for Skype for Business Server 2015, Core Components. But this update is not available as of now.
-
https://support.microsoft.com/en-us/help/4074705
- https://support.microsoft.com/en-us/help/4056288
- Solutions: In my case i have reinstalled KB2982009 via DSIM/Expand tool.
- If this is an Enterprise Edition Back End Server and there are no collocated databases on this server, such as Archiving or Monitoring databases, then type the following at a command line:
It seems that you have forgotten to apply the update to the SQL databases.
Follow the "To apply the update to a back end server or Standard Edition server" instructions from the "https://support.microsoft.com/en-us/help/3061064/updates-for-skype-for-business-server-2015" article and the EventID 57005 and 57006 will not appear again.The point is, first you have to Update all the FrontEnd Server bevor you Update the Backend. Like it's written in the article https://support.microsoft.com/en-us/help/3061064/updates-for-skype-for-business-server-2015.
For me, I stopped after the Error was shown on the first FrontEnd Server. I wanted to make sure that there was no other problem, like this one: https://itbasedtelco.wordpress.com/2017/05/17/warning-may2017-windows-update-may-break-skype-for-business-2015-server/When I have time, I will update all the Server and the Backend.
- I have exactly the same issue after the update. Did you get any further?
No.
I wait until I know what it is, bevor I update the other FrontEnd.
Does the command below fix your problem?
Install-CsDatabase -LocalDatabases
