SAP Knowledge Base Article - Preview

1869086 - Error during serializing: XACT_ABORT option was set to OFF

Symptom

You observe one of the following issues:

  • Error message during serialization, which includes "A nested transaction was required because the XACT_ABORT option was set to OFF."
  • Execution of ODS scripts fails with the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: Unable to start a nested transaction for OLE DB provider "SQLNCLI11" for linked server "ODSLINK". A nested transaction was required because the XACT_ABORT option was set to OFF.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
at com.sap.me.ods.database.ODSBaseDataSource$StatementWrapper.executeUpdate(ODSBaseDataSource.java:1187)
at com.sap.me.frame.jdbc.DynamicQuery.executeUpdate(DynamicQuery.java:860)
at com.sap.me.frame.AbstractSqlImplementation.executeUpdate(AbstractSqlImplementation.java:76)
at com.sap.me.frame.AbstractDataSource.executeUpdate(AbstractDataSource.java:303)
at com.sap.me.ods.olap.ODSBase.ODSExtract(ODSBase.java:1312)

  • SFC Split fails with the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: Unable to start a nested transaction for OLE DB provider "SQLNCLI11" for linked server "HSMEIPODSDB". A nested transaction was required because the XACT_ABORT option was set to OFF.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
 at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397)
 at com.sap.me.frame.jdbc.DynamicQuery.executeUpdate(DynamicQuery.java:860)
 at com.sap.me.frame.AbstractSqlImplementation.executeUpdate(AbstractSqlImplementation.java:76) 


Read more...

Environment

  • SAP Manufacturing Execution (MFG-ME)
  • WIP and ODS databases created in MS SQL Servers are set up with linked servers.

Product

SAP Manufacturing Execution all versions

Keywords

visiprise, serialize, XACT_ABORT, split, ODS, MFG-ME, MFG-ME-PRD-ODS, OLE DB provider , KBA , MFG-ME , SAP Manufacturing Execution , MFG-ME-PRD-ODS , Operational Data Store , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.