7 Replies Latest reply on May 8, 2013 3:20 PM by philmodjunk

    Script not longer works (after working fine for years)

    robyne

      Title

      Script not longer works (after working fine for years)

      Post

           Using Filemaker 12/Server on Mac OS 10.7 & 10.8

           I have a script that basically looks to find everything greater than zero and less than zero for a calculation field [current balance:  this is an aging report].  I've never had a problem until today.

           Now it finds everything including zero balances.

           1.  Is this a corrupted file problem?  

           2.  If so, how do I figure out how to resolve the issue?  I just had to do a restore for a corrupted record last month - this requires taking everyone offline which is extremely disruptive.  Could the indexing problem from that corruption still lurking?

           3.  If not, how to I get it to work?  fyi, the find does not work manually either.

           4.  The field does calculate the correct current balance for a given account.

        • 1. Re: Script not longer works (after working fine for years)
          philmodjunk

               Take and test a back up copy.

               Use Advanced recover options to rebuild the file's indexes. See if the recovered copy exhibits the same behavior.

          • 2. Re: Script not longer works (after working fine for years)
            robyne

                 That did not cure the problem.  Any other ideas?

                  

            • 3. Re: Script not longer works (after working fine for years)
              philmodjunk

                   Sorry, but I know of no reason and have seen no bug reports that would suggest why your file behaves differently in FileMaker 12 than in 11.

              • 4. Re: Script not longer works (after working fine for years)
                robyne

                     It has been behaving fine in FM 12 until recently when I had some kind of indexing error that corrupt 2 records (leaving them with the nasty ? in every field).  I recovered, used a close, imported all the data and all was fine for 12 days.  Now I have this problem.  So the question is do I still have some kind of indexing problem and now its choosing to be a problem just in a different way?  Will scrapping the script and starting over help?

                • 5. Re: Script not longer works (after working fine for years)
                  philmodjunk

                       I wish that you had told me that from the beginning. If it worked before as an FMP12 file, then something has changed since the conversion to produce this issue.

                       An indexing problem is what I suspected from the beginning. That why I suggested using recover to rebuild the indexes and testing the recovered copy to see if this corrected the issue.

                       While Recover almost always fully and correctly repairs damage to your file, it isn't perfect. If you recovered the file and have then been using the recovered copy, it's possible that the recover didn't fully repair the damage. Best practice is to replace your damaged file with an undamaged back up copy instead of using the recovered copy. If necessary, you can import the data into a clone of such a backup.

                       But that may be what you did when you had the original problem or did you clone the reovered file?

                       If you cloned a back up copy, it's not impossible that the back up copy was already damaged, but that the damaged had not become observable yet and you may need to use an older backup copy if you have it.

                       I'm not confident that replacing the script will fix the issue, but it might work and is probably your simplest/quickest next fix to try.

                       You can also try doing a "full up" recover on the file to see if the recovered file still has this issue.

                  • 6. Re: Script not longer works (after working fine for years)
                    robyne

                         Sorry, I thought I was clear about the FM12 file.  I managed to get everything working again.  However, I am less interested in how to fix the problem an more interested in why it's  happening in the first place.  Is there a way to methodically go through and find something that is triggering an indexing problem or is this simply the underlying Filemaker code that is faulty?  I'd really love to avoid this mess again if possible.

                          

                         Thanks.

                    • 7. Re: Script not longer works (after working fine for years)
                      philmodjunk

                           I know of no diagnostic text that will report a problem with an index. Recover simply purges an index and rebuilds it from scratch when you recover a file.