MirrorSync by 360Works

How to change my password in MS?

I've granted the MirrorSync script full access privileges. As such, can multiple users utilize a single spoke file from the same machine? For example, user A opens the spoke on the computer, makes changes, then syncs. Later, user B logs in to the same spoke file on the same machine, makes changes and runs the sync. Would this cause any problems? From my understanding this should work even if record level access is being utilized, since the script has access to all of the records. Is that correct? Thanks in advance! John

Hello, I have a strange question. I have an FMC instance in AWS-Frankfurt. It has deployed a database for users from Western Europe. By the way, they are very happy. However, there was a need to connect a certain number of new users from the Pacific region. If they connect to an existing instance in Frankfurt - there are problems with access time and speed of work, because in this case, users and servers are located on different ends of the globe. In addition, because of the large time difference, this requires around-the-clock work of the instance. This negatively affects the budget. I would like to try to deploy a second instance, identical to the first one, on a A…

Hi, I couldn't find the answer in the forum or docs. During configuration I received the error: "FileMaker has a limit of 32,768 script steps. This script contains 37,359 steps, which is 13% too large... You may skip this step if you are using JDBC (instead of XML)." I've managed to reduce the number of tables being synced and bypass this error, although I would prefer to add a few tables back. I'm curious what "You may skip this step if your are using JDBC" means. I am using JDBC. What are my options for syncing more tables than restricted by the number of script steps in a single script? Thanks!

Hi everyone, I am filtering the tables "projects" and "information" user based with XML in the customization script and this works fine. The table "modifikation" is not filtered in the customization script at all. (Please see attached relationship from the mirrorsync 4 client) My problem is that all records from "modifikation" are synced now, even if the related record from "information" is not on the device ... Because of my settings in the mirrorsync client I expected that only records are synced that are related to the found set of "information" . I am thankful for any idea :-) Kind regards Carsten

Is there a way to check a log determine why some records would be missing a PDF in the container? users in the field will generate a PDF and store that pdf in to a container when done with inspection then later sync that to the server the operation is one way sync Remote > Server. Yesterday's inspections had a few records with out pdf attachments and users reported no errors

When trying to update database on filemaker go. I changed the DB version and it asks to if I want to update to new version of DB. When I click ok it starts the Mirrorsync updater and then Shows an error. I have attached the screenshot.

In several tables of our solution there are records being created that have something like, "com.prosc.jdbc.JDBCUtils test d81e5f35-4f7c-4c53-92c1-bc32e3700094" in every field. Today I found 3 tables with collectively 150 records like this... this has been happening on an irregular basis since mirrorsync was implemented several months ago. Is this coincidence or something someone has seen before?

I was able to successfully sync an FMGo 16 iPhone instance with our FMS16 server-hosted database when all interactions were VPN/LAN based. But in setting up public WAN access, I encountered problems I cannot work around and did not find documentation to address. We opened up our firewall to not require offline users to use VPN. Since we have redundant ISP, I used a hostname as the external address so users could connect over the secondary line if our primary was down. Each of our WAN connections has multiple public IPs, and the public IP assigned to the filemaker server does not match the public ip of the router. When setting up the sync in MirrorSync Configuration …

When I try to get past entering my FMS credentials i get the following error. Error unmarshaling return: nested exception is: java.lang.classNotFoundException: com.sun.xml.ws.ClientTransportException My database is hosted, so I have no control on that side. Is this something I"m doing wrong in the configuration (jnlp file) I don't think 2 minutes went by after starting this post when I got a reply from my Hosting company. They said: I'm seeing something odd in the logs, where your MirrorSync admin credentials are being sent to n441 as if they are the FileMaker Server Admin credentials, but of course they are not. In your MirrorSync config…

I am working on a solution that syncs an Entity table. Even when I sync back-to-back there are 82 Entities (out of hundreds) that are *always* updated on the client side - every time. The SAME 82 records. No human updated these records so some automated process is doing this. There are NO pre-sync or post sync processes being run. There are 11 tables being synced, only with this table does this occur. Am I missing something? Any ideas where to look? Thanks, Mark

Hello, Is it possible to keep the user modification date for the record ? For example when Mirrorsync insert a record, the modification date is the sync date not the real user modification date. Thanks

Hi I've come up with a solution for a problem I had last week and wanted to post it here in case it helps anyone else. We had a strange thing with our MirrorSync server last week - the internal database got out of sync with the FileMaker Server (Hub) and the SQL Server (Spoke), so it kept trying to add Suppliers that had already been added to SQL Server and returning error messages for each one. The suppliers had been added to the SQL Server spoke, but MirrorSync kept trying to add them again. I checked and we had no duplicate keys in the FileMaker database so that wasn't the problem. My solution was to switch off the SQL server error reporting for duplicate key…

