AnsweredAssumed Answered

File Integrity in Question - Need Help!

Question asked by googull on Sep 14, 2018
Latest reply on Sep 16, 2018 by googull

We have a very stable app running now several years currently on FMP Version 14.0.5.   One of the reports stopped printing multiple records per page as was usual, instead ejecting a new page for each record beginning August 1, 2018.  Backup file the night before (July 31) still prints (and PDF Previews) fine but all of sudden on August 1 and ever since the report has failed to properly print.  It still prints all records, it just turns the page now between each item wasting enormous amounts of paper, etc.     I've run a consistency check with nothing found, and attempted Recovery without any change to the undesired result.  I am hoping someone may have a idea on how to further check the integrity of the database, which for all other purposes has been running perfectly and unfortunately has been greatly transacted against since that time.   It seems that perhaps we may have a corrupt index but unclear how to ask FMP to rebuild all it's indexes, etc.   Any input on how to tackle this other than manually capturing all transactions since August 1 would be greatly appreciated. 

 

The report is invoked via script with the following syntax - screen shot attached. 

 

Carl

Outcomes