Error when importing metadata with OBIEE 12c Admin Tool using variables

3240307

Any assistance is appreciated.

Thanks!

Joel

The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to

        <DOMAIN_HOME>/config/fmwconfig/bienv/core

Joel

The Admin tool uses its own tnsnames file. Create or copy your tnsnames.ora file to

/config/fmwconfig/bienv/core

Sent from my iPhone

3240307

Joel,

I have tried that already after reading one of the support Doc IDs. It works just fine if the actual DSN and username is entered instead of the variables. But with the variables it doesn't for some reason. Thoughts?

rmoff

Hardcode the connection details, import your metadata, and then switch the connection back to variable-based.

3240307

Is that the only way? I'm doing that already but it becomes cumbersome after a certain number of imports.

Thanks for taking the time to respond.

[Deleted User]

You can script that...

3240307

Some pointers on how to script that piece would help. Thanks Christian.

Joel

Something along these lines:

http://www.rittmanmead.com/2011/11/obiee11g-scripting-–-generate-xudml-and-change-the-password-of-the-connection-pools/

Andrew Fomin.

A proof for what @rmoff said: OBIEE 11g Information About the Use of Variables in the Connection Pool (Doc ID 1925713.1)

PS. I know that this note is for 11g, but the cause won't change for 12c

[Deleted User]

Yeah you already got 2 pointers. I thought the input was enough to google "obiee script connection pool"...