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,123 profile views
  1. 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.
  2. 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 ?
  3. 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.
  4. 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 ?
  5. sfpx


    Awesome. Thanks Jesse.
  6. 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 ?
  7. 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 ?
  8. 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.
  9. 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 ?
  10. 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.
  11. 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.
  12. Thanks a lot for the detailed answer. I will check my relations instead of removing them then .
  13. If we use UUID's for all our key fields can we remove all the relations from the foreign key mapping section ? If so, would it result in a smaller script and a slightly better performance ?
  14. That's what I thought. Thanks
  15. Can I filter records without having them deleted on the spoke by the sync ? Let's say I have a table "Things" with a field "User" and I want to sync all the things of a particular user but would also like to keep the records of User 'Default' without having to sync them (there are many , they don't have to be synced and they would be included in the empty database). I know I could set the filter to User=$User or User="Default" but would like to set it to only User=$User If I set the filter in the "FindChanges" section of the mirrorsync customization script, will the filter be applied to device data too or only on the hub and all the default user things will end up being deleted ? Hopefully I explained it clearly enough. Thanks
  • Create New...

Important Information

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