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