I am developing a nightly batch process which will process CC's through Verisign, then update records as approved in order to release back orders which have had inventory replenished. The process is simple enough, though I need to ensure reliable recovery should something go wrong.
I'm looking for additional suggestions, or insight into the process which I may be missing. Here's my outline: 1) Query orders to be released 2) Write a text log of invoices which are expected to be processed (record count, row number, invoice ID, customer number, amount) 3) Send CC to Verisign, get approval for each transaction, write to log with row number, invoice ID, customer ID, verisign reference number 4) Update Database with approval info, write to log indicating db has been updated. 5) When ALL transactions have completed, mark log as completed, indicate approvals and denials, 6) Generate email sent to me and others indicating entire process was complete along with transaction statistics. The log is written AFTER each step in this process so that it can be reviewed to determine which invoice failed, and at what point it failed. Also, I will be wrapping this in TRY/CATCH with error reporting to provide further details. This should catch most errors that pop up (crabby DBA can't sleep and decides to do server maintenance in the middle of the night and shuts down server?) But there are those extreme occasions when CF simply restarts itself. Anyone else have these? TRY/CATCH won't catch this behavior. This is the thing that worries me most. I will have the log to show where a transactions fails, but in the event of a shut down, no other info. Am I worrying too much? Am I missing something? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