Is there a way to customize the language in the dialog box that appears after a successful sync when there's a new database version available? "There is a new database version available named 'x.xx'. Would you like to replace your current offline file with this version?" Thanks, Jason

Greetings. I came across MirrorSync recently, found it very interesting so I thought give it a go. I have managed to install it on FM server. However I am having issue setting it up. I have gone through all the documentations, enabled fmxml and fmdbc in my solution which is hosted on my FM server. I have run the deployment on FM server and enabled xml. But i am still having issues with getting databases. I get an error "could not get database names" and sometime I get an error "XML web publishing is not enabled". But It is enabled. I have tried number of things like disabling and enabling XML, restarting server etc.. but nothing has…

Our FMS 15 is running on a dedicated server at a hosting provider (running on Windows 2008 R2). We have two databases - a small 30 MB "UI" front end for accessing via FM Pro clients and a larger 7 GB database containing all the data. The only access to our databases are either (1) via FM Pro clients or (2) via WPE calls made from another non-FM server to retrieve data and add/update records. We are having a problem keeping the WPE up during times when staff are also doing other tasks on their computers via their FM Pro clients - in particular, when they are uploading spreadsheets of data which trigger scripts to process the data. Symptoms are the WPE j…

I'm testing a MirrorSync upgrade from v.2 to v.4 and my filtering customizations no longer work. I backed up my original script and copied the steps into the new customization script in the $hub / $findchanges section. I'm using some very simple constrains based on the example that comes disabled in the script, but I can't seem to get them to work. Question - if I make changes in the customization script on the hosted file, should I be able to test those changes without pushing a new offline version down to the client? Or does the customization script need to be the same in both my hosted and offline versions?

I think I know the answer but will ask anyway.... Is there a way to use MirrorSync to sync user accounts synchronized the server and the various clients (hub and spoke)? Here are two scenarios I'm not sure how to handle: 1. User changes a password locally. That never gets back to the server and if a new version of the solution comes out, the password is overwritten. I realize I could prohibit password changes and may do so. 2. User access rights are modified by the admin on the server. How can that get back to the user without having to download a new version?

Hi, We are setting up server to server syncing on two servers using mirror sync. where can I read how this is done. what needs to be installed where and what is the setup procedure. Thanks for you help. Mikael.

Hi, I am using Dev version 4.00591 I have a 3-file separation solution. When I create a link to download the entire solution (including data), the link initially works as exepcted and 3 files are downloaded which contain full data.. However, when subsequent users click on the link only the Interface file is downlaoded. About to submit a bug report... Thanks, ft.

Hi, I have been using v3 with good results for a year or so. I have just upgraded to v4 and re-built the configuration from scratch. All seemed to go well during config build. I have a multi-file solution and I am now trying to get a link to the solution using MirrorSync > Download Database > Create Link > Multiple... After admin credentials are entered a box shows "Retrieving list of databases", but then the following error is displayed: java.lang.NullPointerException I can only click OK, and I do not get a link copied to clipboard. Note that if I MirrorSync > Download Database > Create Link > Single... then t…

I've set up 2 previous clients with MirrorSync v3.x without problem but just trying to setup another client using v4.0. Setting a new config for Server to Pro/Go at step 2 of the hub config (Copy scripts) it does not recognise that the scripts have been pasted in when in fact they have - it refers to 3 scripts but copies 4 - obviously an update is needed. The version of MirrorSync from the java app is "4.0 build 9400" even thought the jnlp file was named MirrorSync3ConfigClient. I'm using FMS 16, FMPA 16 Error message is "Validation Failed: You will not be able to successfully sync. There is no script called 'MirrorSync'. That must exist before proceeding..…

Is there any special procedure to upgrade from 2.6 to 4.0? Previous upgrades have been essentially flawless - however I suspect there might be a hitch going forward so much? Thnx Scott

Hi There, In the setup procedure we are getting this message over and over. When we continue it seems to work fine ? What to do ? Is it safe to use ?

