I have an existing FMPA db with 295 fields. On a monthly basis, I export two subsets as files in .fp7 format. I then import into two different ODBC sandboxes on my company Oracle db. This process has worked for over a year.
This week, the Oracle architect had to duplicate and rename one of my tables (generic_facility) using the field names and character types from specific_facility. The new Oracle table has select, update, insert, and delete privileges. However, when I import my subset file into generic_table.fp7 (an ODBC mirror table of the Oracle source), I get 6 records added, 6 records skipped due to errors, 6 fields skipped due to errors. None show up.
If I import into the old copy prior to the rename, 6 records are added with 5 fields skipped.
What could be wrong with the import? Is there a tool in FMPA to debug, or is my import error obvious?