Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conversion error while inserting client data into SycloExchangeTable

While inserting client data using client exchange step  in main fetch I am using sql as back end.

The sql query is :

<<local lastUpdate=<<if <<eq <<lastUpdate format="%Y">> "0000">>






INSERT INTO SycloExchangeTable


('<<object.CustId>>','<<user.agentryID>>','<<server.serialNumber>>','<<lastUpdate format="%Y-%m-%d %H:%M:%S">>',NULL)

when I click on transmit I got this error

2015 06 04 Runtime Worker Thread###Exception: 14:56:29 06/04/2015 : 16 (SQLBEException), SQLQueryError (Fetch "MainFetch" ClientExchange "InsertExchangeStep", 3: SA_DBMS_API_Error, DB Code: 241, DB Text:22007 [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting date and/or time from character string., ), query.cpp#145:SQLQuery::run |

Please help me in resolve the error

Not what you were looking for? View more on this topic or Ask a question