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?
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.
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.