Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-4046

zoom duplicate user id

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      java.lang.RuntimeException: java.sql.BatchUpdateException: Batch entry 92 insert into grouper_prov_zoom_user ( config_id, member_id, id, email, first_name, last_name, type, pmi, timezone, verified, created_at, last_login_time, language, status, role_id ) values ( 'pennZoomProd', 'dde6bab7a', 'jZ4M4TexS', 'jenenn.edu', 'Jenna', '', 2.0, NULL, 'America/New_York', 1.0, NULL, NULL, NULL, 'active', NULL ) was aborted: ERROR: duplicate key value violates unique constraint "grouper_zoom_user_id_idx"
      Detail: Key (id, config_id)=(jZ4M4TexS3i, pennZoomProd) already exists. Call getNextException to see other errors in the batch.,
      sql: insert into grouper_prov_zoom_user ( config_id, member_id, id, email, first_name, last_name, type, pmi, timezone, verified, created_at, last_login_time, language, status, role_id ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ), ,
      Error in 'inserts' query: 'insert into grouper_prov_zoom_user ( config_id, member_id, id, email, first_name, last_name, type, pmi, timezone, verified, created_at, last_login_time, language, status, role_id ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )'
      at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2344)
      at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeBatchSql(GcDbAccess.java:2390)
      at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeBatchSql(GcDbAccess.java:2404)
      at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.runInserts(GcTableSyncSubtype.java:1119)
      at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.runInsertsUpdatesDeletes(GcTableSyncSubtype.java:1705)
      at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.access$300(GcTableSyncSubtype.java:30)
      at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype$1.syncData(GcTableSyncSubtype.java:75)
      at edu.internet2.middleware.grouper.app.zoom.GrouperZoomLoader.loadUsersToTable(GrouperZoomLoader.java:681)
      at edu.internet2.middleware.grouper.app.zoom.GrouperZoomLoader$1.callback(GrouperZoomLoader.java:501)
      at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
      at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1069)
      at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1036)
      at edu.internet2.middleware.grouper.app.zoom.GrouperZoomLoader.fullLoad(GrouperZoomLoader.java:264)
      at edu.internet2.middleware.grouper.app.zoom.GrouperZoomLoader.run(GrouperZoomLoader.java:147)
      at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:439)
      at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
      at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1069)
      at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1036)
      at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:392)
      at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:376)
      at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.sql.BatchUpdateException: Batch entry 92 insert into grouper_prov_zoom_user ( config_id, member_id, id, email, first_name, last_name, type, pmi, timezone, verified, created_at, last_login_time, language, status, role_id ) values ( 'pennZoomProd', 'dde6bab7a3bd41388fed01e, 'jZ4M4TexS3iB', 'jen', 'Jenna', '', 2.0, NULL, 'America/New_York', 1.0, NULL, NULL, NULL, 'active', NULL

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: