[Data Sync] Bug fix - data not being loaded

bcgov / nr-spar-data-sync

Engine to sync data for SPAR application (from Postgres to Oracle)

Apache License 2.0

2 stars 0 forks source link

[Data Sync] Bug fix - data not being loaded #14

Closed thiagosanchezenc closed 9 months ago

thiagosanchezenc commented 9 months ago

During the stress test, where we moved around 45 thousand records, we found a bug that did not move all data from source to target. From 21 thousand records for a specific table, only 200 were synced.

thiagosanchezenc commented 9 months ago

The bug was related to how the string query to find out if a record already existed on the target database or not was being formatted.