The content you are looking for has been archived. View related content below.
Windows Machine throws exception when opened from machine View/Modules Summary tab (L2Analyst or L1Analyst) in RSA ECAT
RSA Product Set: ECAT, NetWitness Endpoint RSA Version/Condition: 22.214.171.124, 126.96.36.199, 4.2.x, 4.3.x, 4.4.x Platform: Windows O/S Version: 2008 Server R2, 2012 Server
Unhandled exceptions are being thrown when attempting to access the Modules Summary tab if they do so using the ECAT User L1 Analyst or L2 Analyst user permissions.
After upgrading from ECAT 188.8.131.52 or 184.108.40.206 to any higher version, an unhandled exception is thrown if an L2 Analyst or L1 Analyst user clicks on an item in the Modules Summary tab.
This is because for ECAT 220.127.116.11 and 18.104.22.168, the Linked Servers were created as “@srvproduct = N'MSSQL', @provider = N'SQLNCLI',” which have been changed post 22.214.171.124 to “@srvproduct=N'MSSQL_NATIVE_CLIENT', @provider=N'SQLNCLI'.”
After upgrading from ECAT 126.96.36.199 or 188.8.131.52, do the following:
On the ECAT Primary Server, extract the existing LinkedServer connection as follows: In SSMS, connect to your server instance > Server Objects > LinkedServers > XXX (Linked Server of the Primary Server as well as Linked Server of any Secondary Servers) > right-click and select Script Linked Server As > Create To > New Query Window > Save this file.
On the ECAT Primary Server, drop the linked servers for Secondary if the srvproduct is “MSSQL” (this can be checked in the script generated in step 1). Do this for both the linked servers if using multi-server configuration.
Execute the following script on the ECAT Primary Server, by providing the details of the Secondary Server: