The job ECAT_CaptureLiveFeedbackMetrics is consistently failing with the error message below.
Cannot insert the value NULL into column 'Name', table '@ConsoleServerMetrics'; column does not allow nulls. INSERT fails.
[SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
This is due to attempting to merge a NULL value into the table ConsoleServerMetrics as NULL values are disallowed in column Name. This causes a SQL error to be thrown, failing the attempted job.
The permanent fix is to upgrade the server to RSA NetWitness Endpoint 220.127.116.11 (when available) where the permanent fix is incorporated into the agent job ECAT_CaptureLiveFeedbackMetrics. See the agent job ECAT_CaptureLiveFeedbackMetrics workaround below for a specific workaround.
It is possible to perform a workaround by running the script from FIX_ECATCE-714.zip, which is obtained from RSA Customer Support. This should be done in its own support case to ensure the job is updated correctly by RSA Customer Support with Engineering's approval. It is important to note these changes will be overwritten on upgrade, and any attempt to upgrade to a version earlier than 18.104.22.168 will then cause the issue to return until the fix is applied again.