Layer 7 Access Management

Tech Tip : CA Single Sign-On : Siteminder WAMUI deallock sql error

  • 1.  Tech Tip : CA Single Sign-On : Siteminder WAMUI deallock sql error

    Posted 05-13-2019 04:33 AM

    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