Hello, I'm planning to use MirrorSync to sync my FM Webdirect database to a SQL Server, one-way sync. Basically, this is for reporting purposes. But in all of the 360 Works help docs, I don't see even one guide/screenshot/anything on how to setup the SQL Server. What information is required, how does MirrorSync authenticate to SQL Server, what specific permissions does it need, etc... nothing at all. Has anyone done this who can provide some information? I work for a large organization and need to know how to setup this SQL Server before jumping into configuration. (Primarily authentication, we prefer windows authentication so will MirrorSync connect to SQL Ser…

I have just paid for and downloaded Mirrorsync, I have tried to install on my windows 10 machine and the installation fails stating "Configuration process was unsuccessful or was cancelled. Setup will now exit" Id really appreciate some guidance...?

The tutorial video by Sarah Mulligan stated that when a user synchronizes the offline file the first time before making any modifications, that they must "Enter the 'Admin' account password�". I haven't gotten to that step of the setup in a client offline file, but I am concerned that I must share this "Admin" password. Is this the password for the "Admin" user name set up in "Security�"? Or, is it the password for the admin console of the server? Or, is this the admin password created during the MirrorSync install on the server? Thanks in advance, - - Scott

We have been getting a few of these errors. The Documentation outlines how to adjust the IIS web server but we are using OS X. Previously we edited our mod_proxy.conf. However when I went to find the mod_proxy.conf file in /Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/ it does not exist. We are on OSX 10.11.6. Am I able to create this file? Anyone Know? thanks, mark

We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql databa…

We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem with a second MySQL database; the second database contains 25 million property records. The working set of data which needs to be synchronised is a small subset of data from the primary; and a single record from the secondary database into the mobile version of the application which consists of a single FileMaker file with identical tables to that of the primary mysql databa…

Is that possible to rename the device (the name that appears in the licenses list) without having to do an initial sync ? If I change the field clientname of the mirrorsync table, will it change the name in the mirrorsync config utility ? I'm asking because I always used the default naming but now I see that some devices end up having the same name and it's quite confusing when I have to delete a particular device. I would like to change it for the account name that is used to connect to the database. Possible or not ?

Hey guys, I am needing a bit of guidance on the correct workflow with the following setup. FMPHost.com (hosted): - DATA File - UI File Desktop (local): - DATA File (relative to local UI file) - UI File When adding new fields or tables to the solution, this is my assumption with regards to workflow: 1) Modify the hosted DATA file 2) Add new sync layout to hosted UI file then re-run Mirrorsync Setup to point to new sync tables 3) Download hosted files (UI and DATA) 4) Replace local UI file with hosted UI file 5) Replace local DATA file with empty clone of hosted DATA file 6) R…

I occasionally get the following error when pasting the MirrorSync generated download link into the browser. "No db parameter was supplied. Pass a separate db parameter for each database to download." Usually I can get past this by simply retrying the URL, but this time, I cannot get past it. I tried recreating the download link but it still gives me the error. Any ideas on this one? Thanks!

We seem to have some corruption in administration of licenses - see attached. Is there a way to manually remove the Device Sync Data to free up licenses. We plan a reinstall/upgrade over the Xmas break so a quick fix here would suffice.

Hello. I am trying to install Mirror Sync 4 on a FileMaker Server 16 running on macOS High Sierra (10.13.1). In the middle of the process, I get this error message: "Installation failed: Unable to install: Web server did not start after 30 seconds. Giving up." What could be the reason? Thanks! Javier

Hi, We are setting up a server to server sync with mirror sync. can i use Mirror sync 3.17 with two filemaker 16 servers? it has the same the database files. Thanks for you help Mikael.

This is my first time interacting with the MirrorSync product and I need to see if a record was updated by MirrorSync. I have the Audit Log for the day that the update was supposed to happen, but I am have very little luck in the way of deciphering the log. Is there documentation, I could look at, that would give me some idea which record and field are being described in the AuditLog?

Hi... I have recently installed MirrorSync on a windows FM15Server, successfully set it up using JDBC, downloaded the file to the iPad, changed a record, then attempted to sync. I was so excited... and then ba..bowww.... Error Last sync failed: com.prosc.sync.AbortException: [FileMaker][FileMaker JDBC] Invalid parameter binding(s). Is there a clue to where I should be looking or a log somewhere that I could see to find out what the problem might be? Any help appreciated. Thank you

Hi, One of my users synced this morning and the sync for some reason removed 20,000 records that should not have been deleted. I'm sure is a HUMAN PROBLEM - NOT MIRRORSYNC. This is a very remote user who uses the system rarely. I am trying to stop the bleeding before looking for the cause, but I am going to guess he did something like sync an archived, very old version of our solution. I've been able to recover the database from backup. I have disabled syncing for now. The 'problem user' will not sync again. Is there something I should now do to repair the data to bring the recovered/restored database in line with MirrorSync? Is now the time…

