Uploaded image for project: 'RH-SSO'
  1. RH-SSO
  2. RHSSO-1510

[GSS][7.2.z] updating execution with Oracle DB causes unique constraint (DBALLO00.CONSTRAINT_AUTH_CFG_PK) violated

    XMLWordPrintable

Details

    • 3
    • Workaround Exists
    • Hide

      Delete and recreate the config of the execution

      Show
      Delete and recreate the config of the execution
    • Hide

      1) Unzip the RH-SSO server and setup Oracle database.
      2) Setup the admin user and login
      4) Click on Authentication tab
      5) Copy Browser flow
      6) Add "Conditional OTP Form" execution to the copyied flow
      7) Configure the execution with "test" as Alias and OTP control User Attribute . Use "skip" for "Fallback OTP handling". Save.
      8) Configure it again and modify the OTP control User Attribute to "test123" and Save again.

      In response to step 8, you get a red toast notification box that says " Error! An unexpected server error has occurred " and log showing constraint violation

      Show
      1) Unzip the RH-SSO server and setup Oracle database. 2) Setup the admin user and login 4) Click on Authentication tab 5) Copy Browser flow 6) Add "Conditional OTP Form" execution to the copyied flow 7) Configure the execution with "test" as Alias and OTP control User Attribute . Use "skip" for "Fallback OTP handling". Save. 8) Configure it again and modify the OTP control User Attribute to "test123" and Save again. In response to step 8, you get a red toast notification box that says " Error! An unexpected server error has occurred " and log showing constraint violation
    • Keycloak Sprint 11, Keycloak Sprint 12, Keycloak Sprint 13

    Description

      Trying to modify an existing execution in an authentication flow gives a database constraint error only on Oracle database. It doesn't occur on the h2 database.

      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DBALLO00.CONSTRAINT_AUTH_CFG_PK) violated

      The issue appears to be that different SQL is run depending on database and Oracle will do both an update and insert. Attaching log with full error and with show SQL enabled.

      Attachments

        Activity

          People

            vramik@redhat.com Vlasta Ramik
            rhn-support-cdolphy Chris Dolphy
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: