Topic
3 replies Latest Post - ‏2012-06-18T14:57:02Z by troubleshooter
SystemAdmin
SystemAdmin
224 Posts
ACCEPTED ANSWER

Pinned topic Large Data Loads on WMC receiving timeout errors

‏2010-01-15T13:50:38Z |
 I'm loading @10K to 100K records at a time from SqlServer 2000 to SalesForce.com.  My projects pull 20 records at a time and loop through the database tables, but the projects are crashing on the WMC at random times.  Sometimes the project will make it through 1000 records, sometimes up to 10K but always crashes with different errors such as the following:
Salesforce.com returned an unexpected error: java.net.SocketException: Connection reset
Exception processing SingleTableNotification Job.Data error at row number 0 of table sysdba.CONTACT. The Error is SQLSTATE: HYT00 ERRORCODE: 0 Error Message: CastIron SystemsSQLServer JDBC DriverExecution timeout expired.
Does anyone have any help on best practices for long running data loads or any help with the error messages?  Thanks so much -
 
Updated on 2012-06-18T14:57:02Z at 2012-06-18T14:57:02Z by troubleshooter
  • SystemAdmin
    SystemAdmin
    224 Posts
    ACCEPTED ANSWER

    Timeouts

    ‏2010-01-15T22:57:48Z  in response to SystemAdmin
    Kelly,
    Try to optimizing the Salesforce query that is timing out. 
    Regards,
    jdelgado
     
    • troubleshooter
      troubleshooter
      1 Post
      ACCEPTED ANSWER

      Re: Timeouts

      ‏2012-06-18T14:57:02Z  in response to SystemAdmin
      Hey Jaime

      Hw r u I am having similar issue connecting to DB2 i have tried custom parameters like

      logintimeout
      webshpereisolationLevel

      but stil I couldnt able to execute a query on DB2 As/400 it says login time out

      Rgds
  • SystemAdmin
    SystemAdmin
    224 Posts
    ACCEPTED ANSWER

    [Oracle JDBC Driver]Execution timeout expired

    ‏2011-05-10T18:55:25Z  in response to SystemAdmin

    I ran into the same problem. The Error is SQLSTATE: HYT00 ERRORCODE: 0 Error Message: CastIron SystemsOracle JDBC DriverExecution timeout expired.Based on the error DB execution times out.  Are there any JDBC execution settings that can be set which might resolve this issue. The response time from SFDC or SFDC connector is out of our control.thanksAnna