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"

Reply via email to