Mark Stuller Posted March 20, 2017 Posted March 20, 2017 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" >= ?
Mark Stuller Posted March 20, 2017 Author Posted March 20, 2017 Solved. It doesn't like the question mark....
Recommended Posts
This topic is 3072 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now