Simptomi
Pretpostavimo da instalirate SQL Server Reporting Services u SharePoint režimu za SharePoint 2013. Ako server izveštaja ne može da opozove deljenje baze podataka kataloga, a pokrenut je SharePoint posao svakodnevnog čišćenja, keširana kopija izveštaja i skupova podataka može biti uklonjena iz baze podataka sistema za izveštavanje. To će prouzrokovati da uskladišteni akreditivi budu izgubljeni. U evidencijama grešaka usluga izveštavanja možete dobiti poruke o greškama koje su slične sledećim:
ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: Server izveštaja ne može da otvori vezu sa bazom podataka servera izveštaja. Za sve zahteve i obradu potrebna je veza sa bazom podataka. ---> System.Data.SqlClient.SqlException: Došlo je do greške vezane za mrežu ili specifičnu za instancu tokom uspostavljanja veze sa SQL serverom. Server nije pronađen ili mu se ne može pristupiti. Proverite da li je ime instance ispravno i da li je SQL Server konfigurisan da dozvoli daljinske veze. (dobavljač: TCP Dobavljač, greška: 0 - Obično je dozvoljena samo jedna upotreba svake adrese priključka (protokol/mrežna adresa/port).) ---> System.ComponentModel.Win32Exception: Only one usage of each socket address (protocol/network address/port) is normally permitted --- End of inner exception stack trace --- at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource'1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource'1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource'1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---;INFO: Failed to create SPSite for <url>: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at <url> that could accept the message. Ovo je često uzrokovano netačnom adresom ili SOAP akcijom. Više detalja potražite u članku InnerException, ako postoji. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full [::1]:32843 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(TransportContext&context) at System.Net.HttpWebRequest.GetRequestStream() at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream() --- End of inner exception stack trace ---Server stack trace: at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream() at System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout) at System.ServiceModel.Channels.HttpChannelFactory'1.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout) at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall , ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&msgData, Int32 type) at Microsoft.IdentityModel.Protocols.WSTrust.IWSTrustContract.Issue(Message message) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs, SecurityToken delegateTo, SPRequestSecurityTokenProperties properties) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForLegacyLoginContext(Uri context) at Microsoft.SharePoint.SPSite.InitUserToken(SPRequest request) at Microsoft.SharePoint.SPSite.SPSiteConstructor(SPFarm farm, Guid applicationId, Guid contentDatabaseId, Guid siteId, Guid siteSubscriptionId, SPUrlZone zone, Uri requestUri, String serverRelativeUrl, Boolean hostHeaderIsSiteName, SPUserToken userToken, Boolean appWebRequest, String appHostHeaderRedirectDomain, String appSiteDomainPrefix, String subscriptionName, String appSiteDomainId, Uri primaryUri) at Microsoft.SharePoint.SPSite.. ctor(Guid id, SPFarm farm, SPUrlZone zone, SPUserToken userToken) at Microsoft.ReportingServices.SharePoint.Objects.RSSharePointClassFactory.CreateSPSite(Guid id, RSSPUrlZone zona) na adresi Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper.GetSiteFromCatalogPath(String catalogPath, Int32 zone, Boolean noThrow)w3wp!library!123!<DateTime>:: w WARN: Catalog item <url> was not found in the SharePoint site. Biće izbrisana iz kataloga.
Pored toga, u SharePoint ULS evidencijama dobijate poruku o grešci koja je slična sledećoj:
<DateTime> w3wp.exe (0x2424) 0x12E4 SharePoint Foundation Claims Authentication fsq7 High SPSecurityContext: Request for security token failed with exception: System.ServiceModel.EndpointNotFoundException: Nije bilo krajnje tačke slušanja <na url adresi> koja je mogla da prihvati poruku. Ovo je često uzrokovano netačnom adresom ili SOAP akcijom. Više detalja potražite u članku InnerException, ako postoji. ---> System.Net.WebException: Nije moguće povezati se sa udaljenim serverom ---> System.Net.Sockets.Sockets.SocketException: Operacija na utičnici nije mogla biti izvršena zato što sistem nije imao dovoljno prostora za bafer ili zato što je red bio pun [::1]:32843
Rešenje
Ovaj problem je prvi put otklonjen u sledećim kumulativnim ispravkama za SQL Server:
Svaka nova kumulativna ispravka za SQL Server sadrži sve hitne ispravke i sve bezbednosne ispravke koje su bile uključene u prethodnu kumulativnu ispravku. Pogledajte najnovije kumulativne ispravke za SQL Server:
Status
Microsoft je potvrdio da je ovo problem u Microsoft proizvodima koji su navedeni u odeljku "Odnosi se na".
Reference
Saznajte više o terminologiji koju Microsoft koristi za opisivanje softverskih ispravki.
