i have create Site Workflow to get data from Oracle table to sharePoint List :
its published , when i click start button in the site workflow , its working fine for 5.Min then giving me error (( Workflow Faild to start)).
Please find logs that i have.
could you say how many cycles will be performed in the for each action? I've seen something similar in the past when the for each action was required to performance an high number of iterations..one of the solution was to put a pause on every 200/300 iteration (you can base the condition on index value, the number of iteration depends on the environment, so you have to find what is the right value for your situation), in that way the workflow will have a delay but it permits all the jobs to be executed without erroring.
Could you give it a try and tell us if the issue has been solved?