We have recently started to run this process in our Purchasing group. It first runs PO_PO_005 to create a pdf of the purchase order and then PO_PO_Email which should find the pdf in a directory, attach it to an email and send to the vendor. The problem is that sometimes the process doesn't work. But only sometimes. An email will go to the vendor however there is no pdf attached. Anyone experienced this before?

Views: 3

Replies to This Discussion

Hi Cynthia
I'm not sure if this will help but I have found times in the past where two processes are in a job and run sequentially, although the first has finished (according to Process Monitor) it still had locks on some of the data at the database so the second process would only pick up some of the data. Our solution was to put a process between the two that just ran for a couple of minutes ensuring all the data was available for the second process. It may be the same here where the file is still being closed when the second process starts sometimes?
If the time between the one process finishing and the other starting is more than a minute this will probably not be the problem.
Let me know if this is the answer.
cheers
Matt

RSS

© 2012   Created by PSoftPros.

Badges  |  Report an Issue  |  Terms of Service