I have been working on a job for a little while that is intended to take an xml file filled with "items" and move those items into a MySQL database. The xml file and MySQL database are both on the same server, and the job is run using an exported run.sh script on the server as well. The xml file to be the input is set using a reference in the context file "Default.properties" The problem i'm having is this: the job runs perfectly when I use a sample xml file (it's a mini version of the one I plan on using, with about 4 "items") but when the full file (which includes a couple hundred thousand items) is used as the input, it doesn't seem to work. Now, it isn't giving me any error messages, but when I check the database periodically to see how many rows have been copied, the COUNT(*) query returns zero every time. If any one has any ideas as to why this is happening, or how i could better monitor what actually IS happening, please post.
P.S. Here's some screenshots of the job (with private information missing of course - and no, those fields are not blank in the real job design).
P.S. Here's some screenshots of the job (with private information missing of course - and no, those fields are not blank in the real job design).