Cisco Bug: CSCsy98319 - Client unable to get data from server due to activity lock
Nov 11, 2016
- Cisco Security Manager
Known Affected Releases
Symptom: 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. Conditions: 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 Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases