Skip to Content
Former Member
Apr 10, 2009 at 05:46 PM

Error in Xi while calling the stored procedure



Our scenario is SAP --- XI -

SQL Server

We are sending material data to SQL server from SAP.

we sent the materials (say 100 numbers) from sap, The status of the messages are SYSTEM ERROR'.

below is the error.

Delivery of the message to the application using connection JDBC_ failed, due to: Error processing request in sax parser: Error when executing statement for table/stored proc. 'usp_LOAD_SAP_MATERIAL' (structure 'STMT_MATERIAL'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction..

and when i resent the failed messages again,they went through (success)

What may be problem,why the messages went to system error first,and when resend the failed messages they went thorogh.(success).