Intersoft Community - WebGrid Enterprise - WebGrid binding issue : Error:: There is no row at position 1.

WebGrid binding issue : Error:: There is no row at position 1.

Glayaar — Fri, 16 Apr 2010 05:54:47 GMT

I do not see any mistake with the method to add a single row you provided.

You could try our live chat available in this link. However, currently as stated in the page our live chat is only availble from 8AM - 5PM (GMT+7) weekdays.

Support for US timezone is already planned and is scheduled for next week.

WebGrid binding issue : Error:: There is no row at position 1.

646baml — Thu, 15 Apr 2010 18:00:32 GMT

We are still using WebGrid 6.0.

This error occurs intermittently in prod environment and whenever it happens, the entire app becomes unusable. All the users get thrown out of app. The entire app can only be recover by doing IIS Reset.

It's very critical for us to resolve it.

As I already stated in this thread, we bind the webgrid using objectdatasource and objectdatasource is bind to a class which in turn execute SP call. Once resultset is been retrieved from the SP, we check if there are any rows in it, if resultset is empty then we explicitly add one row into it as below :

try

{

if (ds.Tables[0].Rows.Count == 0)

{

DataRow dr = ds.Tables[0].NewRow();

ds.Tables[0].Rows.Add(dr);

}

catch { }

Do you think by any chance above code might throw this error ?

If you look at the stacktrace, you could see that once WebGrid.OnLoad is called, all the stack trace contains the method calls related to data binding to webgrid. We do not have much control over those methods.

Is it possible, if anybody from intersoft can have verbal communication with us, so that we can look more closely into it. It would be highly appreciated. By any chance , are you available in US EST time ?

WebGrid binding issue : Error:: There is no row at position 1.

Glayaar — Wed, 14 Apr 2010 23:41:42 GMT

As fas as I know no such issue has been reported before and without being able to replicate the issue in our environment we could not know for sure the cause of such issue. Please confirm that you are already using the latest build of our control, which is WebGrid 7 build 403 and WebUI Framework 3 bild 752.

Does the simple sample WebGrid already reflect the setting your are using? Did you use filter? How many data is in the grid? What kind of paging did you use?

You could also share how to replicate the issue in the production environment so we could try to replicate the issue in our environment.

WebGrid binding issue : Error:: There is no row at position 1.

646baml — Wed, 14 Apr 2010 16:34:45 GMT

Hi, Actually, it happens only on Prod environment at our side and we could not reproduce it in QA and DEV environments so far. Could you please suggest what could be the approach to reach the root cause of this error ? If somebody else have reported this issue before ?

WebGrid binding issue : Error:: There is no row at position 1.

Glayaar — Tue, 30 Mar 2010 00:36:18 GMT

In order to analyze the issue we need to be able to replicate the issue in our environment.

I have prepared a simple sample page with the scenario you described, custom object bound to ObjectDataSource and WebGrid is bound to the ObjectDataSource. The custom object has already been available in our WebGrid sample. Feel free to modify the sample or the custom object in order to replicate the issue.

WebGrid binding issue : Error:: There is no row at position 1.

646baml — Mon, 29 Mar 2010 16:31:19 GMT

Hi Glenn,

In our app, WebGrid is bound to ObjectDataSource and ObjectDataSource is bound to a class.

This class is having two functions which provides dataset and count of records. It doesnot happen that frequently, but whenever it happens , it brings the entire application down. Then application can be recovered only by restarting IIS. Restart of IIS in production environment is not suggestable.

WebGrid binding issue : Error:: There is no row at position 1.

Glayaar — Thu, 04 Mar 2010 22:18:22 GMT

Do you mind elaborating on the WebGrid setting and the object model you are using to replicate the issue?

It would also help us greatly if you could send us a simple running project that could replicate the issue.

WebGrid binding issue : Error:: There is no row at position 1.

646baml — Thu, 04 Mar 2010 12:00:08 GMT

Hi,

I am binding WebGrid using ObjectDataSource and sometimes found that application crashes with the unhandled error as below :

<Exception><Type>System.Web.HttpUnhandledException</Type><Message>Exception of type 'System.Web.HttpUnhandledException' was thrown.</Message><Source>System.Web</Source><StackTrace> 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.atlashome_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)</StackTrace><TargetSite>Boolean HandleError(System.Exception)</TargetSite></Exception><Exception><MethodName>Application_Error</MethodName><Type>System.IndexOutOfRangeException</Type><Message>There is no row at position 1.</Message><Source>System.Data</Source><StackTrace> at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.RBTree`1.get_Item(Int32 index) at System.Data.Index.InitRecords(IFilter filter) at System.Data.Index..ctor(DataTable table, Int32[] ndexDesc, IndexField[] indexFields, DataViewRowState recordStates, IFilter rowFilter) at System.Data.DataTable.GetIndex(IndexField[] indexDesc, DataViewRowState recordStates, IFilter rowFilter) at System.Data.DataView.UpdateIndex(Boolean force, Boolean fireEvent) at System.Data.DataView.UpdateIndex(Boolean force) at System.Data.DataView.SetIndex2(String newSort, DataViewRowState newRowStates, DataExpression newRowFilter, Boolean fireEvent) at System.Data.DataView..ctor(DataTable table) at System.Web.UI.WebControls.FilteredDataSetHelper.CreateFilteredDataView(DataTable table, String sortExpression, String filterExpression, IDictionary filterParameters) at System.Web.UI.WebControls.ObjectDataSourceView.CreateFilteredDataView(DataTable dataTable, String sortExpression, String filterExpression) at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at ISNet.WebUI.DataSourceInfo.PerformSelect() at ISNet.WebUI.WebGrid.WebGridDataSourceInfo.PerformSelect() at ISNet.WebUI.DataSourceInfo.DataBind() at ISNet.WebUI.DataSourceInfo.EnsureDataBound() at ISNet.WebUI.DataSourceInfo.set_RequiresDataBinding(Boolean value) at ISNet.WebUI.WebGrid.WebGrid._?(Boolean ?) at ISNet.WebUI.WebGrid.WebGrid.OnInitializeDataSource(Object dataSource) at ISNet.WebUI.WebGrid.WebGrid.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</StackTrace><TargetSite>Int32 GetNodeByIndex(Int32)</TargetSite></Exception>