OBIEE 11g No tables in Datasource View when doing Import Metadata

Note: The title of this post is little broken semantically. I did it intentionally so that this is SEO friendly. Might be a foiled attempt, but I just tried.

Now the post. Issue:

You tried to import metadata, gave the connection information, clicked on next and the screen you reach the screen “Select the metadata objects you want to import into the physical layer of the repository”

You don’t find any tables as shown below:

One of the following will fix it for you:

1. If your client PC is 64 bit, install Oracle 64 bit client
2. If your database is 11gR2, install oracle 11gR2 client
3. If your database is 11gR2 and client PC is 64 bit, install 64bit 11gR2 client
4. If your database is 11gR2 and client PC is 32 bit, install 32bit 11gR2 client

How do you diagnore the error:

Go to C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication

There will be file _NQSAdminTool.log

You might find an error message something like this:
“[2012-07-05T11:05:19.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 98c] [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found.”

There might be other reasons for the failure. Look for the log file and see the error. If the log file is not there, you may need to patch it to 11.1.1.6.2 BP1.

OBIEE 11g Import Metadata connection fails with “Connect Failed” in AdminTool

This post is related to OBIEE 11.1.1.6 or later. Not sure if this fix will work in earlier versions

In online mode, when I was trying to File > Import Metadata and use connection type as “OCI 10g/11g”, I got the following error message:

From 11.1.1.6 onwards, even in online mode, the AdminTool relies on your local PC’s TNS_ADMIN/tnsnames.ora.

Make sure you verify the connectivity to the database using the right credentials. Also add an environment variable TNS_ADMIN in the “System Properties”. Once you do that it will work.

Remember!! “Connect Failed” is a generic message and it could happen for reasons other than stated above. Another reason could be you are entering wrong username/password.

In order to know the exact error message, navigate to

“C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication” and look for the NQSAdmin_.log

You will likely to find the reason there. If you don’t find the log files, probably you are not in the latest version of 11.1.1.6.2 BP1.

Hope this will benefit somebody!!

OBIEE Authentication Error after Environment Migration

I migrated our 11g OBIEE enviroment from one environment to another. After migrating the RPD and the catalog, when I tried to login I was getting the following errors:

"Unable To Sign In" An error occurred during authentication.  Try again later or contact your system administrator.

I immediately logged into the server and checked for error messages in log files. I saw the following in nqserver.log:

The GUID of user 'weblogic' does not match user reference GUID at the repository. Please ask the administrator to delete the old user reference at the repository and login again

In order to fix it I had to follow the steps to “Refresh Global Unique Identifiers (GUIDs)” from Fusion Middleware Administrator Guide. The version I am using is 11.1.1.6. The steps is slightly different for each version of OBIEE.

For 11.1.1.6, the steps to be followed are

1. Edit NQConfig.INI and change setting FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO to YES.

2. Edit instanceconfig.xml to enable GUID refresh on restart.

   false

Comment out the line and add an extra line as follows:

   
   UpdateAndExit

3. Use opmnctl to restart the process using stopall and startall

4. After restart, revert the changes. Set FMW_UPDATE_ROLE_AND_USER_REF_GUIDS to YES.

   false
   

5. Restart the services again.

After the above steps, we were able to login successfully.

The link for the above steps was from:
http://docs.oracle.com/cd/E23943_01/core.1111/e10105/testprod.htm#BABFBIBG