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">>

       "<<database.tempdate>>"

else

       "<<lastUpdate>>"

>>

>>

INSERT INTO SycloExchangeTable

VALUES

('<<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 14:56:29#+0530#ERROR#com.sap.mobile.platform.server.agentry.console##anonymous#Agentry 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

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