I have a ReportCaster job that I am trying to build. I need a pre-processing job to run that will update a table within my db.

I then want to select the data and create the output.

After that I then need to update the table again to designate that the item has been printed.

I am getting the following error:

Starting worker thread
Starting task: Print Barcode
Task type: EDA RPC
Procedure name: sandbox/print_barcodes
Connecting to server EDASERVE with static execution id
Executing pre-rpc: update_pre
Executing focexec.
Executing post-rpc: update_post
Task error:[pcb101] Pcb2[Scb0.Stmt2.]: java.net.SocketException: Connection reset by peer: socket write error
No report to distribute.
Log report notification successfully sent to ...

Any ideas? I am wondering if the rc job executes each item in order?

Just an update,

I have been able to get everything working minus the pre-processing portion, where I update my mysql table using a simple pass-through query.

Thanks

I know at the beginning of RC...you could not count on which order the jobs executed..I do not know if that has changed in recent releases. I would try putting your 3rd step as post processing...or in another RC job that runs after you are sure this one is complete.