Siteminder WAMUI deallock sql error

Document ID : KB000102998
Last Modified Date : 21/06/2018
Show Technical Document Details
Issue:
Siteminder WAMUI is inaccessible for our environment.
Below is the deallock sql error we get in the server log for the WAMUI.

13:56:03,292 WARN [JDBCSupport] Trying again after a pause
13:56:03,552 WARN [JDBCSupport] SQLException caught, SQLState XCL18 code:20000- assuming deadlock detected, try:2 java.sql.SQLException: Stream or LOB value cannot be retrieved more than once
Environment:
12.52 SP1
Windows or Linux
Cause:
The Derby database has been corrupted and needs to be re-created.
Resolution:
You will needed to stop the WAMUI service, rename the following path \<adminui_install_path>\server\default\data\derby\default and then start the WAMUI.

You should now be able to access the WAMUI and manage objects.