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

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)

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

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