Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009
Accepted Solution

Issue with Application that consumes sdata

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

Highlighted
Nickel Contributor
Posts: 59
Registered: ‎07-30-2010

Re: Issue with Application that consumes sdata

Hi Malay,

 

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

Richard Anderson
CRM Consultant
K3 CRM
Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Re: Issue with Application that consumes sdata

Hi Rechard,

 

Thanks for your response. 

 

No nothing has been recorded in the event viewer log.

 

Regards

Malay Mukherjee

Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Re: Issue with Application that consumes sdata

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

Nickel Elite Contributor
Posts: 86
Registered: ‎10-21-2009

Re: Issue with Application that consumes sdata

Hi All,

 

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

 

Thanks everyone.

 

Malay