Jump to content

Mark Stuller

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark Stuller

  • Rank

Profile Information

  • Industry
    State Government
  • Gender
  • Location
    Salem, Oregon USA

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. 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
  2. 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
  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. 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.
  6. 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.
  7. Sync failed/Aborted Error

    A good question - that I hope Jesse can weigh in on.
  8. 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)
  9. 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
  10. FileMaker JDBC Bug

    Thanks Jesse
  11. 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
  12. 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
  13. Invalid parameter binding(s)

    Solved. It doesn't like the question 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. Resetting *one* config for a client

    Thanks Jesse I suspected that. No worries! Mark

Important Information

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