MSSQL events are not parsed after installing Event Source Update (ESU) for RSA enVision
3 years ago
Originally Published: 2015-10-01
Article Number
000059426
Applies To
RSA 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)
 
Issue
All 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.



 
Cause
Failure in the event source update
Resolution
1.    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.