-clearEventLog

Deletes all records in the EL_EVENT, EL_EVENT_PROCSNG_DATA, EL_EVENT_SRVC_FLW_PROCSNG_DATA, EL_EVENT_SERVICE_FLOW and EL_EVENT_LOG_MESSAGE event log tables. If you have not purged the event log in some time and a large amount of records have accumulated, you might not be able to delete event log records using Application Repository. You can use this command to clear the event log tables in that scenario.

Important: Before you run the renew -clearEventLog command, it is highly recommended that you stop the SBM Tomcat service first.

There are two ways to execute this command using the provided batch template files:

Run clearEL.bat:

installDir\SBM\Common\Misc\renew\renew_templates\clearEL.bat

This option clears the event log tables using the database credentials that are specified in:

installDir\SBM\Common\tomcat\server\default\conf\renew.properties

Run clearEL_dbCredentials.bat:
```
installDir\SBM\Common\Misc\renew\renew_templates\clearEL_dbCredentials.bat
```
This option clears the event log tables using the database credentials that are specified in the batch file.

Example output:

java -Dfile.encoding=UTF-8 -jar renew.jar -clearEventLog 
-dbUsername "sa" -dbPassword "password"

WARNING: This will permanently delete all Common Event Log data. Are you sure? [Y/N]:Y
Done.