I had configured the archive process to delete the master record after it was archived. Some years back I had created a filter on the master table (schema) which sent an email notification when a record was deleted, this filter on the master record caused the archive to fail - when I disabled the filter the archive completed. This problem has been reported to BMC support - I'm not sure at this point if it is viewed by BMC as a bug. On one hand I really didn't want to get 89k email notifications that 89k records were being deleted after the archive process so I'm glad the archive process failed until the filter was disabled but at the same time I guess it could be possible that a filter that executes on delete may be needed.
Br, Russ From: [EMAIL PROTECTED] To: [email protected] Subject: Archive Process Date: Wed, 24 Sep 2008 13:55:43 -0700 Greetings ARList! My first attempt at using the native archive process. When configuring the archive process I allowed the ARSystem to generate the archive form. When the process runs one record is moved form the source to the destination (archive) form and the process stops. Every time it runs only one record is moved, I need to move 89k records so obviously this is not working too well. I was able to grab an error from the arerror log: Wed Sep 24 07:15:00 2008 Archive : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Wed Sep 24 07:15:00 2008 Timestamp: Wed Sep 24 2008 07:15:00.7730 Thread Id: 744 Version: 7.1.00 Patch 001 200711161033 Nov 16 2007 11:35:23 ServerName: remedy Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 0 RPC Call: 0 (DE) RPC Queue: 1 Protocol Version: 13 Client IP Address: Form: remedyform Logging On: Code: c0000005 Operation: read Access Addr: 0000005C Stack Begin: Stack End Any assistance would be appreciated. Remedy support has me doing the standard patch upgrade although it is not clear that will solve anything. Russ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