Hi, Using Mirrorsync 3. A new field is needed. It will be created on the server and added to the appropriate sync layout, new Mirrorsync script will be created, etc. There will be a lag time - a couple weeks - while existing users continue to use - and sync - their un-modified remote databases before they can download a new copy from the server. It's been a while since I made such a change... please remind me... how does this change manifest for those users who have not yet got the updated version while they continue to sync with older databases? Do they see an error on each sync saying the new field is unavailable? Just trying to mana…

I have the need to setup a mirrosync so to keep updated a duplicate db of a 4D served application so to further send out some data to a mysql application, someone have already made some experience in keep synched 4D and FMS? I'm truly newbie in this ... thanks in advance and sorry for bad english. BR Sincerely Carlo

Hi, we are setting up a server to server mirror sync. Today we do not really use Primary keys. We use keys but they are not guaranteed unique. I used a calculated field with UUID to get a Primary key. But since I used a calculation i cannot really check the boxes "Prohibit modification of value during data entry" or "Unique value". Is there any problem doing it this way? "If you are using UUID primary keys, be sure to UNCHECK the field options checkboxes that say 'Do not replace existing value of field' and 'Prohibit modification of value during data entry'. Enable the 'Unique value' validation option." Thanks Mikael

Is this still the current method to switch email dispatch about success/failure of syncs to use a specified SMTP server? Many thanks.

Hey Just been digging through the documentation in preparation for install. Excellent work on that front by the way. I've seen the section on multiple users and one device and the recommendation that each user has their own copy of the file on the device. I wanted to check to see if the following is true, whether the same file can be used with different people logging in to the same file with their own user account: All users belong to the same privilege set All users have access to all records - there are no filters/scripted found sets to limit different users and in the privilege set the Record setting is Create, edit, delete in all tables. …

Hi, I have MirrorSync 3 and would liek to upgrade to 4. My clients are mostly remote and it would be difficult to get all changes synced to the server cleanly before upgrading to 4. So, I plan to rn 3 and 4 concurrently during the crossover period. It sounds like my process will be: 1. Export MirrorSync3 settings. 2. Install MirrorSync 4, choosing the 'Hosting Provider' option during install. 3. Import MIrrorSync3 settings to MirrorSync4 and rename the occurrence from the default 'Mirrorsync' to something other than the MirrorSync3 occurrence. 4. Configure the MirrorSync4 settings in the FileMaker File (I assume there are dif…

Is there a way to modify the message for updating the remote file when the DatabaseVersion is changed?

Hello, Im having issue regarding configuring Mirror Sync. I had a working configuration and successfully was able to sync. Then I added SQL filtering to the setup and again I got correct response. Then again I wanted to add to my configuration other things but then I ran into a problem: Error while advancing to next page: java.lang.RuntimeException:java.sql.SQLException:Error -1:Unknown error. There is no way for me now to configure any more. I have removed my configuration without any luck and also I have installed Mirror Sync again. Nothing works. Any advice? Are there any hidden settings files to remove or? Best regards, Kolbeinn.

I have a date field which uses the Evaluate Function in the Auto-enter by calculation to update the date when a Signature is entered into a container field. I just found out that the date is being updated with the SYNC date instead of keeping the original date that the signature was entered. For Example: a new signature is entered in the offline file on 10/3/17, the "Date" field gets auto-entered with a date of 10/3/17. On 10/5/17 the offline file is sync'd with the host. Now the date on the host has been entered with 10/5/17 instead of 10/3/17. How do I fix this so the original date gets entered and is not based on when the sync occurs? I need to do thi…

What does this mean? "If you have a multi-file solution (ie. separation model or migrated from older FileMaker version), make sure that there is a single main file with external table occurrences referencing the other files. If you are using a separation model, this should be the data file. When you distribute offline files to your users, you will distribute the entire set of files, which will include the main sync file." Does this mean i should set up all the databases under external data sources in one of the databases? or am I misunderstanding it. Tanks for you help.

I need to reinstall for two clients running 3.16, but my latest installer is 3.12. Any way to download the one I need, or (preferably) later?

Hello We want to move from 3.17 to 4.0. We have multiple configurations. Can clients w/ a 3.17 script sync to a 4.0 MS server? If not we'll need to migrate all clients at the same time. Is there documentation that speaks to the 3.x -> 4.x migration? Thanks, Mark

MirrorSync 3 Windows - http://yourServerAddress/MirrorSync/ loads blank page we created a new instance - http://yourServerAddress/Test_MirrorSync/ and it loads normally ie blue button with Launch on it notes: - maybe related to Error 10 message - it was working at least three weeks ago tried: restarted mirrorsync service iisreset reboot i've checked mirrorsync.app.log and the last data written is days ago i will reinstall - and i am sure all will be well - ideas? UPDATE - reinstalling fixed everything - all configurations preserved

Hi guys, I am trying to set up MirrorSync with a Data Separation Model setup and need a spot of help. I have the DATA file hosted on FMPHost.com, and a local copy of the UI. The documentation states that I must set up MirrorSync in the UI file, then copy that across to the DATA file. However, the setup window only gives me the option to select the DATA file. I'm a bit stuck now, could anyone shed some light on how to proceed? Thanks in advance!

I am using MS 4.x, and I have been utilizing the Database Version field in the MirrorSync table to alert users of an update. I have increased the version number, yet I do not get a prompt on the client to download the new version. This was working before but now does not seem to prompt. What should I be checking? Thanks!

I am seeing an error after syncing when I have a new record on the spoke (FileMaker DB) to be synced into a Microsoft SQL server table on the hub. The MirrorSync setup uses a custom primary key to do the insert into the SQL table. According to the sync window as well as the sync log, the insert fails. However, when I review the table in SQL Server on the hub, the record has indeed been inserted properly. For some reason, MirrorSync is reporting this as an error. In addition, MirrorSync does not seem to remember the PK of the newly inserted hub record so if I do another sync on the spoke, it inserts it again. If I run the sync 3 times, I will have 3 new records insert…

Hi, I am trying to manage user expectations. What is the expected behavior when multiple users try to sync at the same time. Is it a consecutive line with users queued up to sync once the previous user is done? Or does MirrorSync work to sync multiple clients concurrently? Thanks, ft.

Hi, I have 16GB RAM on my OSX FileMaker server which also runs MirrorSync. I have noticed in Activity Monitor that the RAM usage is rarely over 10 GB. If I allocate the additional 5-or-6 GB to MirrorSync by modifying the modify the setenv file will it make my syncs faster? Thanks, ft.

Hi, Our Filemaker database is hosted by 360Works using MirrorSync 3. The owner wants to upgrade to MirrorSync 4 asap. Any idea on when it will be available for hosted databases? :-) Doug

