OBIA 11g Database Link Mode for OBIA fails with ORA-01729: database link name expected
(Doc ID 1675180.1)
Last updated on JANUARY 31, 2017
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.7.1 and laterInformation in this document applies to any platform.
Symptoms
OBIA 11.1.1.7.1
Configuration for ODI DB Link fails
After following the steps described in the Blog section - Database Link Mode
When running a test load plan, the first SDE scenario (SDE_PSFT_91_ADAPTOR_SDE_PSFT_DOMAINGENERAL_CUSTGRP) fails with this error:
ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01729: database link name expected
Caused By: java.sql.SQLSyntaxErrorException: ORA-01729: database link name expected
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 |