Hi,
I have an ASP.NET application, built over DotNetNuke, used in my university for student management.
Any now and then the application throws an error like this "DataBinding: 'System.Data.DataRowView' does not contain a property with the name XXXX" where XXX may be different.
I have to emphasize that _all these properties_ (that appear not to be found) _exist_ and they are generated OK by stored procedures (when querying in Sql Management studio).
I suspect some long time running reports in sql reporting services lead to a sql server overload ??? because these errors appear only when I generate some reports.
After an recopilation or application restart everything seems to work normally (until I generate some reports again).
The DotNetNuke site may be accessed successfully all this time, while my modules throw previous exceptions. All the modules that throw errors are built using SqlServerDataSource. I've specified a "e.Command.CommandTimeout = 60;" but...no luck....
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)
Thanks,
Catalin