000035709 - The job ECAT_CaptureLiveFeedbackMetrics fails with "Cannot insert the value NULL into column 'Name', table '@ConsoleServerMetrics'" in RSA NetWitness Endpoint

Document created by RSA Customer Support Employee on Dec 2, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035709
Applies ToRSA Product Set: NetWitness Endpoint
RSA Product/Service Type: NetWitness Endpoint
RSA Version/Condition: 4.3.x, 4.2.x, 4.1.x,
IssueThe 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.

CauseThis 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.
ResolutionThe permanent fix is to upgrade the server to RSA NetWitness Endpoint (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.
WorkaroundIt 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 will then cause the issue to return until the fix is applied again.
To request this hotfix please open a support case and reference this article.