Missing records

[eguzman]

Hi !, I have several databases running from Fm server 5.5 (PC, win 2000 pro). One particularly is missing records (invoices), I though they accidentally were deleting records, so I eliminate the privilege of deleting records to all passwords (except the master which they dont' have), once again one invoice is missing (I can see the gap in the RecordID), just last week the record was shown in one report, now that the same report is generated the invoice is missing. any clues?

The clients are FM 5.5 for PC, over TCP/IP

[Anatoli]

Ernesto,

I didn't see that on our systems. Could you repeat that, or was it just freak accident?

I know one US Company in Mexico is looking for good FM people.

They are based in Tlaxcala near Puebla.

I was there for one week and it was nice.

If you are interested, please email me.

Anatoli

[eguzman]

It happen from time to time, at first we had open privileges to delete records within a script, but when invoices begin to desapear we limit the access to certain people, the problem persisted, but with fewer cases, so we take out every privilege and again one invoice dissapear, no results reconstructing the database, got to be the FM server since this happened during the weekend and nobody used the DBs, so extrange. any way, I have to check the server logs to see if anything weird happened in this days.

Interesting your proposal, I have 12 years of experience developing in FM, most of our solutions are develope on FM or FM/SQL, I have my own company (interlasa.com), perhaps we can work together some how, what do you think?

[BruceJ]

I recall back with Sever 3.0, when I'd have a crash or an unplanned restart, I'd loose info.

Finally, I added in the exit scripts to "flush cache to disc" and this prevented most losses.

Check to be sure the server machine isn't being "backed up" at times and forcing Server to rerstart as well.