I noticed that writing data is a bit faster when the layout has nothing on it. No object or field. Can we remove the fields from the sync layout on the device (iphone, ipad)? (I understand that the fields must be on the sync layouts on the server) Just a crazy idea I had this morning

I run a veterinary hospital and want to allow my clients to check their pets details, check when they are due, and create an appointment. I have a prospective programmer who says we can use mirror sync with our wordpress MySql database to update our filemaker server database. Apologies if I butchered the terminology. He says we will only need one install of mirrorsync and it will update FM in real time. Does this sound viable ? Do I need to ask more questions ? Thanks in advance for any advice. Anthony.

We are currently using MS with FMS 14 ( concurrent connections license). The new licensing (which I really hate) of FMS 15 and 16 use the notion of "users" instead of concurrent connections. How does MirrorSync work with that system ? If I have 50 different users who sync their offline database , do I really need to buy 50 FLT licenses (knowing that those users will not connect directly to the server and only use MS to sync) ?

I am running MirrorSync 3 on a FMS 14 machine (OS 10.9.5) and recently switched from using the self-signed certificate to a SSL certificate issued by a certificate authority supported by FileMaker. I was able to successfully install the SSL certificate. I didn't think I needed to make any changes in the MirrorSync configuration when I switched the SSL certificate since the configuration was already setup for SSL. Another major server change I made prior to installing the SSL certificate was I uninstalled FMS 14.0.1 & reinstalled 14.0.4 to enable communication with FM 16 clients. But according to the documentation topic "What if I need to redeploy FileMaker Ser…

Hi, I need to start filtering syncs to prevent some users (not all) from seeing commercially sensitive data. Currently all my remote (MirrorSync) users log in to the solution with the same 'sales' account, and all users get all data. I need to define what to use for $$MIRRORSYNC_USERTOKEN for filtering. Would best practice be to create FM accounts in the solution for each user in the system (I have 3 files and 18 remote users so that would be almost 60 passwords to maintain, and growing), then use the get(accountname) as the $$MIRRORSYNC_USERTOKEN? Or should I build some kind of 'Accounts' table for them to authenticate against after they login…

Hi, I need to configure filtered syncs to some (not all) remote users. This is to prevent some users from seeing commercially sensitive data available to other users. I am hoping someone can advise the appropriate strategy for me between 'Custom SQL Qualifier' and 'Mirrorsync Customization Script'. I'm using JDBC right now. I could cut over to XML, but I think JDBC is probably right for me. Can someone please confirm? I'm syncing a solution withe the following characteristics: • 3 files, 3.5Gb total • 12 tables • 18 remote users sync to Hub • Hub has 20 local users • Remote (mirrorsync) users authenticate same local FileMaker…

