I have a FM table that shadows an ODBC Oracle sandbox table in an enterprise data warehouse (fmoracle.fmp12). I normally create 100-200 records in another local FM table (fmlocal.fmp12) that I upload biweekly (export subset of fmlocal and import to fmoracle). There are 14 fields of type text, number and date in fmlocal.fmp12. I had some data corruption in the fmoracle.fmp12 table, so I deleted and recreated it. When I tried to upload the fmlocal data to fmoracle, 1050 of the records uploaded, but 98 failed. I exported the 98 into another temp file and tried again without success. I also exported to xls, xlsx, xml, and fmp12 and tried to import each of those files into fmoracle, but none of the 98 succeeded. I tried inserting the xlsx file via SQL uploader to the same fmoracle table without success.
The data fields look like they are formatted correctly, but this process I regularly use is failing. What should I troubleshoot?