My Oracle Support Banner

EXTRACT CONNECTOR USES WRONG LKM DURING EXECUTION (Doc ID 2717793.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Metadata_ofss

Though connector property 'Do you want to use Data Pump?' or 'Do you want to use DBLink?' is set to 'NO', connector execution fails with below error. Here we see, 'LKM Oracle to Oracle (datapump)' is used instead of 'LKM SQL to Oracle'.

ERROR
-----------------------
ODIAgent.log
------------
DI-1298: Serial task "SERIAL-EU-FSDFINFO_UNIT (20)" failed because child task "Create Oracle directory on TARGET-LKM Oracle to Oracle (datapump)- (40)" is in error.
ODI-1228: Task Create Oracle directory on TARGET-LKM Oracle to Oracle
(datapump)- fails on the target connection EDS_SCUSA_FAH_STG.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to execute connector

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully execute the connector.

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!


In this Document
Symptoms
Cause
Solution
References


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