Hello,

I've installed MirrorSync and tried to integrate with FileMaker Server 12 Advanced

I've tried to use the Contact Management Database (sample database) but didn't manage to make a first initial successfully sync (I've tried a sync between a local FileMaker Pro and Server).

I get when I launch the sync (I've attached the client log (from debugging tab) and server log)

Can you please help me?

Thx

Log.zip

Hello Amoise - thanks for sending the client and server log file, that is very helpful. The problem is happening because for some reason, the MirrorSync version is not being transmitted by the client to the server. Let me show you the difference between I have in my client log compared to yours.

Here is mine:

== 7/4/2012 6:41:02 PM

POST http://apollo.local:8080/MirrorSync/sync?clientToken=21.1341333906689.wug1t&messageToken=&sessionId=6:41:02x15257531311362981796&lastSessionId=6:39:12x76643883576616644859

{"tables":{"Sync_contact":{"count":20001,"modTime":"7/3/2012 2:38:33 PM","cols":["Address_Type1","Address_Type2","City1","City2","Company","Date_Created","Date_Modified","Email","Instant_Messaging","Name_First","Name_Last","Phone1","Phone2","Postal_Code1","Postal_Code2","State_Province1","State_Province2","Street1","Street2","Timestamp_Created","Title","UserName_Created","UserName_Modified","Website","k_ID_Contact","Timestamp_Modified"]},"Sync_notes":{"count":0,"modTime":"7/3/2012 11:45:05 AM","cols":["kf_ID_Contact","Text","TimeStamp_Creation","UserName_Created","UserName_Modified","k_ID_Record","TimeStamp_Modification"]}},"clientName":"Jesse Barnum's ProAdvanced 12.0v1 (Mac)","formatTime":"2/3/2001 8:30:40 PM","clientTime":"7/4/2012 6:41:02 PM","version":"1.136","configurationId":"05dae345-0871-4272-9784-08450460a774","username":"Admin","password":"","platform":"1","deviceId":"A797C086A98ACF1D4517C4941FC18C26","macAddresses":["00:26:08:c7:2b:5f","00:26:4a:11:e9:a6","00:26:bb:03:1b:be"]}

Here is yours:

== 7/4/2012 3:15:07 PM

POST http://pdc-uat-net02.ubisoft.org/MirrorSync/sync?clientToken=&messageToken=&sessionId=3:14:59x29530985886231065&lastSessionId=

{"tables":{"Sync_Contacts":{"count":2,"modTime":"7/4/2012 2:45:53 PM","cols":["Address_Type1","Address_Type2","City1","City2","Company","Date_Created","Date_Modified","Image_Data","Instant_Messaging","Name_First","Name_Last","Phone1","Phone2","Postal_Code1","Postal_Code2","State_Province1","State_Province2","Street1","Street2","Timestamp_Created","Title","UserName_Created","UserName_Modified","Website","k_ID_Contact","Timestamp_Modified"]},"Sync_Notes":{"count":0,"modTime":"","cols":["kf_ID_Contact","Text","TimeStamp_Creation","UserName_Created","UserName_Modified","k_ID_Record","TimeStamp_Modification"]}},"clientName":"FileMaker Pro 12 Trial's Pro 12.0v1 (Windows)","formatTime":"2/3/2001 8:30:40 PM","clientTime":"7/4/2012 3:15:07 PM","version":"","configurationId":"2edc196d-1cf1-4bc1-b7ad-3b9546cbffd9","username":"xxxxxxx","password":"xxxxxxx","platform":"-2","deviceId":"BB633D0C4621243F16BFDB40601A602F","macAddresses":["00:50:56:a5:03:29"]}

Notice the bolded "version" part - that should contain the version of MirrorSync used to create the script. This is set near the top of the script:

Set Variable[ $mirrorSyncVersion; value:1.136]

Please make sure that you have that script variable set. If everything looks correct, I would recommend re-copying and pasting the script steps.

If this does not solve your problem, please send me an empty copy of the database you are trying to sync so that I can examine the script to see what is wrong.

Hello Jesse,

The generated script had the version commented. I've uncommented and it worked. Thanks for your quick help.

I've ran some syncs everything was ok for various fields, except syncs on images (Image data field). I have a strange 802 error when trying to sync records with images (either if I try from client to server or the other way around).

I've attached again the logs

Thx,

Alex

Log.zip

Amoise, these look like the same log files that you originally sent me... could you try reproducing the problem again and then send me the most recent log files?

Hello Jesse,

You are right. See the newly attached files. And the scenario is pretty simple, I've updloaded a picture to the client database and tried to sync afterwards.

Thx,

Alex

Log 09-07-2012.zip

I see what you're talking about. Sometimes when the script steps are pasted into the MirrorSync script, the external script references don't work. I think that is what is happening here. Go to File->Manage->External data sources and make sure that the file reference listed there is correct, and that the file is reachable from wherever you are accessing it from. Once you do this, you may need to re-copy the MirrorSync script steps.

It worked after I edited the external sources (I've replaced full DNS with IP and it worked).

Thx for your help,

Alex

Great! Thanks for letting me know, and be sure to post any other problems you run into.