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 <joe.castle...@gmail.com> 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"
