Mark Stuller

Members
  • Content count

    43
  • Joined

  • Last visited

Everything posted by Mark Stuller

  1. Solved. It doesn't like the question mark....
  2. 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" >= ?
  3. Thanks Jesse I suspected that. No worries! Mark
  4. 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
  5. Ok, sorry guys. I found the issue and resolved it. Mark
  6. 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
  7. Thanks Jesse. Sounds good.
  8. 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
  9. 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
  10. Thanks Jesse. I'll get it installed as soon as I'm back in the office. Appreciate your work for us all. Mark
  11. 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
  12. 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.
  13. 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
  14. This was resolved by restarting Tomcat manually. Thanks Tsiry!
  15. 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
  16. 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
  17. 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
  18. 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
  19. I was thinking this is a client issue as a force-quit of Go and subsequent sync completed successfully...
  20. 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>
  21. Hi Jesse We have "conflict resolution strategy set to 'most recent wins'" Mark
  22. FWIW We performed a force-quit of FileMakerGo and the client was able to sync successfully!?! Mark
  23. 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 70.57.121.30, 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.
  24. I believe this is a FileMaker error, passed thru by MirrorSync. Seems there's a FileMaker Server (15.02 under 10.12) corroborate? And how's the best way to shutdown MS 3.11006? I have ghost connections I can't, but believe I should, terminate. Thanks, Mark
  25. Anyone know what the impact is and/or the remedial steps if during a Repair a Spoke attempts a sync? Thanks, Mark