Preview Tool

Cisco Bug: CSCze90399 - User Agent event_records table date format is wrong

Last Modified

Feb 26, 2018

Products (1)

  • Cisco Firepower Management Center

Known Affected Releases


Description (partial)

User Agent reports messages like this and you may not see any user ip mappings on the Defence center (Firesight)

 "2/24/2014 8:41:36 AM","warning","[0226] - Unable to write to log events: [INSERT INTO event_records (time, account, address_v4, address_v6, type,
ad_server) VALUES('24/2/2014 8:23:54 AM','DCPRD','','','machine','')]"

This happens when the time format on AD is in dd/mm/yyyy,

Related Community Discussions

User agent won't work: Error Unable to write to log event appears on Event Log
I've installed User Agent version 2.2 in an Windows 2008 Server to pooling our 2 AD server. Everything appears to be OK. The 2 servers appears as "available" in Polling Status column, and Sourcefire DC connection appears as "available" in Status column. But no user appears on Firesight Analysis->Users->Users. In Logs Tab, an error appears: "[0226] - Unable to write to log events: [INSERT INTO event_records ...". Screenshot attached.   Any ideas? I already tried 2.1.1 and 2.0 versions.
Latest activity: Jun 18, 2015
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.