Siteminder WAMUI deallock sql error

book

Article ID: 102998

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) AXIOMATICS POLICY SERVER CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On

Issue/Introduction

We're running an AdminUI and this one stopped to work. When we start it 
over, it refuses to start. 

Below is the deallock sql error we get in the server log for the AdminUI.

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

How can we fix that ?

Cause

The AdminUI cannot start correctly because of the error "Stream or LOB 
value cannot be retrieved more than once" : 

server.log : 

2019-05-10 09:12:33,558 INFO 
[org.apache.coyote.http11.Http11Protocol] (main) Initializing Coyote 
HTTP/1.1 on http-0.0.0.0-8080 

2019-05-10 09:12:33,803 INFO 
[org.apache.coyote.http11.Http11Protocol] (main) Initializing Coyote 
HTTP/1.1 on http-s00vl9943165.fr.net.intra%2F10.244.163.81-8443 

2019-05-10 09:12:38,067 WARN 
[org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException 
caught, SQLState XCL18 code:20000- assuming deadlock detected, try:1 
java.sql.SQLException: Stream or LOB value cannot be retrieved more 
than once 

Caused by: java.sql.SQLException: Stream or LOB value cannot be 
retrieved more than once 

2019-05-10 11:21:02,474 ERROR 
[org.jboss.kernel.plugins.dependency.AbstractKernelController] 
(main) Error installing to Start: 
name=jboss.messaging.destination:name=iam.siteminder.jms.queue.com.netegrity.ims.msg.queue,service=Queue 
state=Create mode=Manual requiredState=Installed 
java.lang.IllegalStateException: Failed to execute transaction 

2019-05-10 11:21:02,540 ERROR 
[org.jboss.kernel.plugins.dependency.AbstractKernelController] 
(main) Error installing to Real: 
name=vfsfile:/applis/11038-wbsso/siteminder/adminui/server/default/deploy/iam_siteminder.ear/ 
state=PreReal mode=Manual requiredState=Real 
org.jboss.deployers.spi.DeploymentException: Error deploying: 
jboss.messaging.destination:service=Queue,name=iam.siteminder.jms.queue.com.netegrity.ims.msg.queue 

Caused by: java.lang.IllegalStateException: Failed to execute 
transaction 

2019-05-10 11:21:02,568 ERROR 
[org.jboss.system.server.profileservice.ProfileServiceBootstrap] 
(main) Failed to load profile: Summary of incomplete deployments 
(SEE PREVIOUS ERRORS FOR DETAILS): 

DEPLOYMENTS IN ERROR: 

Deployment 
"vfsfile:/applis/11038-wbsso/siteminder/adminui/server/default/deploy/iam_siteminder.ear/" 
is in error due to the following reason(s): 
java.lang.IllegalStateException: Failed to execute transaction 

The first error "Stream or LOB value cannot be retrieved more than 
once" is related to the Derby internal database : 

Apache Derby 10.6.1.0 Release 
http://db.apache.org/derby/releases/release-10.6.1.0.html 

Environment

12.52 SP1
Windows or Linux

Resolution

You will needed to stop the AdminUI service, rename the following path \<adminui_install_path>\server\default\data\derby\default and then start the AdminUI.

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