Problem

In some production environment, there is millions of rows in tables ALERTS and ALERTSPERSISTEDALERTS.

Resolution

These tables could be purged during maintenance window with SQL command TRUNCATE.

1) Stop B2Bi

2) truncate table alerts;

3) truncate table alertspersistedalerts;

4) Start B2Bi

5) select count(*) from alerts;

6) select count(*) from alertspersistedalerts;