import fails with invalid representation of date/time value

[Anjana Prakash <an...@actian.com>]

Hi,

I have exported data from an derby database. On same machine I am trying to import this data to another database that has same table structure.
However the import fails with exception
ERROR XIE0R: Import error on line 1 of file D:\derby\data\wincluster: The syntax
of the string representation of a date/time value is incorrect.
ERROR 22007: The syntax of the string representation of a date/time value is incorrect.

Not sure why the export is successfully but same data import to another table is failing. There are no modification done to timestamp value.

Appreciate guidance on same.

Thanks,
Anjana.

Re: import fails with invalid representation of date/time value

[Bryan Pendleton <bp...@gmail.com>]

> 0|'2015-12-04 10:11:30.611'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04 10:11:30.611'|8|0||'No cluster'|'Non-existing cluster'
> 1|'2015-12-04 10:11:37.748'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04 10:11:37.748'|8|0||'after import'|'Cluster for all pre-existing instances'
>
> The record 0 start from line 1.
>
> -----Original Message-----
> From: Bryan Pendleton [mailto:bpendleton.derby@gmail.com]
>
>> ERROR XIE0R: Import error on line 1 of file D:\derby\data\wincluster:
>> The syntax of the string representation of a date/time value is incorrect.
>
> What's on line one of that file?

Can you try modifying the file? Perhaps create a simple subset (the
first 10 lines or so), and experiment with it?

For example, try removing the single quote marks around the dates,
and see if that causes the dates to be processed successfully.

My import files are typically comma-separated; I assume that you
have set the delimiter to '|'?

thanks,

bryan

RE: import fails with invalid representation of date/time value

[Anjana Prakash <an...@actian.com>]

Hi, 

Below are the contents of the file

0|'2015-12-04 10:11:30.611'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04 10:11:30.611'|8|0||'No cluster'|'Non-existing cluster'
1|'2015-12-04 10:11:37.748'|0|'2015-12-04 10:11:30.611'|8||'2015-12-04 10:11:37.748'|8|0||'after import'|'Cluster for all pre-existing instances'

The record 0 start from line 1. 

Thanks,
Anjana


-----Original Message-----
From: Bryan Pendleton [mailto:bpendleton.derby@gmail.com] 
Sent: 04 December 2015 19:57
To: derby-dev@db.apache.org
Subject: Re: import fails with invalid representation of date/time value

> ERROR XIE0R: Import error on line 1 of file D:\derby\data\wincluster: 
> The syntax of the string representation of a date/time value is incorrect.

What's on line one of that file?

bryan

Re: import fails with invalid representation of date/time value

[Bryan Pendleton <bp...@gmail.com>]

> ERROR XIE0R: Import error on line 1 of file D:\derby\data\wincluster: The syntax
> of the string representation of a date/time value is incorrect.

What's on line one of that file?

bryan