We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Mark Stuller

Members
  • Content count

    46
  • Joined

  • Last visited

Everything posted by Mark Stuller

  1. 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
  2. FileMaker JDBC Bug

    Thanks Jesse
  3. 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
  4. 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" >= ?
  5. Invalid parameter binding(s)

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

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

    Ok, sorry guys. I found the issue and resolved it. Mark
  10. 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
  11. Oracle <--> Filemaker

    Thanks Jesse. Sounds good.
  12. 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
  13. 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
  14. 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
  15. 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 10.0.4.57 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 107.77.213.218, 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 107.77.213.218, 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.
  16. 360Works Admin.jar

    Hello I updated our 3.x server to 3.12 this morning. I'm unable to use the /Applications/360Works Admin.jar file however. The enclosed is all that I get. Ideas? Thanks. Mark
  17. 360Works Admin.jar

    This was resolved by restarting Tomcat manually. Thanks Tsiry!
  18. 360Works Admin.jar

    Just tried to re-install this morning. It would not complete. Sending the Teamcat stderr to 360Works. The server works but managing it is more difficult. Mark
  19. Canceling a sync safely

    Hello We have a spoke that just cannot get sync'd. What is the best/cleanest way to cancel that sync on the hub? The spoke has received a message like: Sync Error. Start: 11/7/2016 8:37:48 AM Duration: 5 Minutes 52 Seconds Version: 5.01 The MirrorSync URL returned an empty response. This may be a temporary network problem. If it continues, verify that the server is running properly by checking this URL in your browser: https://mirrorsync3.oda.state.or.us/MirrorSync/sync and is no longer syncing. Subsequent attempts to sync are aborted with the same message. At this time the last attempted sync was ~19hrs ago but the server still reports that spoke is still syncing. Using the Admin App to Stop the server doesn't seem to do it. When the Start server is used the session just reappears. Thanks, Mark
  20. Canceling a sync safely

    Hey Jesse Using the MirrorSync Admin utility seems to work - if there's only one sync occuring at the time. If there's more than one it appears to be hit or miss that you cancel the one that you intended to. Mark
  21. We received the below but have auto-resolution turned on for this configuration. Ideas? Thanks, Mark Nov 09, 2016 8:19:16 AM com.prosc.mirror.config.server.SyncServer$3 callSEVERE: Sync between filemaker8.oda.state.or.us / BeFoodSafe5 (FileMaker Server) and swong iPad BeFoodSafe( username 'developer', running Go_iPad 15.0.2 on 76.115.11.132, ping time: 471 ms, machine name: 'swong' )Last sync failed: com.prosc.sync.AbortException: Complete manual conflict resolution, then sync again
  22. Manual Conflict w/ Automatic on..?

    I was thinking this is a client issue as a force-quit of Go and subsequent sync completed successfully...
  23. Understanding the log...

    Hello We are monitoring the /Library/360Works/Application/logs/Mirrorsync.yyyy-mm-dd.log file to understand what/where our server is at. We currently have 6 spokes syncing but they are apparently not getting anywhere. We see a recurrence of the below over and over again. Of course the IP address is just one of the 6. Generally what are we seeing here? Thanks, Mark Nov 10, 2016 8:14:37 AM PST com.prosc.infrastructure.DumpFilter doFilter FINE: ---> REQUEST #30516 on thread ajp-bio-42423-exec-345: GET /MirrorSync/sync?databaseId=21&messageToken=&sessionId=6:54:02x022368124839535208359&lastSessionId=&mode=nowait&random=18557748024754439076 host: mirrorsync3.oda.state.or.us user-agent: FileMaker/15.0 accept: */* accept-encoding: deflate, gzip X-Forwarded-Proto: https X-Forwarded-Port: 443 x-apple-service-webcalssl-enabled: true x-apple-service-profile-manager-enabled: true X_FORWARDED_PROTO: http X-Forwarded-Host: mirrorsync3.oda.state.or.us X-Forwarded-Server: webpublic3.oda.state.or.us connection: Keep-Alive from IP address 71.95.116.123 Nov 10, 2016 8:14:37 AM PST com.prosc.mirror.config.server.http.SyncServletModel getMessageForClient FINE: Received GET request from client for sequence number null (currentMode is waitingForServer) Nov 10, 2016 8:14:39 AM PST com.prosc.infrastructure.DumpFilter$1MyResponseWrapper logResponse FINE: <--- RESPONSE #30511 (duration 10007 ms): 200 GET /MirrorSync/sync?databaseId=26&messageToken=&sessionId=8:13:31x3973105989601507515&lastSessionId=&mode=nowait&random=72605910356395542138 <html><head></head><body><!--RETRY--></body></html> Nov 10, 2016 8:14:40 AM PST com.prosc.infrastructure.DumpFilter doFilter FINE: ---> REQUEST #30517 on thread ajp-bio-42423-exec-330: GET /MirrorSync/sync?databaseId=26&messageToken=&sessionId=8:13:31x3973105989601507515&lastSessionId=&mode=nowait&random=38982978163147463668 host: mirrorsync3.oda.state.or.us user-agent: FileMaker/15.0 accept: */* accept-encoding: deflate, gzip X-Forwarded-Proto: https X-Forwarded-Port: 443 x-apple-service-webcalssl-enabled: true x-apple-service-profile-manager-enabled: true X_FORWARDED_PROTO: http X-Forwarded-Host: mirrorsync3.oda.state.or.us X-Forwarded-Server: webpublic3.oda.state.or.us connection: Keep-Alive from IP address 70.210.153.69 Nov 10, 2016 8:14:40 AM PST com.prosc.mirror.config.server.http.SyncServletModel getMessageForClient FINE: Received GET request from client for sequence number null (currentMode is waitingForServer) Nov 10, 2016 8:14:42 AM PST com.prosc.infrastructure.DumpFilter$1MyResponseWrapper logResponse FINE: <--- RESPONSE #30512 (duration 10004 ms): 200 GET /MirrorSync/sync?databaseId=11&messageToken=&sessionId=7:52:38x22719381768590507509&lastSessionId=&mode=nowait&random=31744128890209555305 <html><head></head><body><!--RETRY--></body></html>
  24. Manual Conflict w/ Automatic on..?

    Hi Jesse We have "conflict resolution strategy set to 'most recent wins'" Mark
  25. Manual Conflict w/ Automatic on..?

    FWIW We performed a force-quit of FileMakerGo and the client was able to sync successfully!?! Mark
×