enter image description here

Im extracting data from salesforce using COzyroc SSIS component. This package is scheduled as job in MSSQL server which runs on daily basis.

This job failes on alternate days. One day it is executed successfully and another day it fails.

What might be the reason ? I have attached the error screenshot for your reference.

PLease someone help me

  • 1
    Is it possibly running into concurrent API limiting? help.salesforce.com/… Since it works some days, that indicates that the config is good, but perhaps it is running at the same time as something else some days and hitting the limit on those days. – Tony Hinkle Feb 13 at 11:40
  • The job execution time increases day by day. Day 1 -> 40 mins after several days 1 hr 30 mins. But the data count it fetches is the same. Is this the issue? If it is then how to resolve it??? – Rajaselvi Gunasekar Feb 13 at 12:04
  • 1
    There's no way for me to know for sure if it's the issue--you'll have to check the "API Usage box in the system overview page" when it occurs. If you are hitting the limit, you'll have to get it increased, or if it's truly just a the # of concurrent calls, run the job at a different time. help.salesforce.com/articleView?id=000175738&type=1 – Tony Hinkle Feb 13 at 12:30
  • The difference in load times could be due to activity on the destination table. There is too little information here to make an authoritative ruling. I suspect you have two issues. The first as @TonyHinkle has indicated, SF could be throttling your connection. The wildly variant run times are likely a combination of the volume of rows being returned, the operations performed on them between the SF source and the destination and locking/blocking activity on your destination. If you'd like to analyze the non-SF portion of the problem, you'll need to provide screenshots of the data flow – billinkc Feb 14 at 14:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.