com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded

000029e5 DataStoreCont E com.ibm.wps.datastore.impl.DataStoreContext handleException EJPDB0099E: Error occurred during database access. Last SQL statement is [SELECT UNIQUE_ID, CREATED, MODIFIED, NAME, TYPE, LOGGED_OUT, LAST_LOGIN FROM release.USER_DESC WHERE (UNIQUE_ID = ? AND TYPE = ?)]. Transaction has status [STATUS_ACTIVE], global ID [0000013031c772210000000100068b30d17c6e28060142e650cd39de7f3c0101e72b7e670000013031c772210000000100068b30d17c6e28060142e650cd39de7f3c0101e72b7e6700000001] and local ID [428848].
                                 com.ibm.wps.util.DataBackendException: EJPDB0098E: Error occurred during database access. Transaction has status [STATUS_ACTIVE], global ID [0000013031c772210000000100068b30d17c6e28060142e650cd39de7f3c0101e72b7e670000013031c772210000000100068b30d17c6e28060142e650cd39de7f3c0101e72b7e6700000001] and local ID [428848].
    at com.ibm.wps.datastore.impl.DataStoreContext.handleException(DataStoreContext.java:339)
    at com.ibm.wps.datastore.impl.ResourcePersister.findInternal2(ResourcePersister.java:981)
    at com.ibm.wps.datastore.impl.ResourcePersister.findInternal(ResourcePersister.java:880)

Caused by: com.ibm.wps.util.DataBackendException: EJPDB0098E: Error occurred during database access. Transaction has status [STATUS_ACTIVE], global ID [0000013031c762520000000100068b22d17c6e28060142e650cd39de7f3c0101e72b7e670000013031c762520000000100068b22d17c6e28060142e650cd39de7f3c0101e72b7e6700000001] and local ID [428834].
    at com.ibm.wps.datastore.impl.DataStoreContext.handleException(DataStoreContext.java:339)


Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)



Solution # 1:
Restart the SQL Server services and Portal.

Solution # 2:
If that doesn't work then increase the Lock timeout settings from Admin console and then restart SQL Server services and Portal