RSA 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
During 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".
This is caused by a setting in the SQL database to send notifications via email but without configuring this properly.
Have 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.
There is no way to workaround this issue until the error is resolved.