Skip to Content
avatar image
Former Member

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Apr 11 at 03:45 AM | 44 Views

Hi,

I am having ECC (IDOC) to JDBC scenario.

While sending below data from SAP PI to JDBC server, i am getting following error :

Error:-

Unable to execute statement for table or stored procedure. 'KPMG_RETN_DATE' (Structure 'Table') due to com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Payload :-

Please find attached payload.

I am passing date in - ' yyyy-MM-dd HH:mm:ss.mmm' format

can you please help what is the issue?

Is the issue is with ECC or SAP PI or JDBC server?

payload.png (11.7 kB)
SAP Process Orchestration
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 11 at 04:04 AM

    Hi Kushal,

    Is this an inbound scenario to SAP ECC? are you using standard field mapped for the date time interval field. The standard SAP timestamp field doesnot have 'mmm' in the format.

    Regards,

    Aswath.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12 at 09:59 AM

    It is SAP (IDOC) to JDBC sever scenario.

    Issue is solved now.

    In the input payload, i was receiving date as 00000000(YYYYMMDD) due to which it was failing to update at JDBC server.

    Add comment
    10|10000 characters needed characters exceeded