Mark Stuller

Invalid parameter binding(s)

2 posts in this topic

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 call
SEVERE: Sync between / 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" >= ?

Share this post

Link to post
Share on other sites

Solved. It doesn't like the question mark....

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By martygearbox
      I am using MirrorSync 3.02
      My scenario has 2 teams each syncing to the same file on the server.
      We will have 2 Sync configs, 1 for each team.
      Team A Sync config using JDBC
      Team A will get an offline copy of the same file that is on the server, with ALL the data.
      Team A will sync ALL tables (2 way sync).
      No problem there.
      Team B Sync config using JDBC
      Team B will get an offline copy of the same file that is on the server, but with only a SUBSET of the data (we will take a full offline copy and then delete many of the records).
      Team B will sync a subset of the tables (2 way sync).
      When team B syncs, will MirrorSync detect the missing records as deletes and the delete the associated records on the server? ( this is not what we want ).
      If yes, is there a way to prevent this or a better way to handle it? XML and the customization script and disable deletes?
    • By vargas
      I need some help.  I have  a database with id and need to update the name of the current record only from an oracle database.  I can connect (odbc) to the oracle database and can import by match, but there are some many records and takes a while. Is there a better solution, like jdbc, or a plugin. Currently using filemaker 14 on windows 7.  Please advice.
    • By Tony Morosco
      I am investigating interrelating FileMaker and ArcGIS databases.  I am from the botanical world and design databases on a simplified level, so please bear with me!
      For instance, (and this is an over-simplified version) in both ArcGIS and FileMaker, we have a field in our databases which lists a plants status as alive or dead.  Both of these databases are available outside, in the garden.  We often would like to update just one source, and correct a plant's status in the garden on both systems.  This would alter both the ArcGIS and the FileMaker databases, through just one update, probably in FileMaker Pro is my guess.
      I am imagining this can be accomplished through JDBC, ODBC, or SQL.  Ideally it would be via SQL.  It will provide a portal between the two systems, and update each others tables whenever the need arises.
      From what I understand, this should be possible.  If for some reason we can't get the two databases talking directly with each other, perhaps inter-relating the two with a back-end SQL database is a possibility?  We may try to build a FileMaker web portal to an ArcGIS web-viewer which can be updated, but it is kinda kludgey and does not update both tables.
      If anyone knows a method how this can be accomplished, please let me know!  Or reccomendations on where I can post to the correct forum. 
      And please let me know if I am not making any sense or I am garbling the language.  I am known for both. ;-)