FM Pro 5.5 on PC Crashing when doing certain finds 
Author Message
 FM Pro 5.5 on PC Crashing when doing certain finds

Hello,

I've got a script, that when ran, will crash FM once, then when I go
back into the file, and run the script again, it'll work just fine.

Here's a more detailed overview of what happens:

Go into file, run script, get this message:

Error in file "<unknown>"
This file is damaged. Click continue to continue using this file, or
click Exit to exit FileMaker. Consult the FileMaker manual for
information on recovery.

So, I press continue, and behold, FM will crash with some invalid
exception error. Windows XP doesn't allow to to copy and paste the info
otherwise I'd  put it in this post.

I go back into FileMaker, open up the file, run the script, and it
works.

Now, I've isolated the problem to one find in the script. All it does is
omits all the records that contain 0 in a calculated field. This problem
does not happen everytime, though, I cannot isolate it. The problem will
happen whenever I do that find manually as well.

Any ideas on what to do?

Thanks,
Sung



Sat, 11 Dec 2004 21:40:45 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds

I also forgot to mention that the it does the very same thing on FM for
MacOS X.

I'm sure it'd do the same thing with MacOS classic, as well.

I've recovered the file before, too, so it can't be that hte file is
damaged.

It's a file with over 50 fields and 35,841 records.



Quote:
> Hello,

> I've got a script, that when ran, will crash FM once, then when I go
> back into the file, and run the script again, it'll work just fine.

> Here's a more detailed overview of what happens:

> Go into file, run script, get this message:

> Error in file "<unknown>"
> This file is damaged. Click continue to continue using this file, or
> click Exit to exit FileMaker. Consult the FileMaker manual for
> information on recovery.

> So, I press continue, and behold, FM will crash with some invalid
> exception error. Windows XP doesn't allow to to copy and paste the
> info otherwise I'd  put it in this post.

> I go back into FileMaker, open up the file, run the script, and it
> works.

> Now, I've isolated the problem to one find in the script. All it does
> is omits all the records that contain 0 in a calculated field. This
> problem does not happen everytime, though, I cannot isolate it. The
> problem will happen whenever I do that find manually as well.

> Any ideas on what to do?

> Thanks,
> Sung



Sat, 11 Dec 2004 21:56:52 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds
The fact that you have recovered the file before (assuming you were forced
to do that to get it working) means that the file PROBABLY IS DAMAGED.  The
recover function of FileMaker is to be used for recovery of DATA, not
DESIGN.  After running the recover function, you import the recovered data
into a copy of your database that has never crashed and get rid of the one
that has crashed.  You should ALWAYS have a "clean clone" of your important
databases.

Now, back to your problem...show us the exact steps in the script and the
definitions for any referenced fields (including fields referenced
indirectly).  Most likely one of them is the problem.


Quote:
> I also forgot to mention that the it does the very same thing on FM for
> MacOS X.

> I'm sure it'd do the same thing with MacOS classic, as well.

> I've recovered the file before, too, so it can't be that hte file is
> damaged.

> It's a file with over 50 fields and 35,841 records.



> > Hello,

> > I've got a script, that when ran, will crash FM once, then when I go
> > back into the file, and run the script again, it'll work just fine.

> > Here's a more detailed overview of what happens:

> > Go into file, run script, get this message:

> > Error in file "<unknown>"
> > This file is damaged. Click continue to continue using this file, or
> > click Exit to exit FileMaker. Consult the FileMaker manual for
> > information on recovery.

> > So, I press continue, and behold, FM will crash with some invalid
> > exception error. Windows XP doesn't allow to to copy and paste the
> > info otherwise I'd  put it in this post.

> > I go back into FileMaker, open up the file, run the script, and it
> > works.

> > Now, I've isolated the problem to one find in the script. All it does
> > is omits all the records that contain 0 in a calculated field. This
> > problem does not happen everytime, though, I cannot isolate it. The
> > problem will happen whenever I do that find manually as well.

> > Any ideas on what to do?

> > Thanks,
> > Sung



Sat, 11 Dec 2004 22:31:26 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds
I completely agree with Glenn in his assessment that the file probably IS
damaged.  Running 'Recover' won't fix files -- it'll only temporarily let
you access the data to save it from itself.

Using a clean backup would be my first suggestion.

But sometimes clean backups just don't exist for many users.  It's sad and
wrong, but often is true.  If this is your case, I'll suggest two things
before you trash the file:

