AnsweredAssumed Answered

Corrupt index on new field after using data migration tool

Question asked by greglane on Jul 16, 2018
Latest reply on Sep 11, 2018 by TSGal

Product and version: FMDataMigration 17.0.1.143

OS and version: macOS 10.13.5

Hardware: MBP

Description:

 

In two separate solutions, we added a new field (number, foreign key) to an existing table and then migrated data from the previous version of the solution. After the migration, we populated the new field via a script. In both cases, no records would appear in a portal that used the new field as a foreign key. A find for any value that appeared in the field would return no records. Reindexing the field (either manually or via Recover) caused the records to appear in the portal and finds worked as expected.

 

How to replicate:

 

We have attempted to replicate in a new file without success, but the same scenario has occurred in two independent systems. None of the source or target files show any sign of corruption (recover reports no errors).

 

Workaround (if any):

 

Reindex fields after data migration.

Outcomes