Our scenario is SAP --- XI -
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_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: 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).