Issue:
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 ?
Environment:
12.52 SP1
Windows or Linux
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
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.
KB : KB000102998