Link invalid date - Revision history

Alnaucler at 10:13, 3 May 2015

2015-05-03T10:13:58Z

@@ Line 8: / Line 8: @@
 '''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>
 <pre>
 SELECT

Alnaucler at 10:06, 3 May 2015

2015-05-03T10:06:54Z

← Older revision		Revision as of 12:06, 3 May 2015
Line 1:		Line 1:
			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>		<pre>
	SELECT		SELECT

Dionysia at 08:35, 13 February 2014

2014-02-13T08:35:54Z

← Older revision		Revision as of 10:35, 13 February 2014
Line 10:		Line 10:

	</pre>		</pre>

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 16:51, 12 February 2014

2014-02-12T16:51:40Z

← Older revision		Revision as of 18:51, 12 February 2014
Line 1:		Line 1:
	<pre>SELECT		<pre>
			SELECT
	link.data_deletion_date,		link.data_deletion_date,
	link.data_entry_date		link.data_entry_date
Line 10:		Line 11:
	</pre>		</pre>
	[[Category:NoPublic]]		[[Category:NoPublic]]
			[[Category:SQL Queries]]

Alnaucler: Created page with "

SELECT link.data_deletion_date, link.data_entry_date FROM link WHERE link.data_deletion_date =  '0000-00-00 00:00:00' OR link.data_entry_date =  '0000-00-00 00:00:00'  
2014-02-10T15:59:20Z
Created page with "<pre>SELECT link.data_deletion_date, link.data_entry_date FROM link WHERE link.data_deletion_date =  '0000-00-00 00:00:00' OR link.data_entry_date =  '0000-00-00 00:00:00'  </..."
New page
<pre>SELECT

link.data_deletion_date,

link.data_entry_date

FROM

link

WHERE

link.data_deletion_date =  '0000-00-00 00:00:00' OR

link.data_entry_date =  '0000-00-00 00:00:00'



</pre>

[[Category:NoPublic]]