000022050 - Error: 'SQLException : Code:1205 - encountered a deadlock situation' in RSA ClearTrust

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

Article Content

Article Number000022050
Applies ToRSA ClearTrust 5.0.1
Sun Solaris 2.8
Sybase
IssueError: "SQLException : Code:1205 - encountered a deadlock situation" in RSA ClearTrust
RSA ClearTrust EServer.log shows the following:

sirrus.da.exception.DataStoreException: Database Exception : (updateUser), SQLException : Code:1205;TextYour server command (family id #0, process id #95) encountered a deadlock situation. Please re-run your command.
CauseRSA ClearTrust database was set to lock at the page level. A secondary database that works hand-in-hand with the ClearTrust database was locking at the table level.
ResolutionTo correct this issue, set the RSA ClearTrust database locking to row-level locking and the secondary database to page level locking. For more information, visit the following URL:

http://www.openadaptor.org/javadocs/1_6_0/org/openadaptor/adaptor/util/JdbcConnectionParams.html
Legacy Article IDa26574

Attachments

    Outcomes