I have a situation that is causing me some issues. In my MirrorSync configuration I am able to download data from the HUD, make changes in the spoke DB and then sync back up and the changes are properly reflected in the HUB (Microsoft SQL) database. However, I tried to add a new record on the spoke DB and when I did a sync operation, the error on the HUB indicated that the primary key field could not be null. We manage the primary keys in our SQL database ourselves, so the next number for each table is stored and updated within the DB. MirrorSync must be expecting that our HUB table is using an Identify column to set the primary key. There is no way that I see o…

While testing various builds I will download a version do the initial sync and then do testing but never sync back the data. Currently my workflow for this is, to quit the solution, go to my Notes app on the device, and click a link to go to safari to download the build again. I would like to have some means to pass a parameter to the MS script bypass the sync operation and just like when it detects a new version prompt to download a new build, but in this case just ignore the version and get a new clean build, using the same architecture all from with FMGo using the MirrorSyncUpdater file. I would burry that button on a developer layout or other means to …

Reinstalling everything after server upgrade - have 2.406 installer but not 2.6. Where can i find that? Need to get back to square 1 before upgrading further. Scott

when making this switch is it best practice to ensure all users are synced then make the change then force everyone to update? Or can i make the change and do the vRev update when ever they perform a sync. once its on JDBC will it ignore the customization constrain find in the script for the SQL on the config? Just trying to find a clean way to cut over with out coordinating down time.

Is there a variable I can check against to see if its an initial sync or not? Initial sync meaning the first time the user has done a sync with this file. Reason: MirrorSync is telling me it cant sync (the first time) because there is records in the database. I do have one record which is used in my update process from an old file to a new file. So I just want to delete that record before the first sync to resolve this error. Thanks. Edit - I guess I could just check for any records existing in the mirrorsync table, correct?

Is there a log file or files that I can view to determine explicit SQL errors? For example, I'm getting a "data would be truncated" error during the sync which points me to the correct row of the table in question, however, I can't tell which column/field is causing the problem. It would be helpful if this was logged. It's possible that the SQL error itself does not state this, but I'd like to see the logs if available anyway. Thanks! Bob

Our problem: Mirrorsync 4.0 is not filtering any records with the script steps in the customization script. All data is synced ... . We used the xml setting in the configuration utility and "Constrain found set" in the mirrorsync customization script. The same filter worked fine in Mirrorsync 3.17 We installed the sync completely new in the database when we moved to Version 4 and copied the script steps into the new customization script.

I can't work out why occasionally my client has 1000 records or so deleted. The spokes only need to update records. Never add or delete records on the hub. Without a redeployment of the spoke file can I make a setting change in the FileMaker Hub MirrorSync scripts or on the MirrorSync Server to stop any deletions?

More curiosity than anything... We would like on occasion to Cancel a sync from the MS Console. It doesn't always work. Is there another means of cancelling a sync? Thanks, Mark

In an offline file a traditional sync would mirror all the data from the host to the files however in some work flows that could take longer for the initial sync especially for a lot of resource tables needed just for navigation or system logic. now that we have native JSON parsing in FM16 would it be faster to sync a single table with arrays of information and then logic on the remote device to explode out to interface tables or virtual lists table based on the array over mirroring multiple tables and records. Especially if the sync is only a one way push out to the remote and business logic doesn't require these tables to be modified or sync back to the host.

When using MirrorSync, backend development doesn't stop and it can be tedious to get the word out to inform all users that a new version of your solution is available to download. Here is a technique to do just so: Step 1: Create a table in your solution VERSION this table will have the minimum fields of a UID | version | URL | Time Stamp Create | Time Stamp Modify Step 2: Add this layout to your existing mirror sync layouts sync_version and put all fields on the layout as required by MS, and configure the table to sync hub to spoke ignoring changes in spoke and hub always wins conflicts. Step 3: Add a record to this table and start the version …

I'm curious about this new feature. What I particularly want to know if the process requires an initial sync after the download of the new version .

After a quick search, I couldn't find anything about MirrorSync and FileMaker Cloud. Is MirrorSync compatible with FM Cloud? Found it in the MS documentation, yes with an asterisk.

Is there a way to automatically run a script if the user ends up downloading a new "version" of the database?

