Seems fine. If you manually run the job for the subplan does the step still fail? You may have to run a trace to see what is going on during that time and where you are getting your error.