AnsweredAssumed Answered

Creating a NEW data base / Transactions Table per YEAR , Crashes

Question asked by MikeHackett on Mar 7, 2011
Latest reply on Mar 8, 2011 by MikeHackett

Summary

Creating a NEW data base / Transactions Table per YEAR , Crashes

Product

FileMaker Pro

Version

11 Trial

Operating system version

Windows 7

Description of the issue

I have Transaction data that is organized by quarter. This is in a Text.csv file. I have a table set-up and choose import file to try to combine a full years worth of transactions.

I have tried multiple times with the same error. When it gets to about 6 to 7 million records, it will crash and restart I get the ERROR: "Filename" is damaged and cannot be opened, use the recover command to recover this file.

Recover processes and fails.

Steps to reproduce the problem

Blank database. Import Header, then import files to make up for years worth of transactions.

2003     3     AL      1,556,645
2003     3     MZ      2,400,674
2003     6     AL      1,823,486
2003     6     MZ      2,448,940
2003     9     AL      1,873,406
2003     9     MZ     
2003     12     AL     
2003     12     MZ

Expected result

I can never get just these 5 files complete.
I have tried individually, and different in different order but seems to always crash between 6 to 7 million records. The actual FP7 size varies from 2.2gb to 4.4gb

Exact text of any error message(s) that appear

2011-03-04 23:21:40.230 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-04 23:21:40.387 -0700     PRoject1.fp7     8430     ERROR: Last page 1049345 doesn't match end of file page 1048385
2011-03-04 23:35:44.678 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-04 23:35:44.706 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-04 23:36:10.086 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-04 23:36:14.363 -0700     PRoject1.fp7     0     Skipped rest of consistency check, only 22154 block(s) were checked
2011-03-04 23:46:24.065 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-04 23:57:06.542 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-04 23:57:06.545 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-05 00:10:04.471 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-05 00:22:15.137 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-05 00:22:15.184 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-05 09:32:11.004 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-05 09:44:32.727 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-05 09:44:32.794 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-05 16:29:58.492 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-05 16:40:35.671 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-05 16:40:35.685 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-05 20:11:50.688 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-05 20:24:11.154 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-05 20:24:11.161 -0700     PRoject1.fp7     805     FAILED consistency check, error 805
2011-03-05 20:29:39.858 -0700     PRoject1.fp7     0     *** Started consistency check of improperly closed file, total of 1048385 block(s) to check
2011-03-05 20:40:10.585 -0700     PRoject1.fp7     8437     ERROR: Page 1045768 invalid previous page link 1045515
2011-03-05 20:40:10.589 -0700     PRoject1.fp7     805     FAILED consistency check, error 805

Workaround

Make all smaller tables / half years.. but doing this for 2002-2010 :-(

ErrorPopups.png

Outcomes