F
Felix Wafytech
Hello,
We've a webservice that calls a SQL 2000 stored procedure. This stored procedure takes a long time to run (approximately 4-5 minutes). This causes the webservice to return the below error:
"Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. "
We identified this to be a time out error and increased the CommandTimeOut value and the webservice timeout value to 600000. Still the issue persists, what could be the reason? The same web service works correctly, when queried with a set of parameters that returns a lesser number of records or gets processed faster.
One other question is, the webservice returns the above error in approximately 3 minutes. However, the timeout value is configured for 600000, which is 10 minutes. How could that be possible?
Any help is very much appreciated.
Thanks,
Felix.J
We've a webservice that calls a SQL 2000 stored procedure. This stored procedure takes a long time to run (approximately 4-5 minutes). This causes the webservice to return the below error:
"Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. "
We identified this to be a time out error and increased the CommandTimeOut value and the webservice timeout value to 600000. Still the issue persists, what could be the reason? The same web service works correctly, when queried with a set of parameters that returns a lesser number of records or gets processed faster.
One other question is, the webservice returns the above error in approximately 3 minutes. However, the timeout value is configured for 600000, which is 10 minutes. How could that be possible?
Any help is very much appreciated.
Thanks,
Felix.J