• Amine H
  • NEWBIE
  • 0 Points
  • Member since 2016
  • talendexpert.com

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies
Hi All,

We’ve experience connection timeout starting about couple of weeks ago. We use custom .NET application using Salesforce SOAP Web Services. We get timeout error now in regular basis but note that “NOT” every time we make connection to Salesforce. We ran code review to point where it makes a call to Salesforce Web Services and error returned there. Here’s the query we use:

Select Id, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, Delivery__c, Delivery_Remain__c, Products__c, Delivery_Pcs__c, Product_Name__c, Order_Reference__c, Line_No__c, Part_No__c, Quantity__c, FOC_Quantity__c, Discount_Code__c, Discount_Percent_1__c, Discount_Percent_2__c, Discount_Percent_3__c, Unit_Price__c, List_Price__c, Discount_Item__c,Discount_Item_2__c, Discount_Order__c, Net_Amount_2__c, Vat_Amount_2__c, DO_Percent__c, Location__c, FOC_Act__c, Price_Level__c, Discount_Code_1__c, Discount_Code_2__c, Discount_Code_3__c, Discount_Code_4__c, FOC_Code_1__c, FOC_Code_2__c, FOC_Code_3__c, FOC_Code_4__c, FOC_Quantity_1__c, FOC_Quantity_2__c, FOC_Quantity_3__c, FOC_Quantity_4__c, Planner_Code__c,Price_3__c  FROM Delivery_Line_Items__c  WHERE Order_Reference__c in ('SW43-36383','SW43-36381','SW32-36370','SW32-36361','SW54-36345','SW31-36377','SW32-36371','SW31-36378','SW32-36367','SW32-36362','SW35-36376','SW33-36387','SW56-36359','SW41-36373','SW35-36375','SW33-36393','SW33-36388','SW32-36364','SW61-36355','SW46-36354','SW33-36391','SW32-36369','SW56-36360','SW43-36380','SW33-36385','SW61-36356','SW46-36353','SW32-36365','SW41-36374','SW33-36389','SW43-36384','SW33-36386','SW33-36392','SW43-36379','SW32-36372','SW56-36357','SW52-36368','SW56-36358','SW33-36390','SW43-36382','SW33-36395','SW55-36396','SW24-36363','SW42-36366','SW33-36394')

Please do “not” get overwhelm on the query, it’s a simple select using “in” in the WHERE clause. The target table is “Delivery_Line_Items__c”. Note that, using this same query in “Force.com Explorer”, we now sometimes get error also.




Hi Guys,

Am posting json text data from google advanced rest api client,but it throws error like :503 Service Unavailable

It is the Data am giving : {"rewardamnt"="15000","active_or_inactive": "true"}

Content-Type :application/json

MY URL :https://quinnoxspm-developer-edition.na15.force.com/WebMethods/services/apexrest/RewardCreation

https://quinnoxspm-developer-edition.na15.force.com -->Force.com site URL

WebMethods-->Site Name

services/apexrest-->Common for apex rest resource

RewardCreation--->My controller having urlmapping.

We are having a strange issue with an integration we are writing around socket level timeouts. This is happening usually within a minute of the application running and doesn't appear to be a session management issue. This is happening while doing a series (sometimes as few as 70) of small SOQL queries (each returns one row) that happens at the beginning of the application.

We are seeing this exception:

java.net.ConnectException: Connection timed out: connect
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.ConnectException: Connection timed out: connect
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

This is using JDK1.5.0_01 and Axis 1.2.1. and going against a trial version account that was upgraded to EE

Has anyone seen this or have any ideas of what may be causing the issue? Since itis an Axis/Java exception we are going to try various combinations of JVM's and Axis levels to see if that resolves it.

Any ideas or thoughts would be appreciated!

Thanks,

John