1 . 使用arcsight 使用者登入.
2. 進入 /opt/arcsight/logger/current/arcsight/bin 執行
./mysql -u arcsight -p
3. 輸入 arcsight 密碼.
4. 執行
use arcsight;
5. 在 mysql> 執行:
show table status like 'arc_not%';
Output 出現如下:
arc_notification_history | InnoDB | xx| Compact | 3461124 | xxx| 387350528 | ...
arc_notification_registry | InnoDB | xx| Compact | 1671599 | xxx| 1534590976 | ...
Note: The size of the arc_notification_registry above is 1,534,590,976 (1.5GB) and it has 1,671,599 rows. These are large values for this table.
6. Truncate the tables, as follows:
a. 將Manager 服務 stop，/etc/init.d/arcsight_services stop manager.
b. Enter the following commands at the mysql> prompt. If necessary, login again by repeating Steps 1-4 above.
set foreign_key_checks=0;
truncate table arc_notification_history;
truncate table arc_notification_registry;
set foreign_key_checks=1;
exit
7. 重啟Manager(Start the Manager).
8. 重新登入Console(Login to the Console).
參考:https://community.microfocus.com/cyberres/arcsight/f/arcsight-discussions/344782/manager-license-is-not-valid/924818#924818
