Connection Failed - Unable to import Metadata in OBIEE RPD

When we try to import metadata into the new rpd in obiee 11g, we may face the following error.

Solution

  Step:

1.    Copy the tnsnames.ora file from Oracle Database.

Path : C:\oracle\product\10.2.0\db_1\network\ADMIN

2.    paste the file to the below location in OBIEE11g directory
C:\OBIEE11g\Oracle_BI1\network\admin
C:\OBIEE11g\oracle_common\admin

3.    Add the tnsnames file location path in User.cmd file

4.    User.cmd path C:\OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

5.    Closed you’re RPD and reopen late

6.    After doing this I am able to import the data from oracle database.