SQL Server Performance

'System.Data.DataRowView' does not contain a property with the name...

Discussion in 'SQL Server 2005 General DBA Questions' started by icm76, Mar 25, 2009.

  1. icm76 New Member

    I have an ASP.NET application, built over DotNetNuke, used in my university for student management.

    Anynow and then, when generating some long-running report, the applicationthrows an error like this: "DataBinding: 'System.Data.DataRowView' doesnot contain a property with the name XXXX" where XXX may be different.

    Ihave to emphasize that _all these properties_ (that appear not to befound) _exist_ and they are generated OK by stored procedures (whenquerying in Sql Management studio). 95% of the time the code works but,when generating reports, it stops working...

    After a recompilation or application restart everything seems to work normally (until I generate some reports again).

    TheDotNetNuke site may be accessed successfully all this time, while mymodules throw previous exceptions. All the modules that throw errorsare built using SqlServerDataSource. I've specified a"e.Command.CommandTimeout = 60;" but... no luck.
    Our applicationuses ObjectDataSource, SqlDataSource and code-behind data binding.These errors seem to appear only in the pages the use SqlDataSource butnot in those using ObjectDataSource or code-behind data binding.

    Forsolving this "mystery" on the machine we created another instance wherewe moved the tables used for intensive and large reports (like a datawarehouse). For this instance we've also installed the ReportingServices.

    So, the SQL 2005 is used:
    -instance 1: main production database + Reporting Services instance 1 for simple reports
    -instance 2: database used for reporting activities + Reporting Services instance 2 for large reports

    wehave also checked for deadlocks using the 1222 flag but when the errorsstart occurring there are no deadlocks (no errors or warnings, in fact)in the logs for both instances.

    Also, there are separate application pools for the main app, and for both reporting services instances.

    Server specs:
    - OS: Windows 2003 R2, 64 bit
    - SQL Server 2005 Standard, 64 bit
    - 8 GB RAM
    - Intel Xeon E 5345 2.33 Ghz (2 quad-core)
    This is the ASP.NET log:
    InnerException: A field or property with the name 'Denumire' was not found on the selected data source.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Web.UI.WebControls.BoundField.GetValue
    StackTrace:
    Message:DotNetNuke.Services.Exceptions.PageLoadException: A field or propertywith the name 'Denumire' was not found on the selected data source.---> System.Web.HttpException: A field or property with the name'Denumire' was not found on the selected data source. atSystem.Web.UI.WebControls.BoundField.GetValue(Control controlContainer)at System.Web.UI.WebControls.BoundField.OnDataBindField(Object sender,EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) atSystem.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) atSystem.Web.UI.Control.DataBindChildren() atSystem.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) atSystem.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32dataSourceIndex, DataControlRowType rowType, DataControlRowStaterowState, Boolean dataBind, Object dataItem, DataControlField[] fields,TableRowCollection rows, PagedDataSource pagedDataSource) atSystem.Web.UI.WebControls.GridView.CreateChildControls(IEnumerabledataSource, Boolean dataBinding) atSystem.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerabledata) atSystem.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)atSystem.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerabledata) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() atSystem.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() atSystem.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()at System.Web.UI.Control.EnsureChildControls() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Control.PreRenderRecursiveInternal() atSystem.Web.UI.Page.ProcessRequestMain(BooleanincludeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)--- End of inner exception stack trace ---
    Thank you,
    Catalin

Share This Page