Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About sfpx

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    10.11 el captain

Recent Profile Visitors

3,372 profile views
  1. Hi Wim, We had a bit of discussion about this in the filemaker forums. The database can be opened using the "option" command. Filemaker then "repairs" the db. No recover needed.
  2. I used mirrorsync and fms17 without any database corruption for a full year (and fms16 for a year too) Since I upgraded to fms 18 the database got corrupted twice. Both times there was the sequence of events like this example of yesterday 9:48 PM a user seems to cancel a sync User canceled action (JDBC URL: jdbc:fmp360://mysite/mydb, SSL: false / SQL statement: SELECT _gSync1, lastErrorMessage FROM MirrorSync WHERE -script='MirrorSync (HeliCloud)' AND -script.param=? / SQL params: [doServerAction One minute later the user retried Error 802: Unable to open file - Check to make sure that the database file is hosted on FileMaker Server In the events.log file 2019-10-16 21:48:49.848 -0400 Error 618 mysite Database or temporary file "filewin:/C:/Windows/Temp/FMTEMPFM2932_5.tmp" is damaged and has been closed. (4294967295) 2019-10-16 21:48:49.848 -0400 Error 681 mysite Closing database "mydb" due to damaged temporary file... Any idea of a way to fix this ?
  3. I have a small bug in my app, not related to mirror sync that make the users land on a sync layout. My main mistake was to use the sync layouts in some of my non sync related scripts. So basically , while I'm investigating how some of the users get stuck there I would like to put a button over all the sync fields that would get the user back to the main menu. Is it safe to put a button over the fields of the sync layouts ? I would guess so but better be safe than sorry.
  4. Sent you a log today (ticket 74662) We got this error message a dozen of times today. The error stops the sync process but if the user syncs again right away it will go through without an error message.
  5. I have some problems importing the Mirrorsync data onto the new server 1.Installed Mirrorsync on the new server 2.Imported the configuration 3.Copied the SyncData4_MirrorSync folder from the old server to new one When I try to sync I get the following error Solution ?
  6. Thanks Jesse. I actually filed quite a few problem reports with logs. The problems are really really weird and I am under high pressure to fix them (we have 26 devices and a lot more are waiting to be added) I also had the strangest thing happening today . A user got records created with primary keys corresponding to other records from other tables. Example: Table "Days" A record was created with an UUID of the table "reports" (5DFB1DC6-FA48-384C-9EE5-46CA40EECF5B) that was not even to be synced to that user. That data inside that record was copied from another day record (D18C9460-5E8F-5346-8A37-4134EEA114EF) Really strange In the log file You can get the logs in tickets 73709 , 73710 and 73711 Note that all the problems seem to have been generated from users who synced the day I installed the ssl certificate. Users who did not sync that day did not get any duplicates (because I eventually deleted the cert) as far as I know. Still not quite sure the ssl cert is the cause of all this though.
  7. I don't know what's going on but today, each record created on the device is being duplicated (on the device) after the sync to the server. I haven't changed my mirrorsync config or custom script. What I did though was to try to install the ssl certificate. I was successful . Tried a sync with no creation ...looked fine to me. I then created a record and got the duplicate. I then disabled ssl in the filemaker server 16 admin console and rebooted the server. I started from scratch with an initial sync. Looked fine. Created a record , synced and got the duplicate again. Note that I haven't changed the mirrisync config to use ssl...but anyway I reverted to bon ssl and still get the duplicate Any idea ?
  8. sfpx


    Awesome. Thanks Jesse.
  9. sfpx


    When my mirrorsync was hosted on fmphost and I requested logs I was getting this kind of log Now mirrosync is installed on our server but I can't find any file with this kind of information. Where do I find them ?
  10. What would be the impact on existing users if I remove tables from the sync and edit the mirrorsync scripts on the server ? I would not delete the actual layouts or tables. Would that delete records on the device or the tables would just not be synced even if they have not updated the mirrorsync script on their device ?
  11. Not really willing to do that I will eventually test it on a test database if I got some spare time. Now , it's a bit off topic but I found out that a relation sort can greatly impact the filter speed if your filter is looking for a related field even if if it's not the related table that is sorted but the sync table itself. It's really a strange filemaker behavior. Example: TableA-TableB TableB is sorted in the relation You are on the TableB layout and you perform a find on TableA. The sort will slow down the operation even if it's not TableA that is sorted but TableB. Pretty annoying stuff but it's good to know I guess.
  12. I would like to change the table occurrence of a sync layout. 1.The layout would remain the same, same fields (but from a different occurrence). 2.The filter would return the same records just faster and on a different table occurrence. Ex: Sync layout: TestLayout Original table occurrence: Test New table occurrence : SyncTest ( occurrence of test) What would happen to the users who haven't got the new version of the database and sync? Would that cause problems because they are expecting records from test and get records from SyncTest or would that work just fine because they actually get the expected fields ?
  13. Excellent. I discovered 2-3 layouts that were a lot slower than the others. The filters were based on unstored calc fields. I will change that. Thanks for the tip.
  14. I noticed that this step is taking quite a long time. Any way to speed it up ? This is with an ios---fm server (v 16) sync.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.