Hi,
There are some difference between the built in functionality and RRR|Chive.
The target archive form will have new fields to keep copies of the source
Entry Id, Creation Date, Modified By and Modify Date. If you want to mimic
the functionality of the built in archiving functionality with RRR|Chive
you must map these fields and some other settings:
transfertype = MOVE
fieldmapping = \
1 => 5368709xx, \
3 => 5368709xx, \
5 => 5368709xx, \
6 => 5368709xx
entryidmode = NEW
You should also get similar functionality with a filter instead of
fieldmapping. This will put the original entry-id into the entry-id-field
of the target archive form.
RRR|Chive will automatically disassociate the archive form from its parent
during the transfer, as you would not be allowed to import the records
otherwise. It will be reconnected after the transfer.
You can experiment with transfertype=COPY until you are satisfied that the
field mapping etc works. The MOVE will delete the source record when it
has successfully been created in the target form.
If you can get me access to a HP-UX server with a C++ compiler, I can
compile the newest version of RRR|Chive for your platform.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> HI Don,
>
> Thanks a Lot for your Inputs.
>
> This gives me a good confidence about the RRR|Chive tool.
>
> I think i am going to Run it from the Windows Client also, as i could not
> get the HP-UX version of RRR|Chive.
>
> Thanks,
> Viswa.
>
>
>
> On Fri, Aug 13, 2010 at 3:44 PM, McClure, Don <don.mccl...@unt.edu> wrote:
>
>> **
>>
>> Hi Viswa.
>>
>>
>>
>> One of the copy steps for us was moving ca 35K records from HPD: Help
>> Desk
>> (ITSM7) in approx 24 minutes (RRRchive, sync-to-target to populate new
>> system with data from production clone).
>>
>>
>>
>> This particular run was executed on Windows desktop; later usages are
>> run
>> from target server.
>>
>>
>>
>> Environment:
>>
>>
>>
>> ARS 7.1/ITSM7.0, on Win2003
>>
>> DB: MSSQL 2005 on Win 2003 (separate platform, not shared with other DB
>> users)
>>
>>
>>
>> Don W. McClure, P.E.
>>
>> CITC Call Tracking Administration
>>
>> University of North Texas
>>
>> dwmac @ unt . edu
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arsl...@arslist.org] *On Behalf Of *viswa kumar
>> *Sent:* Friday, August 13, 2010 11:32 AM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* RRR|Chive and AR Archiving
>>
>>
>>
>> **
>>
>> Hi,
>>
>>
>>
>> I wanted to Archive about 2000k Records from the ServiceRequest
>> form (Custom Ticketing form with 473 fields) that are created since year
>> 2000.
>>
>>
>>
>> When i tried with AR Archive functionality (Form Properties\Archive tab)
>> it
>> took about 3.5 Hrs for 30k records (around 110 Records\Min).
>>
>> If that is the Case i would need 570+ hrs to complete this Archive
>> Process.
>>
>>
>> If any of you have used RRR|Chive Already, Can i get some of this
>> questions
>> answered please:
>>
>>
>>
>> I think RRR|Chive tool could do this Archiving faster then AR Archive,
>> is
>> it true?
>>
>> Like to check with any of you used RRR|Chive for Archiving thousands of
>> records; Any Specific gotchas to note for ?
>>
>> What would be the rough expected Archive time for thousand Records(1k)
>> in
>> RRR|Chive for the form with 500 Fields?
>>
>> Is it good to run the RRR|Tool in the ARS Server ? or the Client side
>> like
>> ARS User?
>>
>>
>>
>> Any information about RRR|Chive tool will also helpful.
>>
>>
>>
>> Also, Is there any Tuning like (Tread size) can improve the AR Archive
>> Performance?
>>
>>
>>
>> I am trying to find a relatively easy way and get a rough Estimate
>> for Archiving 2000k records.
>>
>>
>>
>> THANKS in advance,
>>
>>
>>
>> Platform: ARS 7.0.01 P010
>>
>> OS : HP-UX
>>
>> DB : Oracle 10.2 64bit
>>
>>
>>
>> Thanks,
>>
>> Viswa.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>> _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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
