Skip to Content
0
Former Member
Sep 19, 2008 at 01:23 PM

Strange error in File-XI-JDBC scenario

16 Views

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