For some reason my webservice application hangs at least ones a day...
Here is the error I am getting
Telerik.OpenAccess.Exceptions.AuthorizationException: A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 2 - Connection was terminated) ---> Telerik.OpenAccess.RT.sql.SQLException: A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 2 - Connection was terminated) ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Named Pipes Provider, error: 2 - Connection was terminated) ---> System.ComponentModel.Win32Exception: No process is on the other end of the pipe
--- End of inner exception stack trace ---
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.TdsParserStateObject.SNIWritePacket(SNIHandle handle, SNIPacket packet, UInt32& sniError, Boolean canAccumulate, Boolean callerHasConnectionLock)
at System.Data.SqlClient.TdsParserStateObject.WriteSni(Boolean canAccumulate)
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode, Boolean canAccumulate)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean sync, Boolean callerHasConnectionLock)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at OpenAccessRuntime.CommandWrapper.ExecuteNonQuery()
at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteNonQuery()
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.Sql2005Factory.Telerik.OpenAccess.RT.Adonet2Generic.Impl.IADOFactory.PrepareConnection(DbConnection con, IDictionary props, String id, String cid)
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)
--- End of inner exception stack trace ---
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes)
at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()
--- End of inner exception stack trace ---
at OpenAccessRuntime.ExceptionWrapper.Throw()
at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon()
at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealConWithRetry(Int32 retryCountParam, Int32 millis, Int32 userId)
at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createPooledConnection(Int32 retryCountParam, Int32 retryIntervalMsParam, Int32 userId)
at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.GetManagedConnection(Boolean highPriority, Boolean autoCommit, Int32 smId)
at OpenAccessRuntime.Relational.RelationalStorageManager.obtainConnection(Boolean forWriting) **Source - Telerik.OpenAccess.Runtime **Trace - at OpenAccessRuntime.ExceptionWrapper.Throw()
at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.executeQueryAll(ApplicationContext context, ImmutableQueryDetails query, CompiledQuery compiledQuery, QueryParameters parameters, Int32 skip, Int32 take)
at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getAllQueryResults(CompiledQuery cq, QueryParameters parameters, Int32 skip, Int32 take)
at OpenAccessRuntime.DataObjects.ForwardQueryResult.Resolve()
at OpenAccessRuntime.DataObjects.ForwardQueryResult.get_Item(Int32 indexParam)
at OpenAccessRuntime.ListEnumerator.setCurrent(Int32 _pos)
at OpenAccessRuntime.ListEnumerator.Move(Int32 relative)
at Telerik.OpenAccess.Query.TypedEnumerator`1.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at TraNextGenWebService.Sync._GetChanges(GetChangesRequest getChangesRequest)
Anyone have any idea how to fix this issue?
Thanks in advance...