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.