HttpWebRequest error in project worksheet
Symptoms
When trying to open a project in project worksheet, the following error occurs:
Error/warning messages:
HttpWebRequest_WebException_RemoteServer
Fiddler trace shows the following :
SOAPAction: "http://changepoint/Cha...meScaleUDFData"
SOAP fault string:
System.Web.Services.Protocols.SoapException:
Server was unable to process request.
System.Exception: Warning: Fatal error 824 occurred
[...]
at Changepoint.PM.ASMX_DataWebService.GetTimeScaleUDFData(...)
Reason:
Error on Web Request SOAP exception is in fact an outcome of another error occuring on the database server due to a Microsoft defect (http://support.microsoft.com/kb/960770)
Resolution:
Install SQL 2008 SP1 and enable trace flag 4135.
Additional notes:
See the MS article http://support.microsoft.com/kb/960770 for further information