Skip to Content

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

Strange error in File-XI-JDBC scenario

Dear All,

I am working currently on File-XI-JDBC scenario and is facing with a stange problem.

I have writtern one simple query which is downloading the data from R/3 and is sending to XI Server local folder. From that folder File is getting picked by XI and is posted into SQL database.

Now, when I am generating the required file from R/3-DEV server then my scenario is getting executed successfully but if file is generated thru R/3-QAS Server then the scenario is giving the following error "Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MARA_UPDATE' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Error converting data type nvarchar to smalldatetime."

Also, if I am copying the complete data from the error file and paste it into a new file and executing again then the scenario is executing correctly.

I have checked the payload and didn't find anything there.

Kindly help me in solving this error.

Regards,

N.J

Helpful Answer

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