This question is locked. New answers and comments are not allowed.
Hi,
From time to time I encounter error 40143 in my Windows Azure/SqlAzure web application, like those:
(simple RadListBox_object.DataBind() operation)
or
(calling domain method/stored procedure)
Is there any way to configure in OA model, by default, the retry of a simple select operation. Or maybe with every DataBind()/Rebind() one has to implement his own mechanism? Any suggestions
From what I see so far, there is only connection retry in OA model backend configuration.
Kind Regards,
Jacek
From time to time I encounter error 40143 in my Windows Azure/SqlAzure web application, like those:
(simple RadListBox_object.DataBind() operation)
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException'
was thrown.
---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> Telerik.OpenAccess.Exceptions.DataStoreException: Error executing query:
Telerik.OpenAccess.RT.sql.SQLException:
The service has encountered an error processing your request. Please try again. Error code 40143. A severe error occurred on the current command. The results, if any, should be discarded. at
Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() at
OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL: SELECT a.[RoleId] AS COL1, a.[RoleName] AS COL2 FROM [aspnet_Roles] a ORDER BY COL2
Telerik.OpenAccess.RT.sql.SQLException:
The service has encountered an error processing your request. Please try again. Error code 40143. A severe
error occurred on the current command. The results, if any, should be discarded.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() at
OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
---> Telerik.OpenAccess.RT.sql.SQLException:
The service has encountered an error processing your request. Please try again.
Error code 40143. A severe error occurred on the current command. The results, if any, should be discarded. at
Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() at
OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
--- End of inner exception stack trace ---
at Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) at OpenAccessRuntime.ExceptionWrapper.Throw()
at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.fetchNextQueryResult(ApplicationContext
context, RunningQuery runningQuery, Int32 skipAmount)
at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getNextQueryResult(QueryResultWrapper aQrs, Int32
skipAmount) at OpenAccessRuntime.DataObjects.ForwardQueryResult.Initialize(Int32 indexParam) at
OpenAccessRuntime.DataObjects.ForwardQueryResult.get_Item(Int32 indexParam)
at OpenAccessRuntime.ListEnumerator.setCurrent(Int32 _pos) at OpenAccessRuntime.ListEnumerator.Move(Int32
relative) at OpenAccessRuntime.ListEnumerator.MoveNext() at
Telerik.OpenAccess.Query.TypedEnumerator`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1
collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
--- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[]
arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[]
arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder,
Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[]
parameters)
at Telerik.OpenAccess.Web.QueryableDataSourceHelper.ToList(IQueryable query, Type dataObjectType) at
Telerik.OpenAccess.Web.OpenAccessLinqDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback
callback)
at Telerik.Web.UI.RadComboBox.OnDataBinding(EventArgs e) at Telerik.Web.UI.RadComboBox.PerformSelect() at
System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at Telerik.Web.UI.RadComboBox.DataBind() at XXX.Page_Load(Object sender, EventArgs e)
in c:\XXX\xxx.cs:line 129 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs
e) at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Adapters.ControlAdapter.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint)
at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest
(HttpContext context) at ASP.XXX_aspx.ProcessRequest(HttpContext context)
in XXX.cs:line 0 at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
or
(calling domain method/stored procedure)
System.Data.SqlClient.SqlException (0x80131904): The service has encountered an error processing your request.
Please try again. Error code 40143. A severe error occurred on the current command. The results, if any,
should be discarded. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior,
Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) 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.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.Data.Common.OACommand.ExecuteNonQuery() at
Telerik.OpenAccess.OpenAccessContextBase.ExecuteNonQuery(String commandText, CommandType commandType,
DbParameter[] parameters) at OpenAccessModel.mystoredprocedure() in c:
\xxx\OAModel.cs:line 658 at XXXX.SomeMethod() in c:\XXX\xx.aspx.cs:line 247
Is there any way to configure in OA model, by default, the retry of a simple select operation. Or maybe with every DataBind()/Rebind() one has to implement his own mechanism? Any suggestions
From what I see so far, there is only connection retry in OA model backend configuration.
Kind Regards,
Jacek