Issue with Application that consumes sdata

[Malay_Mukherjee]

Hi,

Earlier I had created one demo application for client demostration purpose, that consumes SDATA and performs CRUD operations.

Earlier it was working well and I didnot used that application for long. Now I need to use that application. But unfortunately, though Read and Insert operation is working perfectly, I am getting an 500 error(Internal Server Error) while updating any payload using update().

The error I am getting is as under,

Error: System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
at System.Net.HttpWebRequest.GetResponse()
at System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials credentials)
at System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials)
at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)
at System.Xml.XmlTextReaderImpl.OpenStream(Uri uri)
at System.Xml.XmlTextReaderImpl.DtdParserProxy_PushExternalSubset(String systemId, String publicId)
at System.Xml.XmlTextReaderImpl.DtdParserProxy.System.Xml.IDtdParserAdapter.PushExternalSubset(String systemId, String publicId)
at System.Xml.DtdParser.ParseExternalSubset()
at System.Xml.DtdParser.ParseInDocumentDtd(Boolean saveInternalSubset)
at System.Xml.DtdParser.Parse(Boolean saveInternalSubset)
at System.Xml.XmlTextReaderImpl.DtdParserProxy.Parse(Boolean saveInternalSubset)
at System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XPath.XPathDocument.LoadFromReader(XmlReader reader, XmlSpace space)
at System.Xml.XPath.XPathDocument..ctor(Stream stream)
at Sage.SData.Client.Core.SDataServiceException..ctor(String message, WebException innerException)
at Sage.SData.Client.Core.SDataService.Update(SDataBaseRequest request, ISyndicationResource resource)
at Sage.SData.Client.Core.SDataSingleResourceRequest.Update()
at SDATAContactTest.SDataForm.btnUpdateContact_Click(Object sender, EventArgs e) in C:\Users\Ambit113\Desktop\SDATAContactTest\SDATAContactTest\Form1.cs:line 125

I am using Sage.SData.Clien.dll for this purpose and vervion is 1.1.0.1323

SalesLogix Version 7.5.3 with hotfix 1,2,3

Server: Windows 2008 R2

Please suggest some work around for this.

Thanks in Advance

Malay Mukherjee

[richardanderson]

Hi Malay,

Are there any errors on the web server's event viewer?

[Malay_Mukherjee]

Hi Rechard,

Thanks for your response. 

No nothing has been recorded in the event viewer log.

Regards

Malay Mukherjee

[Malay_Mukherjee]

Hi Richard,

As replied earlier, nothing has been recorded in server Event Log, but while checking IIS Log I have observed, following two entries there,

2013-09-03 11:52:07 127.0.0.1 PUT /sdata/slx/dynamic/-/Contacts('C6UJ9A002GBW') - 4444 - 127.0.0.1 - 401 2 5 1
2013-09-03 11:52:07 127.0.0.1 PUT /sdata/slx/dynamic/-/Contacts('C6UJ9A002GBW') - 4444 sdatauser 127.0.0.1 - 405 0 0 198

Regards

Malay Mukherjee

[Malay_Mukherjee · Accepted solution]

Hi All,

This is to inform you all that this problem is resolved by removing Webdav Publishing feature from IIS.

Thanks everyone.

Malay