I'm not sure what you mean by "data pump chokes on the projects that are skipped".
/b[/quote]I mean the Process completes with errors. All of the necessary exports were completed, however a SystemAlertDistributionError is raised, which means I recieve an email.
If an input is not present then the log should report "No inputs exist for project ID x. Exporting for this project has been skipped."
/b[/quote]I agree, but the messages I included in the post from the log indicate that:
-AgentInforce-RO-A.txt does not exist and has been ignored
-No inputs exist for project ID 1. Exporting for this project has been skipped
-Could not find file AgentInforce-RO-A.txt.
-Distribution completed with errors
I guess when you say Exporting for this project has been skipped, this does not mean the input distributions will be skipped. Still, it is odd that deleting a file that does not exist causes no problems, but moving a file that does not exist does.
When you changed the input distribution from Delete to Move did you enable one of the options (overwrite, rename, change extension)to handle files with the same name? If not then this would result in a "Distribution completed with errors" message.
/b[/quote]Yes, I renamed the file and had overwrite checked.
Did the project that had the input file complete successfully?
I set up a Process with multiple projects and input criteria similar to what you describe and it runs without a problem.
/b[/quote]If you have a process with mulitple processes with an input distribution of move to a different folder where one (but not all) of the processes can execute at once I'd be interested to know the settings you used. Is there a recommended way to share the settings of processes or projects?
Thanks for all your help!
Security really shouldn't be an issue since the Data Pump service runs with administrator priviliges.
I created fresh models, projects, and processes using the C: drive instead of a networked drive. There were only two projects. In each case, when one input file was present, the other project would try to perform its input distribution and the process would fail. If you like I could send the test files, projects, models, and the process and you could see if you have the same results.