Page 1 of 1

Error - Default value (systimestamp) is not valid for DateTi

Posted: Tue 01 Dec 2009 00:18
by Emily
Default value (systimestamp ) is not valid for DateTimeOffset. The value must be in the form 'yyyy-MM-dd HH:mm:ss.fffffffz'.

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

I just upgraded to the latest dotConnect version (5.35) and when using the latest EF Developer (2.50.50), I get the above error when dropping a table from Oracle with a timestamp field. This error was not being generated in the previous version.

FYI, the field in the Oracle table has default value set to 'systimestamp' and is of type 'TIMESTAMP(6) WITH TIME ZONE'.

Posted: Tue 01 Dec 2009 14:36
by AndreyR
Thank you for the report.
I will let you know about the results of our investigation.

Posted: Wed 09 Dec 2009 20:55
by Emily
Devart,

Any update on this issue? With this error in place, I can't seem to use your EDM Designer due to always erroring out.

Posted: Thu 10 Dec 2009 16:36
by AndreyR
We are working on this issue.
I will let you know as soon as it is fixed.

Posted: Thu 10 Dec 2009 16:43
by AndreyR
As a temporary workaround you can clear the default value and set StoreGeneratedPattern to Identity in your Entity Framework model.

Posted: Fri 15 Jan 2010 21:23
by Emily
I just downloaded the latest version today and this problem still persists. Any update on this issue?

Posted: Mon 18 Jan 2010 10:55
by AndreyR
I will let you know as soon as the problem is fixed.

Posted: Fri 29 Jan 2010 15:19
by AndreyR
The problem is fixed. Look forward to the next build.