Skip to Content
Former Member
Nov 07, 2013 at 12:23 PM

Sap BODS - Error in insert sql


Hi Expert,

We are executing daily job in production bods server. It throws data base error as follows.

SQL submitted to ODBC data source <Server\database> resulted in error <[Microsoft][SQL Server Native Client 10.0][SQL Server]

Conversion failed when converting date and/or time from character string.>.

The SQL submitted is <INSERT INTO"db"."Table" ("field1", "Date_From", "field2" )

VALUES ( 'IN', CONVERT(DATETIME2, '0050-48-49 51:45:49.0029492', 121), 0.00)

We are using sql server 2008 for target tables. And source is Sap tables.

But when we try to load manually in test server(ms sql 2008) using template table and same production data from target(sap tables). It is loading without error.

Original value in database for Date_From = 2013.11.06 01:43:34.390000000

It is using for insert command for target database(from above sql error) = 0050-48-49 51:45:49.0029492

Please give me valid input for solving error.