Problem with Ticket Archiving

[RichH]

Hi,

I set Core::Ticket/Ticket::ArchiveSystem to 'Yes', then created a Generic Agent Job with the following:

Ticket Filter: Closed Times: Before 60 days
Ticket Action: Archive Selected Tickets: Archive Tickets

When I save the job, it says that 268,137 tickets will be affected, which is about what I would expect. I then ran the job.

When I use a SQL query to check it returns only 4000 tickets:
Select * from ticket
Where archive_flag = 1

I double checked using the OTRS search function and found that only the 4000 tickets returned from the SQL query were archived. These are tickets that were closed from 7/24/15 back to 7/14/2015. No earlier tickets were archived.

When I wait about an hour, then rerun the job, only about 17 more tickets are archived.

How can I get this job to archive all 268,137 tickets?

Selecting a date range works, but I'd like to leave this as an automated job (Closed Times: Before 60 days) and would like to know that it will work correctly.

Thanks!

OTRS Version: 3.1.3
OS: Window Server 2008 R2 SP 1
Database: MS SQL Server 2008 R2
Perl Version: Strawberry Perl 5.12.3.0

[wurzel]

Hi,

the Generic Agent has a limit per run (1000? or 5000?) You need to run Generic Agent more often.


And you should update to latest version
and you should switch to linux.

Flo

[RichH]

Thanks.

I figured out that there was a 4000 ticket limit and did the initial archiving by selecting a date range that archived <4000 at a time. I had to do this many many times. Ugh! Now I've set the job to run every night so it will never approach the 4000 ticket limit.

I'm in the process of running the 3.1->3.2->3.3 upgrade on a copy of our OTRS server in an isolated lab. Once that's doen, I'll take a look at the 3.3->4.x upgrade/migration to Linux.