NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The invalid dates are cause by import, migration or editing directly in the table. This error have been found so far in table ''fieldreport'' and ''link''. You get errors during creation of the raw PostgreSQL dump.
The error message is both showing the GUID of the record that has invalid date and what is the problem: <br/>
Exception in thread main java.lang.RuntimeException: java.lang. <br/>
RuntimeException: java.sql.SQLException: Value '''c864-643e-146fa97d9a1-b2809c03-1-caeb''' <br/>
{BaseData-WorkbenchStatus-00000-00004} MAG-Y2014-M06-024<br/>
c864-6410-13b0996d203-a7ad6e50-3-7b7f 2014-06-04 00:00:00 2014-07-03 08:01:26<br/>
'''0000-00-00 00:00:0''' M. Kabir 2014-07-03 2014-08-29 13:04:09 imsma <br/>
can not be represented as java.sql.'''Timestamp'''
<pre>
SELECT