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

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

    Timeouts

    ‏2010-01-15T22:57:48Z  
    Kelly,
    Try to optimizing the Salesforce query that is timing out. 
    Regards,
    jdelgado
     
  • SystemAdmin
    SystemAdmin
    224 Posts

    [Oracle JDBC Driver]Execution timeout expired

    ‏2011-05-10T18:55:25Z  

    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 
  • troubleshooter
    troubleshooter
    1 Post

    Re: Timeouts

    ‏2012-06-18T14:57:02Z  
    Kelly,
    Try to optimizing the Salesforce query that is timing out. 
    Regards,
    jdelgado
     
    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