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 -
This topic has been locked.
3 replies Latest Post - 2012-06-18T14:57:02Z by troubleshooter
Pinned topic Large Data Loads on WMC receiving timeout errors
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-18T14:57:02Z at 2012-06-18T14:57:02Z by troubleshooter
troubleshooter 270005EE9E1 PostACCEPTED ANSWER
Re: Timeouts2012-06-18T14:57:02Z in response to SystemAdminHey Jaime
Hw r u I am having similar issue connecting to DB2 i have tried custom parameters like
but stil I couldnt able to execute a query on DB2 As/400 it says login time out
[Oracle JDBC Driver]Execution timeout expired2011-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