SQL Sync fails on key collision

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Minor
    • None
    • Affects Version/s: 5.11.0
    • Component/s: daemon
    • None
    • Environment:
      containerized

      as noted in https://internet2.slack.com/archives/C7V0UQDJ4/p1720738943025849

      The config is:

      grouperClient.syncTable.but_sync.columns = * grouperClient.syncTable.but_sync.databaseFrom = SID grouperClient.syncTable.but_sync.databaseTo = iam grouperClient.syncTable.but_sync.groupingColumn = but_sid grouperClient.syncTable.but_sync.incrementalAllColumnsColumn = but_lad grouperClient.syncTable.but_sync.primaryKeyColumns = but_kid,but_uuid grouperClient.syncTable.but_sync.tableFrom = USERACCT_ADMIN.BUT grouperClient.syncTable.but_sync.tableTo = public.but

      The log is attached.

        1. but_full.log
          7 kB

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Michael Gettes
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: