AnsweredAssumed Answered

JDBC Issue - 501 Runtime error (Field failed time value validation test) on Import  (***Resolved***)

Question asked by disabled_morkus on Feb 17, 2016
Latest reply on Feb 18, 2016 by disabled_morkus

Hi all,

 

I was doing a rather simple import of some data to FMP 14 via JDBC when after three successful records imported, I got this error:

 

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC]  (501): Field failed time value validation test

 

----------------------------------


SOLVED IT!


For some reason, the JDBC "ALTER TABLE ADD [COLUMN NAME] [FIELD_TYPE]* DDL that I used to create the field marked that field as *always validate.*

 

The first three records had null for the single Timestamp field but the fourth record, which was the cause, had this: 11/01/1990 0:00:00.

 

It doesn't seem that FileMaker liked the zero time portion - at least not with that validation option.

 

SOLUTION: I turned off the validation options for that field in FM's field options so it was the default:

 

Import worked fine for all 20,000 records after that.

 

- m

Outcomes