000033584 - RSA NetWitness Endpoint Installation Failure: Database add/drop fails

Document created by RSA Customer Support Employee on Aug 2, 2016Last modified by RSA Customer Support on May 6, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033584
Applies ToRSA Product Set: RSA NetWitness Endpoint
RSA Version/Condition: 4.1.x, 4.1.2, 4.2.x, 4.3.x, 4.4.x
Platform: Windows
O/S Version: Server 2012 R2
IssueDuring a new installation or attempting to reinstall the RSA NetWitness Endpoint service, the database gives error messages similar to the following:

>An exception occurred while executing a Transact_SQL statement or batch.
>At least one of the following parameters must be specified. "@body, @query, @file_attachments, @subject".
(Error 14524)


CauseThis is caused by a setting in the SQL database to send notifications via email but without configuring this properly.
ResolutionHave the customer contact their DBA to remove triggers in SQL database settings to send notification emails when a database is added/removed from the system. This is a reporting mechanism and causes the RSA NetWitness Endpoint installer to send errors when attempting to replace, create, or remove an existing database.

Note: You may see a database created during this process but the installer never complete and the tables not properly formatted. It is recommended to clear the error first, then delete the existing database if a new one is created.
WorkaroundThere is no way to workaround this issue until the error is resolved.