I'm new to MirrorSync but not new to FileMajer (I have my verion 1 disks still from 1985). The documentation seems to indicate that primary serial keys and timestamps are all you need, but in the advanced topics it seems to indicate that those primary keys should not be used in relationships? I'm confused here about the way the sync works. I'm a Pediatrician (now in my 35th year) and will be spending next summer doing health assessments up in Onaville, Haiti. I've developed a slimmed down version of the FileMaker EMR that runs my medical practice (since 2000) to help me do this. MirrorSync seems to indicate that simple primary keys and timestamps are all I need in ea…

I am building an update process for my mobile FM database - I would like it to sync first and only update if the sync is successful. Is there a variable in the MirrorSync main script that I could possibly have return true/false for successful or not? I cant seem to find the part of the script where it exits and says "Sync Successful". Thanks.

Hi Everyone, hope you are all fine.. We have set up our database and seem to sync fine from a ios device. When the fresh file was downloaded to ios device.... when a new record was created the device id was displayed/identified as: 1.001.. The second record was created from ios device and the record id was displayed/identified as: 1.002 .. We then developed/changed the main file on the server and re-distributed the file from there to the ios device again... when creating the next record from the ios device, the record id is: 2.003. The question is, why did the device id change from "1" to "2"? Is this normal? The proble…

Hi, Are there any recommended settings for 'sleep' on Mac OSX clients? Will the sync process keep a Mac client awake or should we consider using System Preferences to set longer times before sleep kicks in? Thanks, ft.

A customer running Mirror Sync 2 has moved offices, subsequently getting a new external IP address. I did not set up Mirror Sync in the first place, but can see from looking at the script that the external IP address is coded there. The documentation says that it is necessary to run the configuration again. Is this really necessary, or could we simply update the IP address in the script and distribute new copies of the file to remote users? Is it possible to code a DNS name (e.g server.client.com) instead of an IP address, in case this happens again? Thanks in advance.

Hello We received this error today from a spoke that had just the day before completed (successfully) that spoke's initial sync. It seems curious, but thought I'd run this by the community. Thanks, Mark Nov 02, 2016 1:43:51 PM com.prosc.mirror.config.server.SyncServer$3 callSEVERE: Sync between filemaker8.oda.state.or.us / BeFoodSafe5 (FileMaker Server) and bcripe iPad BeFoodSafe( username 'developer', running Go_iPad 15.0.2 on 70.57.121.30, ping time: 558 ms, machine name: 'bcripe' )Last sync failed: com.prosc.sync.AbortException: The hub database has the same identifier as one of the spokes: '2'. Please get a new offline spoke database for syncing, and th…

Hello, I am using MirrorSync 3 with about 10 iPads. On the iPad solution, I have an update script that installs a new version of the file. As part of that process, all records are exported from the old file, and imported into the new file. What is happening is that after I release an update, MirrorSync on the iPad is deleting all the records and then inserting them all again after this update process is completed. I am assuming that something I am doing during the update process is confusing mirrorsync and it just decides to delete everything and re add it. Here is the process my update script goes through: Old file: Go to every layout and "SHOW ALL RECO…

Hello, I noticed that on the server in which MirrorSync is installed, one of the mirrorsync.data files was 12GB+ in size. It is in the filepath formula C://Program Files/360WOrks/SyncData3_MirrorSync/FileMaker Server_x.x.x.x_FileName/mirrorsync.data Is there any way to either reduce the size of this file, or stop it getting any bigger? Thank you in advance for you help Lewis

Hello, We are in the process of updating our FileMakerGo on the iPads from 13 to 16 but we are running into an issue with the sync. We are currently running MirrorSync 2.3 but will eventually upgrade to 3. Meanwhile, we need to get FMGO 15 or 16 work with our current MirrorSync. The sync error doens't always show, sometimes it syncs and sometimes it doesn't. Any ideas? Thanks

I have the following error when syncing from ipad: inser operation for table.... nodId '54CAOBFC-6863-4181-93FB-BB74F722B1D4'. [FileMaker][FileMaker JDBC] (201): Cannot modify field.

Since going from version 2 to 3 of MirrorSync last year we have constantly had MirrorSync crashing the Web Publishing Engine. Sometimes it says "Error from server: FileMaker XML WPE Web Publishing Engine is not running at <the hosted IP>. Ensure that the WPE is working correctly, and then try this operation again." But usually it is an Error 10 error. "Error 10 while connecting to http://<the hosted IP>/sync?ping=1&config..." Early on we made the documented suggested changes for this error, to the connectionTimeout Property in the IIS Manager application. With no noticeable effect. Most of the time MirrorSync works as expected and does…

Hi, I have a server and 15 mobile clients in different countries. Some clients have very slow network connections. Sometimes significant data changes need to be made on the server. This can include importing records and deleting records. A number of tables have over 50-100,000 records and one table have 1,500,000 records. Records are never deleted on clients. If significant additions/deletions are made to data on the server is it worthwhile to have a local machine on the same LAN as the server to do the first sync following the changes (to work out which records were deleted on the server, etc)? Thanks, ft.

