Details
-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
None
-
None
-
tier docker latest
Description
i have 2 similarly configured table syncs. One has * for the columns and 2 primary keys and the other specifies the columns to sync and a single primary key. Everything is the same (of course, different tables). One we see Upd for all entries every time the sync is run and the other we only see inserts/deletes.
Start | End | Run | Job Name | Total | Ins | Upd | Del | UN | Status | Host | Message |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
06/24 09:16:00 | 09:17:34 | 01:34 | OTHER_JOB_sql_EXT_IDENTITY | 28,951 | 0 | 28,951 | 0 | 0 | NULL | edb3 | fullSync: true, key: EXT_IDENTITY, finalLog: true, state: deletes, d |
06/24 09:15:00 | 09:16:30 | 01:30 | OTHER_JOB_sql_ARP_PERSON_INFO | 768,304 | 3 | 2 | 0 | 0 | NULL | edb3 | fullSync: true, key: ARP_PERSON_INFO, finalLog: true, state: deletes |
the config for the two syncs are:
grouperClient.syncTable.EXT_IDENTITY.databaseFrom = shibtst
grouperClient.syncTable.EXT_IDENTITY.schemaFrom = IDREGISTRY
grouperClient.syncTable.EXT_IDENTITY.tableFrom = EXT_IDENTITY
grouperClient.syncTable.EXT_IDENTITY.databaseTo = grouper
grouperClient.syncTable.EXT_IDENTITY.schemaTo = grouper
grouperClient.syncTable.EXT_IDENTITY.tableTo = uf_EXT_IDENTITY
grouperClient.syncTable.EXT_IDENTITY.columns = REGISTRY_ID, SEQUENCE_NO, LINKED_ID, UFID, PRINCIPAL, PRIN_RSC_TYP, FRIENDLY_NAME, HONORIFIC_PREFIX, GIVEN_NAME, MIDDLE_NAME, FAMILY_NAME, HONORIFIC_SUFFIX, DISPLAY_NAME, EMAIL, PHONE_NUMBER, PHONE_TYPE, CREATED_TS, INACTIVE_TS, END_TS, STATUS, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01
grouperClient.syncTable.EXT_IDENTITY.primaryKeyColumns = REGISTRY_ID
grouperClient.syncTable.EXT_IDENTITY.groupingColumn = REGISTRY_ID
grouperClient.syncTable.EXT_IDENTITY.groupingSize = 100000
grouperClient.syncTable.EXT_IDENTITY.batchSize = 100000
grouperClient.syncTable.EXT_IDENTITY.realTimeLastUpdatedCol = last_updated
grouperClient.syncTable.EXT_IDENTITY.statusDatabase = grouper
grouperClient.syncTable.EXT_IDENTITY.statusSchema = grouper
grouperClient.syncTable.EXT_IDENTITY.statusTable = uf_change_log_consumer
grouperClient.syncTable.ARP_PERSON_INFO.databaseFrom = shib
grouperClient.syncTable.ARP_PERSON_INFO.schemaFrom = UFSHIB
grouperClient.syncTable.ARP_PERSON_INFO.tableFrom = ARP_PERSON_INFO
grouperClient.syncTable.ARP_PERSON_INFO.databaseTo = grouper
grouperClient.syncTable.ARP_PERSON_INFO.schemaTo = grouper
grouperClient.syncTable.ARP_PERSON_INFO.tableTo = uf_ARP_PERSON_INFO
grouperClient.syncTable.ARP_PERSON_INFO.columns = *
grouperClient.syncTable.ARP_PERSON_INFO.primaryKeyColumns = ARP_PAR_UFID, ARP_PAR_GLID
grouperClient.syncTable.ARP_PERSON_INFO.groupingColumn = ARP_PAR_UFID
grouperClient.syncTable.ARP_PERSON_INFO.groupingSize = 100000
grouperClient.syncTable.ARP_PERSON_INFO.batchSize = 100000
grouperClient.syncTable.ARP_PERSON_INFO.realTimeLastUpdatedCol = last_updated
grouperClient.syncTable.ARP_PERSON_INFO.statusDatabase = grouper
grouperClient.syncTable.ARP_PERSON_INFO.statusSchema = grouper
grouperClient.syncTable.ARP_PERSON_INFO.statusTable = uf_change_log_consumer