Connection Failed Error - Import Data(11g)

In OBIEE10g no need to copy tns file in BIHome.But in OBIEE11g you need to copy in BIHome also.If you not copy this tns file then you will get “The connection has failed” error while trying to import data from the database using OCI call interface" in RPD.

To resolve above error you need to perform the below steps.
1. Add the tnsnames.ora file in the BI Home DirectoryEnsure, you add all the data source tns entry details in the tnsnames.ora file
You need to copy same tnsnames.ora file from Oracle Home (Root directory: \App\User\Product\Network\Admin) and paste the file to the below location in OBIEE11g directory
1. \OBIEE11g\Oracle_BI1\network\admin and
2.\OBIEE11g\oracle_common\admin

2. Add the tnsnames file location path in User.cmd file
Add the tnsnames file location path from one of the above location in the user.cmd file. The user.cmd file is found in the below location
Root directory: \OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

  

 I hope it will works now.Otherwise close RPD and restart the services.Then it will works.Restarting of services are suggestable.