Jump to content

Mark Stuller

Members
  • Content count

    53
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark Stuller

  • Rank
    ThirstyForKnowledge

Profile Information

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

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra
  1. Cleaning MirrorSync files

    Perfect, thanks.
  2. 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
  3. 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.
  4. 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.
  5. Sync failed/Aborted Error

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

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

    Solved. It doesn't like the question mark....
  12. 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 10.0.6.35, 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" >= ?
  13. Resetting *one* config for a client

    Thanks Jesse I suspected that. No worries! Mark
  14. 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
  15. Too Many Clients error

    Ok, sorry guys. I found the issue and resolved it. Mark
×

Important Information

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