All, Due to some runaway workflow (which I've since disabled) I ended up with 2.5 million records in the Distributed Pending table. This is after manually whittling it down from 3.5 million, 10000 at a time, via the User client. Given the current transfer rate, it would take 10 days for the remaining queue to flush out by itself, assuming no connectivity problems (which I can't assume, but that's another problem).
Will it hurt anything to simply run a SQL statement "truncate table Txxx" (and "truncate table Hxxx") against the Distributed Pending form? I am afraid this wil cause 2.5 million "Fail" updates back to the source form, so I am thinking I should first stop AR Server. NOTE that I am not concerned about losing the pending DSO transactions (I am manually exporting the relevant source records, and importing them to the target server). Thanx in advance, Joe C. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
