OWB Data Profiling Fails With ORA-01729: database link name expected

(Doc ID 800077.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to profile, the following error occurs:

java.sql.SQLException: ORA-01729: database link name expected
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
at oracle.wh.repos.pdl.mcm.MCMUtils.executeQuery(MCMUtils.java:146)
at oracle.wh.repos.sdk.dataProfile.ProfileStats.drop(ProfileStats.java:339)
at oracle.wh.service.impl.dataProfile.load.ProfileLoadingServiceImpl.drop(ProfileLoadingServiceImpl.java:990)
at oracle.wh.service.impl.dataProfile.load.ProfileLoadingServiceImpl.load(ProfileLoadingServiceImpl.java:1097)
at oracle.wh.service.impl.dataProfile.load.ProfileLoadingServiceImpl.load(ProfileLoadingServiceImpl.java:937)
at oracle.wh.ui.dataprofile.ProfileTransaction.run(ProfileTransaction.java:181)
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

 

Cause

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 hundreds of Community platforms