The Partition Archiver Failed to execute the command "Reactivate Partition"

[manojs]

Hi,

In the past we tried to reactivate archived partitions in our ESM ver 5.0.2 but due to space constraints we were unable to achieve that task. Now the problem is we keep getting warnings on daily basis that command has failed with a warning.

The Partition Archiver Failed to execute the command "Reactivate Partition".

It seems like command is stuck in a loop and it run every day. Is there any way we can stop this command to be executed ??

[manojs · Accepted solution]

Found solution for this

Partition Archiver keeps trying to reactivate the selected partitions.

To stop the Partition Archiver's cycle, perform the following steps:

1. 1. Open a command line window on the Database Server and log in as the owner of the database software (on Windows it isadministrator, on UNIX it's oracle by default).
2. 2. At the prompt, change directory to <ARCSIGHT_HOME>/bin folder.
3. 3. Generate a PartitionInfo.log file and open it in an editor.
4. 4. Go to the following section of the file:

Status: Getting partition reactivation errors ...

1. 5. Note the partition names for which the error messages are generated.

For Example:In the following example, the 20090619 and 20090724  are the partitions for which the error messages are generated:

NAME       ACT ARC ARCHIVE_TYPE                                                                                                                                                                        
---------- --- --- -------------                                                                                                                                                                  
REACT                                                                                                                                                                                                  
----------------------------------------------------------------------------------------------------------------------------
DESCRIPTION                                                                                                                                                                                            
------------------------------------------------------------                                                                                                                                           
20090619   NO  YES ZIP                                                                                                                                                                                 
ARCHIVE FILE NOT FOUND                                                                                                                                                                                 
[Wed Dec 14 10:56:52 PST 2009] Reactivate Partition: ARCHIVE                                                                                                                                           
FILE NOT FOUND                                                                                                                                                                                        
                                                                                                                                                                                                       
20090724   NO  YES ZIP                                                                                                                                                                                 
ARCHIVE FILE NOT FOUND                                                                                                                                                                                 
[Tue Dec 15 11:41:37 PST 2009] Reactivate Partition: ARCHIVE
FILE NOT FOUND

1. 6. Stop the Manager Service to ensure that the tables you are updating are not locked for read/write.
2. 7.  SQLPLUS to the Database as an arcsight user.
3. 8. At the SQL prompt, execute the following SQL statement:

update arc_partition set reactivation_status = NULL where id in (select id from arc_resource where name in ('YYYYMMDD','YYYYMMDD'));
update arc_partition_shadow set reactivation_status = NULL where id in (select id from arc_resource where name in ('YYYYMMDD','YYYYMMDD'));
commit;
exit;

For the YYYYMMDD, substitute the dates you found in step 3 and put those in the list

Example:

update arc_partition set reactivation_status = NULL where id in (select id from arc_resource where name in ('20090619','20090724'));
update arc_partition_shadow set reactivation_status = NULL where id in (select id from arc_resource where name in '20090619','20090724'));