Re-use old person sync data when errors prevent generation of new data.

UMNLibraries / experts_etl

Moves data from UMN to Pure (Experts@Minnesota), and vice versa.

3 stars 0 forks source link

Re-use old person sync data when errors prevent generation of new data. #25

Closed nihiliad closed 4 years ago

nihiliad commented 4 years ago

Currently, we truncate the puresync* tables, then populate them with new data. Sometimes that process fails, for example with Oracle connection errors like "ORA-01775: looping chain of synonyms". Instead of deleting the previous pure_sync_data, save it somehow so that it can be re-used if the generation of new data fails for whatever reason.

nihiliad commented 4 years ago

Fixed in 8e23f3fa81ae49b7fee270eff633a303c2dabff4.