Hi,

I have a JDBC which gets the error below:

INSERT statement from JDBC LOG:

2010-03-09 10:36:32 Information

INSERT INTO TABLENAME (COLUMNS, COLUMNS, COLUMNS, COLUMNS, COLUMNS, COLUMNS, COLUMNS) VALUES (444444001, 2010, '20100104 00:00:00' , 00444444, NULL, NULL, 0033333, 'XXXX')

*2010-03-09 10:36:32 Error Could not execute statement for table/stored proc. "TABLENAME" (structure "STATEMENT") due to com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting datetime from character string.

2010-03-09 10:36:32 Error Adapter Framework caught exception: null*

I tried all kind of formats. Like '2010-01-04', '2010.01.04', '2010-01-04 00:00:00', 2010-01-04 etc. but no result.

The field in MSSQL is DATETIME. My field in PI is string (also tried datetime).

Any idea?

> I tried all kind of formats. Like '2010-01-04', '2010.01.04', '2010-01-04 00:00:00', 2010-01-04 etc. but no result.

Have you tried below format?

2010-01-04, 103632 (use comma to separate date and time stamp and in time stamp do not use colon) because when you are using curent date then your format looks like this one.. try this.

Regards,

Sarvesh

Hi,

Tried it, not working.

When I give in the mapping the currentDate function then it works???

This works:

INSERT INTO GIDEN_FATURALAR (COLUMNS, COLUMNS, COLUMNS, COLUMNS, COLUMNS, COLUMNS) VALUES (33333, 2010, 2010-03-09, 333333, NULL, NULL, 33333, 'BEKİR ERGENÇ')

When I try my date, which is in the same format (according to JDBC log) it gives an error?

SAP PO : Multipart/form-data error when sending attachment through REST receiver adapter in Technology Q&A 3 hours ago Latest Pipeline Concept enhancements: Custom error handling and others in Technology Blogs by SAP Thursday SWNC_COLLECTOR_GET_AGGREGATES in Technology Q&A Wednesday Configure SAP Integration Suite, Advanced Event Mesh Distributed Tracing in Technology Blogs by SAP Wednesday Integration of SAP S/4HANA with SAP Integration Suite, advanced event mesh (AEM) using AIF in Technology Blogs by SAP a week ago