Hello all - So I got a larger MirrorSync installation to run beautifully between two FMS15 server sites. Sync times are a charm. My question is what the best practice is to make MirrorSync sync fastest. Currently, our hub server is in a colocation datacenter in Los Angeles with Gigabit connection. The spoke server is in our branch office, syncing through a 100/50 Mbit connection. MirrorSync server runs in the same datacenter as the hub server. My question is whether it would make sense to install the mirror sync server at the branch office location instead. That way, mirror sync could connect locally to the spoke server at…

Hi everyone, we use FMGo 16, a FM Server 14 and FMPA 15 Syncing works fine except that in new records the two auto enter mod fields (created by, changed by) are set to the "local" user of the iPad Means USER1 creates on IPAD1 a record and after USER2 syncs the new records to IPAD2 the value for all MOD Fields show that USER2 created the record and changed it. I have not included the "modified by" field in the sync layout. (Thought I read somewhere I shouldn't do this ...) The mod fields have the settings "Do not change Value when entered", "Check Values only when entered", "User is allowed to disable check of data when entered" (Please excuse i…

Hello all - I'm thinking about MirrorSync for a Filemaker Server to Filemaker Server replication. The old problem: Office in CA, Office in NY - latencies kill the Filemaker Pro clients that are on the other coast when connected to FMS on the other coast. Think of our database as a medical records system for patients in a clinic that also manages patient handling. Currently, we have one main table, PATIENTS. One of the fields in this table, PATIENT_STATUS, is a numerical value that ranges from 0 to 6 (0 patient just showed up, 1 patient in waiting room, 2 patient seeing the nurse, 3 patient seeing the doctor, 4 report tran…

I have several people using FM15 on iPad that are set up for MirrorSync. They are sporadically getting kicked out of FM and having to relog into database with some of the data from right before the log out missing. Has anyone else experienced that?

I have been trying to set up MirrorSync with my database. I am fairly sure I have followed the instructions but when I try to up all my sync tables I get an erroras shown in the attachment. The are 24 tables in total. I have tried a shared server 14 in Sydney from FMPHosts for several weeks. I contacted MirrorSync and they think it may be the server speed. I and am now trying a dedicated server 16 also from FMPHosts and still getting the same errors. I have checked all the tables to ensure there is a creation timestamp, modification timestamp and created by field. There were a few tables that had a modified field and I thought this may be the problem. I removed th…

Hello We have frequently observed this error. We are curious if 360Works knows if this has been fixed in FMS 16. We are interested in knowing if there is something about the content of the records this affects that we could avoid while retaining the JDBC sync. Also interested if, or how much, switching to XML affects the client's sync. Duration only I suspect. I'd assume the switch to XML is a 'server side' change only and does not require a client update. Let us know if that is incorrect. • update operation for table FileMaker Server xxxxx failed for target nodeId '1B207AE7-4063-4BF9-B450-62522235B189'. A bug in the FileMaker JDBC driver prevented record '…

Hello, I'm very new to MirrorSync. Now syncing hub (FM server) to spoke (FM Go). Is there a safe way to purge all data on client (spoke) and force download from server (hub) by scripting? In other words, I want to force syncing on client side as an initial sync by scripting. Thanks

2 problems that may be related 1.Starting a few days ago I sometimes get an error message (Unexpected response from Mirrorsync server) . It seems to happen when I haven't synced in a few hours. When I retry 2 seconds after the error message it works just fine....apparently anyway. 2.We got a wrong deletion of a record that was just inserted in the same sync. In the log there was this line WARNING: Deletion scanning mismatch in NodeReference for hub node FileMaker Server ... with associated spoke node Client node .. on iPhone Go ... Deleted record count (1) - extra count (0) does not equal expected missing recount count (0). This will probably le…

Hi. We have successfully created a Filemaker Server to Filemaker Server configured. When we tried to add another Filemaker Server to Filemaker server configuration, we got an error "You have exceeded the limit of 1 Filemaker Server to Filemaker Server configuration for this license." In our license, we can sync up to 2 configurations.

During the installation of MirrorSync I can not select the spoke database if I select the option to use a separate mobile file. I get an error message thta MirrorSync can not get the database names (image mirrosync2). However database names are available when I select the hub database (image mirrosync1). When I select the option sync with an emtpy clone or complete copy of the main file I can continue the installtion process. Any idea why Mirrosync can not find db names for the spoke database?