Skip to Content
0

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

17

avatar image
Kushal Shah

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
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Aswatha Narayana SA Answered Apr 11 at 04:04 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Kushal Shah Answered Apr 12 at 09:59 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users