EXTRACT CONNECTOR USES WRONG LKM DURING EXECUTION
(Doc ID 2717793.1)
Last updated on FEBRUARY 27, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.0.7 and laterInformation 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 |