Kinetic 2021.1.9 (11.1.100.9)
We are not using Epicor Social or Collaboration. We needed to manually add the SQL job CapureLogCleanUp to run nightly.
My question: Tens of thousands of records are written to this log daily. Mainly from SysRptLst and several _UD tables. How can I turn off logging completely to the CaptureLog table?
Have look at the table CDC.CaptureStatus. This table contains 0 or 1 rows per table in the database. If there is no row, or the value of the CaptureEnabled field is zero then changes to the table in question are not written to the CaptureLog table.
The cdc.CaptureStatus table is empty. Epicor confirmed this is a bug with 11.1.100.9 and recommended upgrading to 11.1.100.21. We found out that we can disable the trigger on the tables updating the cdc.CaptureLog.
Erp.Table_UD > Triggers
TR_xxxxxx_UD_ChangeCapture
I think I discovered recently that another thing that sets up and uses the cdc.CaptureLog is if you do Incremental updates to your Epicor EnterpriseSearch, at least in Kinetic 2022.2