1) Print out the script that is giving you problems and then create a whole
new script from scratch, based on what you have on the printout.  In other
words, DO NOT simply duplicate the offending script, as this will usually
duplicate the corruption as well.

2) This one's less likely the culprit of crashes, but possible.  Print your
field definitions and then create a new calc field that reads just like the
old one that you are performing your find on.  Once again, DO NOT simply
click the duplicate field button.  DO NOT cut and paste the calc.  Create a
brand new field and create the definition from scratch just like you did
the first time.  This will possibly clear up corruption either in the field
definition or in the field's index.

Quote:

> I also forgot to mention that the it does the very same thing on FM for
> MacOS X.

> I'm sure it'd do the same thing with MacOS classic, as well.

> I've recovered the file before, too, so it can't be that hte file is
> damaged.

> It's a file with over 50 fields and 35,841 records.



> > Hello,

> > I've got a script, that when ran, will crash FM once, then when I go
> > back into the file, and run the script again, it'll work just fine.

> > Here's a more detailed overview of what happens:

> > Go into file, run script, get this message:

> > Error in file "<unknown>"
> > This file is damaged. Click continue to continue using this file, or
> > click Exit to exit FileMaker. Consult the FileMaker manual for
> > information on recovery.

> > So, I press continue, and behold, FM will crash with some invalid
> > exception error. Windows XP doesn't allow to to copy and paste the
> > info otherwise I'd  put it in this post.

> > I go back into FileMaker, open up the file, run the script, and it
> > works.

> > Now, I've isolated the problem to one find in the script. All it does
> > is omits all the records that contain 0 in a calculated field. This
> > problem does not happen everytime, though, I cannot isolate it. The
> > problem will happen whenever I do that find manually as well.

> > Any ideas on what to do?

> > Thanks,
> > Sung

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Sun, 12 Dec 2004 00:16:54 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds
Hi,

Glen and Howard: Thank you for all of your help.

I've got the issue resolved. I had to recreate the entire DB, it was a
lot of work, but now it works perfectly.


216.166.71.234:

Quote:
> I also forgot to mention that the it does the very same thing on FM
for
> MacOS X.

> I'm sure it'd do the same thing with MacOS classic, as well.

> I've recovered the file before, too, so it can't be that hte file is
> damaged.

> It's a file with over 50 fields and 35,841 records.



>> Hello,

>> I've got a script, that when ran, will crash FM once, then when I go
>> back into the file, and run the script again, it'll work just fine.

>> Here's a more detailed overview of what happens:

>> Go into file, run script, get this message:

>> Error in file "<unknown>"
>> This file is damaged. Click continue to continue using this file, or
>> click Exit to exit FileMaker. Consult the FileMaker manual for
>> information on recovery.

>> So, I press continue, and behold, FM will crash with some invalid
>> exception error. Windows XP doesn't allow to to copy and paste the
>> info otherwise I'd  put it in this post.

>> I go back into FileMaker, open up the file, run the script, and it
>> works.

>> Now, I've isolated the problem to one find in the script. All it does
>> is omits all the records that contain 0 in a calculated field. This
>> problem does not happen everytime, though, I cannot isolate it. The
>> problem will happen whenever I do that find manually as well.

>> Any ideas on what to do?

>> Thanks,
>> Sung



Mon, 13 Dec 2004 21:02:49 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds
Good news!

Now, before you go much further, make sure you save a clone of your
databases that you can rely on in case of a reoccurrence of this problem.
If you can't store the clones on removable media, Zip them so that FileMaker
won't try to open them (or just change the extension to ".fpx").  Use copies
of the clones to do development work, updating the clones and importing
current data when done making changes.  Always have that clean, never
crashed copy available to fall back on when disaster strikes.

Second, try to figure out why you had the problem in the first place...in
other words, what caused the corruption that forced you to recreate the
entire DB?  Often it is caused by improper file sharing or using backups
created while the DB is open.

