E-MSS/AE: Linked Server SQL Fails With Error "Unable to start a nested transaction for OLE DB provider "MSOLEDBSQL" for linked server"
(Doc ID 2885056.1)
Last updated on MARCH 17, 2023
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.
After upgrading from PeopleTools (PT) 8.56.07 to 8.59.08, a custom Application Engine (AE) program run fails when executing a SQL step with a DB vendor specific statement "SET XACT_ABORT ON". The error message farther down is see in the Process Monitor.
1. Create a linked server in MS SQL server to another SQL server (e.g. WIN2012R2STD).
2. In Application Designer, open the delivered sample AEMINITEST AE program, and in the SQL step, add the SQL below and save the AE program.
Upgraded to PT 8.59.08.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document