000031405 - MSSQL events are not parsed after installing Event Source Update (ESU) for RSA enVision

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000031405
Applies ToRSA Product Set: enVision
RSA Product/Service Type: enVision Core
RSA Version/Condition: 4.1 SP1
Platform: Windows
O/S Version: 2008 Server R2 Enterprise (64 bit)
 
IssueAll MSSQL events aren't parsed after installing the latest Event Source Update "ESU", although these events used to be parsed before the update.
Following logs observed in autoupdate.log "%envision%\logs"
 
ERROR 10 09 2015 16:34:54,804 %NIC-1-701015: AutomaticUpdate, GotsXmlMigrator, -, file, 20150820-132541/mssql_20150624-010435_v2, Detail: 1: date_time: 2015/09/10 16:34:54, package_id: 20150820-132541, patch_id: mssql_20150624-010435_v2, EventSource: mssql, Migration failed. Filename: mssql.xml
ERROR 10 09 2015 16:34:54,975 %NIC-1-701005: AutomaticUpdate, AutoUpdateMain, -, patch, 20150820-132541/mssql_20150624-010435_v2, Detail: 1: date_time: 2015/09/10 16:34:54, package_id: 20150820-132541, patch_id: mssql_20150624-010435_v2, failed.


 
CauseFailure in the event source update
Resolution1.    Stop all envision service by manually stopping the nic service manager service. 
2.    Copy the folder “mssql” and all sub items under it from “e:\nic\4100\SITENAME\update\content\etc\devices\” folder to “e:\nic\4100\SITENAME\etc\devices” and replace the current one. 
3.    Copy the file “mssql.xml” from “e:\nic\4100\EBCMAIN-ES\update\content\etc\devices\odbc\” folder to “e:\nic\4100\SITENAME\etc\gots” and replace the current one. 
4.    Restart envision services by manually restarting the nic service manager service.

Attachments

    Outcomes