Starting with the first cause, and assuming you are sharing the DB and you
do not have the Server version (which you don't mention), make sure that the
DB is always being hosted (opened first) by the computer on which it is
stored, preferably not someone's workstation if there are more than just a
couple of users.  Any old computer would do.  Make sure that any additional
users open the DB using the appropriate Open/Hosts method and NOT via OS
file sharing.  Check the archives of this newsgroup for numerous discussions
regarding this process if you aren't sure what is "appropriate".

Second, always close the DB before backing up.  A backup copy made while the
DB is open is likely to develop corruption.  There are also threads in this
newsgroup describing ways to automate this process with and without the
Server version.

Finally, if your DB crashes again, feel free to post details about what
happened and we'll try to help diagnose the problem so you don't have to
start from scratch again.


Quote:
> Hi,

> Glen and Howard: Thank you for all of your help.

> I've got the issue resolved. I had to recreate the entire DB, it was a
> lot of work, but now it works perfectly.


> 216.166.71.234:

> > I also forgot to mention that the it does the very same thing on FM
> for
> > MacOS X.

> > I'm sure it'd do the same thing with MacOS classic, as well.

> > I've recovered the file before, too, so it can't be that hte file is
> > damaged.

> > It's a file with over 50 fields and 35,841 records.



> >> Hello,

> >> I've got a script, that when ran, will crash FM once, then when I go
> >> back into the file, and run the script again, it'll work just fine.

> >> Here's a more detailed overview of what happens:

> >> Go into file, run script, get this message:

> >> Error in file "<unknown>"
> >> This file is damaged. Click continue to continue using this file, or
> >> click Exit to exit FileMaker. Consult the FileMaker manual for
> >> information on recovery.

> >> So, I press continue, and behold, FM will crash with some invalid
> >> exception error. Windows XP doesn't allow to to copy and paste the
> >> info otherwise I'd  put it in this post.

> >> I go back into FileMaker, open up the file, run the script, and it
> >> works.

> >> Now, I've isolated the problem to one find in the script. All it does
> >> is omits all the records that contain 0 in a calculated field. This
> >> problem does not happen everytime, though, I cannot isolate it. The
> >> problem will happen whenever I do that find manually as well.

> >> Any ideas on what to do?

> >> Thanks,
> >> Sung



Mon, 13 Dec 2004 22:35:03 GMT
 FM Pro 5.5 on PC Crashing when doing certain finds

Quote:

> Good news!

> Now, before you go much further, make sure you save a clone of your
> databases that you can rely on in case of a reoccurrence of this problem.
> If you can't store the clones on removable media, Zip them so that FileMaker
> won't try to open them (or just change the extension to ".fpx").  Use copies
> of the clones to do development work, updating the clones and importing
> current data when done making changes.  Always have that clean, never
> crashed copy available to fall back on when disaster strikes.

See:
http://heifer.ucc.usyd.edu.au/cdf_faq/FMPro?-db=cdf%5ffaq.fp5&-format...

Quote:

> Second, try to figure out why you had the problem in the first place...in
> other words, what caused the corruption that forced you to recreate the
> entire DB?  Often it is caused by improper file sharing or using backups
> created while the DB is open.

> Starting with the first cause, and assuming you are sharing the DB and you
> do not have the Server version (which you don't mention), make sure that the
> DB is always being hosted (opened first) by the computer on which it is
> stored, preferably not someone's workstation if there are more than just a
> couple of users.  Any old computer would do.  Make sure that any additional
> users open the DB using the appropriate Open/Hosts method and NOT via OS
> file sharing.  Check the archives of this newsgroup for numerous discussions
> regarding this process if you aren't sure what is "appropriate".

See:
http://heifer.ucc.usyd.edu.au/cdf_faq/FMPro?-db=cdf%5ffaq.fp5&-format...

Quote:

> Second, always close the DB before backing up.  A backup copy made while the
> DB is open is likely to develop corruption.  There are also threads in this
> newsgroup describing ways to automate this process with and without the
> Server version.

See:
http://heifer.ucc.usyd.edu.au/cdf_faq/FMPro?-db=cdf%5ffaq.fp5&-format...

Quote:

> Finally, if your DB crashes again, feel free to post details about what
> happened and we'll try to help diagnose the problem so you don't have to
> start from scratch again.

Absolutely. We don't have an FAQ entry for that yet though ;-)

Webko



Tue, 14 Dec 2004 06:46:41 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. FM Dev 5 and FM Pro 5.5 compatibility

2. Workaround for FM 5.5, 6 crashes with web companion

3. FM Developer Tool 5.5 crashing under Jaguar

4. FM 5.5 crashes when web companion checked

5. Web Companion Crashed FM - Unsolved problem in 5.5 !!!

6. Acrobat 5 PDF to FM Pro 5.5 (on Mac)

7. where does FM Pro 5.5 locate databases?

8. FM Pro 5.5 MAC / Auto Dialing To Internet Problem

9. AppleScript extrem slow and instabil (FM Pro 5.5 / Mac OS 10.1.1)

10. FM Pro 5.5 OS X Solution won't open and shuts down program

11. FM Pro 5.5 Username on Web


 
Powered by phpBB® Forum Software