Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-353

Saving a user fails due to duplicate user properties

    XMLWordPrintable

    Details

      Description

      I edit an existing user and click save. I am using Chrome as my browser. Looks like maybe it is doing an insert for user properties when it should be doing an update.

      Error code: N1-E10
      Date and time: 9/13/12 9:33 AM
      Additional information: -
      Last business path: http://hedrickbt-w510:20041/olat/url/UserAdminSite/0/usearch/0/table/0
      Business path: http://hedrickbt-w510:20041/olat/url/UserAdminSite/0/usearch/0/table/0/Identity/229377

      Call Stack
      09:26:11,314 DEBUG SQL:111 - insert into olat.o_plock (version, creationdate, asset, plock_id) values (?, ?, ?, ?)
      09:26:11,317 DEBUG SQL:111 - update olat.o_user set version=?, creationdate=?, language=?, fontsize=?, notification_interval=?, presencemessagespublic=?, informsessiontimeout=?, receiverealmail=? where user_id=? and version=?
      09:26:11,321 DEBUG SQL:111 - insert into olat.o_userproperty (fk_user_id, propname, propvalue) values (?, ?, ?)
      09:26:11,322 DEBUG SQL:111 - insert into olat.o_userproperty (fk_user_id, propname, propvalue) values (?, ?, ?)
      09:26:11,331 WARN JDBCExceptionReporter:100 - SQL Error: 1, SQLState: 23000
      09:26:11,332 ERROR JDBCExceptionReporter:101 - ORA-00001: unique constraint (OLAT.SYS_C0032396) violated

      09:26:11,335 ERROR AbstractFlushingEventListener:324 - Could not synchronize database state with session
      org.hibernate.exception.ConstraintViolationException: could not insert collection rows: org.olat.user.UserImpl.properties#196609
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1416)
      at org.hibernate.action.CollectionUpdateAction.execute(CollectionUpdateAction.java:86)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                srosse Stéphane Rossé
                Reporter:
                bhedrick Brooke Hedrick
                Tester:
                Brooke Hedrick
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h