JDBC Insert Error field type: DateTime

[Former Member]

Hello everybody,

I am getting a error from MS SQL:

<i><SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'tb_eai_events_state' (structure 'Statement1'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]<b>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.</b></SAP:AdditionalText></i>

when trying to insert (bold marked):

- <access>

<OBJECT_KEY>79187</OBJECT_KEY>

<EVENT_ID>100066</EVENT_ID>

<OBJECT_NAME>NOVOMIND_CRM_AUSGANGSMAIL</OBJECT_NAME>

<OBJECT_VERB>Create</OBJECT_VERB>

<b> <STATE_TIME>2006-09-13 14:57:27.000</STATE_TIME></b>

Any ideas

Regards Mario

[Former Member]

by any chance, do you have your regional settings set to a date / time format with which the value 2006-09-13 14:57:27.000 does not comply?

[bhavesh_kantilal]

mario,

Did you have a look at this blog?

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

thanks. I knew this already.

Unfortunately this is ORACLE and not MS SQL.

Regards Mario

[bhavesh_kantilal]

Mario,

Can you try this by using the Datatype as date instead of String in XI for the datatype.

Also, TO_DATE can be used to convert your date as per the requirement.

Use the blog as a refernce to use hasQuot.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

a) I added the attribute <i>hasQuot</i> --> error still occurs

b) I change the type of element from <i>dateTime</i> to <i>String</i> --> error still occurs

Regards Mario

[Former Member]

Hello all!

MS SQL does not accept: 2006-09-13

but it accepts: 2006-13-09

Format must be YYYY-DD-MM

Thanks and regards

Mario