robotman321
New Member
Has anyone ever encountered a problem where a SQL query from a classic ASP page returns partial results, but no errors? I have a situation where a particular query on a page (one of many throughout the system) is returning a different number of rows each time it is run, and always less than the "correct" number, as determined by running the SQL against the server directly.I think this may be related to the connection timeout (since this occurs with a long-running query and my timing shows that it is returning very close to the timeout), but I am receiving no timeout errors. Instead, as far as I can tell, it causes no errors, and returns a valid \[code\]DataSet\[/code\] which the code then loops over to build the results table.Since there is no indication that an error has occurred, there is no suggestion that the data is not complete which means that users can no longer trust this report. Generally with this system, where SQL timeouts do occur frequently for "large" queries, we get error messages displayed on the page.Investigations
- I've check the HTML source to make sure there are no injected error's that I'm missing and that all tags are well-formed and that expected page elements are present. This indicates it's not an error writing a particular row from the results.** Furthermore, the number of rows returned is different each time.
- I've verified that the exact same query is being run each time.
- I've verified that the data in the DB is not changin underneath the report (it's historic and I've cross-checked by running the report and the query against the DB at the same time.)
- I've tried to manually print any errors from the query, but get nothing.
- I've tried changing the timeout (though this hasn't helped as I can only dothis on the Dev environment and there there is not sufficient data inthe DB to reach the timeout, due to this issue.).
- There are only around 20 rows in total expected, so not an issue with a very large dataset.
- Classic asp web application
- Heavy use throughout of \[code\]ADODB.Connection\[/code\] objects for connecting to the DB2 server backend databases.
- The database is static as far as the queried data is concerned.