function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
abivenkatabivenkat 

Salesforce integration with .Net

I am developing a .Net website to which i have integrated the salesforce using the WSDL file. I am getting an issue occasionally while trying the following.

1. I have an XML in the .net website where the SOQL queries resides. In the same XML file, i am having the Username, password and the security token of the SFDC org.
2. First up, i will read the login credentials from the XML file and login to the SFDC org.
3. After login, i will be fetching the SOQL query from the same XML file and trying to run the query in the salesforce to fetch a n number of rows.
4. While the query runs in the SFDC org, i am getting an error as below,

An unexpected error has occurred: There is an error in XML document (1, 1229).
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at WebReferences.SForceService.SforceService.query(String queryString) in 'my file path'
   at RowDI.DataReader.fGetData() in 'my file path'


Another important thing is, this application will be accessed by n number of users at the same time. It will run simulteanously and parallely. so, there can be chances where multiple users to login at the same time and fetch the query from XML file and get the records. This issue is occurring once for every 5 runs i.e,. occasionally occurring issue.

so is there anything that we are missing to do in this scenario? any ideas/suggestions will be very helpful and grateful to us asap, as this application is already in production environment.

 

Thanks

abivenkat

Ashish_SFDCAshish_SFDC

Hi abivenkat,

This use case is very interesting but not sure about the resolution, seems like .net application and Salesforce both are working fine but the issue lies with the xml file which has the login information.
Moreover, the error is observed exactly at 5th occurrence (or so) which in a way may be referring to some governor limit being hit in the background.
Please see the considerations in the link below,
http://www.salesforce.com/us/developer/docs/api/Content/implementation_considerations.htm
It might be the concurrent user login issue as well which may logout the initial user or hit a governor limit based on queries.
Please check the debug logs and the xml location (1, 1229). to find any more clues for this error.


Regards,
Ashish, Salesforce.com
If this post answers your question, please mark this post as Solved.