Preview Tool

Cisco Bug: CSCsy98319 - Client unable to get data from server due to activity lock

Last Modified

Nov 11, 2016

Products (1)

  • Cisco Security Manager

Known Affected Releases


Description (partial)


The user gets an "Unable to get data" message with an SQL error informing that ACTIVITY_TABLE is locked in the database, when he tries to login to CSM server  and if he opens the "Activity Manager" (in work flow mode), no activity is shown.


This is a very rare case and has happened only once in our testing. The problem happened while a long "Approve" operation with hundreds of devices discovered in the activity was going on and because of some reason the session got invalidated and the Database locks on activity tables did not get freed up for the invalidated session. When another session was started, since the locks were still locked by the previous session, the user got the error message and the activities did not get shown in the activity manager.
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.