Thanks! You mentioned the older version, I should have been more specific:
ARS 6.3 Help Desk 6.0 MS SQL Windows Server 2003 On Sat, Mar 13, 2010 at 9:14 AM, Rabi Tripathi <[email protected]> wrote: > Joe, > I would look to see if there are any tables other than T and H associated > with this form and then, stop ARS and truncate the tables. As you mentioned. > > If you want to play safe, you can stop ARS, rename the T, H and any other > associated table, and create the T, H and associated (empty) table. If you > see issues after starting ARS, just get the old tables back. > > One last option is...actually the easiest one: delete the dist pending form > and restart ARS. It should be recreated automatically when ARS comes back. > When ARS starts, its designed to look for DSO license and on finding it, > create DSO related forms automatically, if any doesn't exist. > My DSO experience is with the older version...so you can check first to see > if there are any joins created on dist pending form. It will actually tell > you when you try to delete the form, if that's the case. With presence of a > join, it gets a little more complicated, so you can fall back to the table > removal. > > > On Fri, Mar 12, 2010 at 7:50 PM, Joe Castleman <[email protected]> > wrote: > > 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" > > > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

