Mark Stuller

Members
  • Content count

    43
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark Stuller

  • Rank
    ThirstyForKnowledge

Profile Information

  • Gender
    Male
  • Location
    Salem, Oregon USA

FIleMaker Profile

  • Profile Updated
    10/17/2016
  • FM Application
    15 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
    Expert
  • Membership
    TechNet
  • Industry
    State Government
  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. Thanks Jesse. I'll get it installed as soon as I'm back in the office. Appreciate your work for us all. Mark
  10. 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
  11. 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
  12. This was resolved by restarting Tomcat manually. Thanks Tsiry!
  13. 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
  14. 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
  15. 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