Jump to content

Mark Stuller

  • Content count

  • Joined

  • Last visited

Everything posted by Mark Stuller

  1. Canceling a sync

    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
  2. Canceling a sync

    Hello Without feedback yet I thought I'd try asking this question from a different tack. What is the best method to cancel someone's sync from the server side? We have security updates that need to be installed to our FileMaker servers (SSL certificates are expiring) but staff don't read our emails asking for a pause in syncing and so we are finding it difficult to set a maintenance window. If we can cancel their sync without causing any disruption that'd work fine for us. Thanks, Mark
  3. Cleaning MirrorSync files

    Perfect, thanks.
  4. Cleaning MirrorSync files

    Hello We have a MirrorSync installation with 7 configurations and 144 devices syncing. One of the configurations data file is 80gb. So we are using a fair amount of disk space. We are interested in how we can 'trim' down the files MS generates - *safely*. So, is there any guidance on how to cull these files? Thanks, Mark
  5. Hub/spoke same name?

    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, 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 then try again.
  6. Sync failed/Aborted Error

    Yes, our user's scripts are at 3.17. Server: 360Works MirrorSync 3.17, build 9239 (3/24/17) Clients: Generated "3.17" By MirrorSync Version 2017-04-25 11:12:12 And we do still get disconnects. Fewer tho.
  7. Sync failed/Aborted Error

    fwiw, we are on 3.17 and still get these errors routinely. Users 'merely' re-try and often a single re-try completes. It may be explained by the mix of versions.
  8. Sync failed/Aborted Error

    A good question - that I hope Jesse can weigh in on.
  9. Sync failed/Aborted Error

    Speed is not the issue. Ping time is a rough, but fairly effective metric of 'reachability' https://en.wikipedia.org/wiki/Ping_(networking_utility)
  10. Sync failed/Aborted Error

    Probably a "Connection disruption". Fairly standard. We get this ~25% of the time. Most clients are in an area with just 'ok' connectivity. Good enough for voice, data not so much. We have found a VPN connection helps by keeping the connection 'alive'. hth
  11. FileMaker JDBC Bug

    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 '1B207AE7-4063-4BF9-B450-62522235B189' from Client node xxx on xxxx from being written to FileMaker Server xxxx. You can delete this record and retry the sync, or you can switch to XML for the sync. Please report this problem to 360Works so that we can forward it to FileMaker. [1 more warnings like this] Thanks, Mark
  12. FileMaker JDBC Bug

    Thanks Jesse
  13. FileMaker JDBC Bug

    Thanks Jesse. I was hoping this was the answer. Any tho't on if there is an issue with the content to the records that precipitates the error (so that we can avoid it)? Any any idea on the 'efficiency' angle? Say, is XML a ##% slower sync generally? Thanks again. Mark
  14. I am getting a new error. I thought I could decipher SQL but don't see an error in the included SQL snippet. I could move to XML, but hope not to. Thanks, Mark --------- Mar 20, 2017 11:20:55 AM com.prosc.mirror.config.server.SyncServer$3 callSEVERE: Sync between data.oda.state.or.us / MAFIS (FileMaker Server) and rludy( username 'developer', running Go_iPad 15.0.3 on, ping time: 8627 ms, machine name: 'rludy' )Last sync failed: com.prosc.sync.AbortException: [FileMaker][FileMaker JDBC] Invalid parameter binding(s).SQL statement: SELECT "C_PATHOGENCROP"."UUID", "C_PATHOGENCROP"."z_ModifiedTS", "C_PATHOGENCROP"."?SynonymName", "C_PATHOGENCROP"."CompanyInfo", "C_PATHOGENCROP"."CropListAppear", "C_PATHOGENCROP"."DiseaseName", "C_PATHOGENCROP"."ID_Crop", "C_PATHOGENCROP"."ID_Pathogen", "C_PATHOGENCROP"."Listed", "C_PATHOGENCROP"."Notes", "C_PATHOGENCROP"."PathogenOther", "C_PATHOGENCROP"."PathogenRequirements", "C_PATHOGENCROP"."PathogenSeedborne", "C_PATHOGENCROP"."Rating", "C_PATHOGENCROP"."ReferenceSource", "C_PATHOGENCROP"."SecondInspectionRequired", "C_PATHOGENCROP"."xCropBotanicalName", "C_PATHOGENCROP"."xCropCommonName", "C_PATHOGENCROP"."z_DeletePermission_n", "C_PATHOGENCROP"."z_EditPermission_n", "C_PATHOGENCROP"."Researched_n", "C_PATHOGENCROP"."YearRequest", "C_PATHOGENCROP"."z_CreationTS", "C_PATHOGENCROP".ROWMODID AS MirrorSync_ETag, "C_PATHOGENCROP".ROWID AS MirrorSync_InsertOrder FROM "C_PATHOGENCROP" WHERE "C_PATHOGENCROP"."z_ModifiedTS" >= ?
  15. Invalid parameter binding(s)

    Solved. It doesn't like the question mark....
  16. We have clients/spokes with several configurations active at the same time. We would like to reset just one leaving the other alone. How/can that be done? Thanks, Mark
  17. Resetting *one* config for a client

    Thanks Jesse I suspected that. No worries! Mark
  18. Too Many Clients error

    Hello I have just set up a new configuration. For the initial sync I am getting the attached error. There are of course no 'Client' records in the MirrorSync table. Am I missing something obvious? Thanks, Mark
  19. Too Many Clients error

    Ok, sorry guys. I found the issue and resolved it. Mark
  20. Oracle <--> Filemaker

    Hello We are going to take the plunge and setup a sync between our Oracle tables and 'shadow' FileMaker tables and we're seeking input. One thing we are wondering about is a 'one-way' sync. We don't want changes to be sync'd back to Oracle. The bigger issue is that we don't want deletions in the Oracle table to be deleted in the FileMaker table. There often are children to these records we don't want deleted or orphaned. As well, are there any gotchas we should consider? I've read the Advanced topics and feel mostly comfortable but you never know what you don't know! Thanks, Mark
  21. Oracle <--> Filemaker

    Thanks Jesse. Sounds good.
  22. Recovery Mode

    Hello We have had situations where a record has been deleted from the Hosted database and then reappeared. I've chalked this up to a client getting into Recovery Mode. That Spoke still has that record and so for safety's sake, MS will recreate that on the hosted side. Does that reasonable? If so, what *will* put a Spoke into Recovery Mode? If any sync fails, does the next sync put them into RM? Do they stay in RM until they have a successful sync? If that is so should a Spoke then seek to have a successful sync *as soon as possible* to keep Recovery Mode from putting records 'back' that were deleted? i.e. the longer a Spoke has a Failed sync 'pending' the longer this circumstance creates a higher likelyhood for this to occur. Anything else about RM that's valuable to know? Thanks, Mark
  23. Recovery Mode

    Thanks Jesse. I'll get it installed as soon as I'm back in the office. Appreciate your work for us all. Mark
  24. Hello We have occasionally received this error. It occurs when a spoke experiences a failed sync and then immediately retrys. What does this mean and how long is a good rule-of-thumb for "Try again later"? Thanks, Mark
  25. Sync errors

    Wondering if anyone knows what to make of these errors: From: mirrorsync_server@360works.com Reply-To: mirrorsync_noreply@360works.com To: admin-sync-bfs@oda.state.or.us Subject: Sync failed for config 'BeFoodSafe5' running on Oct 13, 2016 12:42:36 PM com.prosc.mirror.config.server.SyncServer$3 call SEVERE: Sync between filemaker8.oda.state.or.us / BeFoodSafe5 (FileMaker Server) and sschwab iPad BeFoodSafe( username 'developer', running Go_iPad 15.0.2 on, ping time: 476 ms, machine name: 'sschwab' ) Last sync failed: com.prosc.sync.AbortException: Sync was interrupted/canceled while waiting for client to receive HTTP message. Reason: Sync was canceled because remote user started a new sync on the same device. Oct 13, 2016 2:48:29 PM com.prosc.mirror.config.server.SyncServer$3 call SEVERE: Sync between filemaker8.oda.state.or.us / BeFoodSafe5 (FileMaker Server) and sschwab iPad BeFoodSafe( username 'developer', running Go_iPad 15.0.2 on, ping time: 735 ms, machine name: 'sschwab' ) Last sync failed: com.prosc.sync.AbortException: com.prosc.sync.AbortException: Sync was interrupted/canceled while waiting for client to receive HTTP message. Reason: Sync was canceled because the remote user's session expired. This probably means that their device was turned off, lost network access, or exited FileMaker. Thanks for your help.

Important Information

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