How to manually delete SAP B1 Events from SEVT table

[former_member576093]

Hello World,

I need the steps to delete B1 events from the SEVT table manually as there are 1000+ events set in the SEVT table which are not useful. I am having an issue processing the RFQ function from the SAP B1 HANA client.

Version - SAP B1 9.3 PL09 for HANA

Note - Is there any known issue related to RFQ in the above-mentioned version, do comment.

[fdvicente]

Hi Shivam

You'll need to use a SQL Statement to delete these event records.

Perform a backup of the SBOCOMMON DB and afterwards delete all unnecessary events.

If all events can be deleted safely with no impact, you can schedule some downtime on the SAP Business One server with no users working, stop the Event Sender service, use a command such has:

TRUNCATE TABLE SBOCOMMON.SEVT;

And afterwards restart the event sender service.

Best regards,

Filipe Vicente

Product Support - SAP Business One

SAP Support