Joined: Wed Dec 02, 2009 14:34 Posts: 1
|
|
Hi
I was trying to sftimport (2.3) the default app in app-v 4.5. I got this error:
******
Softgrid version 4.5 detected
Trying to import application: DefaultApp MFC Application
The Softgrid package has been added to the SQL Server.
Application name : defaultapp
Date has been adjusted: 10-13-2009 15:10:37
An error occured...
Error number : 48015
Error description : SQL reported the following error:
Number : 242
Message : The conversion of a char data type to a datetime data type result
ed in an out-of-range datetime value.
The statement has been terminated.
*****
I was wondering why the 'date has been adjusted' came. A trace on the sql server showed that sftimport takes the OSD file creationtimestamp and validates it in a non-nordic way. Soo the 13/10 (13th oct) become the 10 of well known number 13 month of the year. We are using nordic settings on the database. It is not enough to change the regional setting of the app-v server to 'English(us)' (we are using danish default). With English the sql insert timestamp change format - but it still not accepted by the database. If I change the creation timestamp to 12/10 - it works well and there is no adjustment.
Can you give me an other workaround rather than:
1) change the database layout to English
2) set the creationtimestamp to eg. 1/1
KR Henrik, DK
|
|