Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-1979

Crowd fails to add sequential LIST_INDEX numbers to table CWD_USER_CREDENTIAL_RECORD

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 2.6.2
    • 2.0.1, 2.0.3, 2.6.1
    • Authentication / Security

    • MySQL 5.X and Oracle 10.X

      Crowd fails to add sequential LIST_INDEX numbers to table CWD_USER_CREDENTIAL_RECORD, setting the index to zero even if the user already has an entry, causing user deletion to fail.

      ID, USER_ID, PASSWORD_HASH,                                                                           LIST_INDEX
"1","301015",7OXgRqJd6rgCcT0ZVGKYrYEJHA3CfIo9AuD79jbrSvIKIYt8p2fq0w7jR8UD+cCKoIKcou6md/gJQvXORbDArQ==,0
"2","301015",tG2gS45XeU2Brt3LgpS2/fd0uWx5DZ7fjxCLNHQlQ4NUg1wBRO0RVf3cWtG8kO5QY8M6I/niq4oY/tA+nmpJ7Q==,0
"3","301015",7OXgRqJd6rgCcT0ZVGKYrYEJHA3CfIo9AuD79jbrSvIKIYt8p2fq0w7jR8UD+cCKoIKcou6md/gJQvXORbDArQ==,0
"4","301015",tG2gS45XeU2Brt3LgpS2/fd0uWx5DZ7fjxCLNHQlQ4NUg1wBRO0RVf3cWtG8kO5QY8M6I/niq4oY/tA+nmpJ7Q==,0

      2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000
2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-02292: integrity constraint (CROWD_PROD_USER.FK_USER_CRED_USER) violated - child record found

2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

            [CWD-1979] Crowd fails to add sequential LIST_INDEX numbers to table CWD_USER_CREDENTIAL_RECORD

            Renata Dornelas made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 159601 ]
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1510926 ] New: JAC Bug Workflow v3 [ 3365545 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1392379 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1510926 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 273692 ] New: Simplified Crowd Development Workflow v2 [ 1392379 ]
            Joe Clark made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 159601 ] New: This issue links to "Page (Atlassian Documentation)" [ 159601 ]
            Joe Clark made changes -
            Remote Link New: This issue links to "Page (Atlassian Documentation)" [ 159601 ]
            Diego Berrueta made changes -
            Remote Link New: This issue links to "Wiki Page (Extranet)" [ 40258 ]
            Diego Berrueta made changes -
            Fix Version/s New: 2.6.2 [ 31890 ]
            Resolution New: Fixed [ 1 ]
            Status Original: Technical Review [ 10028 ] New: Resolved [ 5 ]
            Diego Berrueta made changes -
            Status Original: In Progress [ 3 ] New: Technical Review [ 10028 ]
            Diego Berrueta made changes -
            Affects Version/s New: 2.6.1 [ 30697 ]

              dberrueta Diego Berrueta
              rbattaglin Renan Battaglin
              Affected customers:
              3 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: