My Oracle Support Banner

'ODI-1228: Task LKM MSSQL to MSSQL (LINKED SERVERS) (Add linked server) fails on the target MICROSOFT_SQL_SERVER connection' Signaled when Running ODI 12c Mapping Using LKM MSSQL to MSSQL (LINKED SERVERS) (Doc ID 1909089.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

When executing an ODI version 12.1.2 Mapping using the LKM MSSQL to MSSQL (LINKED SERVERS) to load data from a Microsoft SQL Server source database to a Microsoft SQL Server staging area database using the native linked servers feature, the following messages are observed in ODI Operator:

LKM step Drop mapped login for linked server, shows warning: 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.