OBIEE 11G – Error in Importing Metadata :“The connection has failed”

If you get the error “The connection has failed” when you try to Import Metadata into the RPD, this post may help you to resolve it. There could be n number of reason behind this, but this is of the solution.

We need to create an Environment Variable called NLS_LANG.

Follow this procedure to set the NLS_LANG environment variable for Oracle databases.

To set the NLS_LANG environment variable for Oracle databases

1. Determine the NLS_LANG value.
   1. In the data warehouse database, run the command
   SELECT * FROM V$NLS_PARAMETERS
   2. Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
      For example: American_America.UTF8

 

      2. For Windows:

1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
2. In System variables section, click New.
3. In the Variable Name field, enter NLS_LANG.
4. In the Variable Value field, enter the NLS_LANG value that was returned in Step 1.
   The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
   For example: American_America.UTF8.

 

    3. For UNIX, set the variable as shown below:

setenv NLS_LANG <NLS_LANG>

For example: setenv NLS_LANG American_America.UTF8.

If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set

NLS_LANG <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1

CAUTION:  Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly

 

 

    4. Reboot the machine after creating the variable.

 

 

Enjoy and Stay Well !! :)