OBIA 11g 'ODI-10199: Incorrect ODI username or password' Error Message Received Despite Using Valid Credentials Being Used In BI Extender Wizard (Doc ID 1961741.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

BI Extender 11.1.1.7.0 fails with the following error when importing Fusion Apps metadata :-

<success>false</success>
<error>ODI-10199: Incorrect ODI username or password.


Log file shows the correct usernames :-

parameter name="MasterUserName" value="JDWFA_BIAPPS_ODIREPOSITORY_USER"/
parameter name="MasterPassword" value="????????" secure="true"/
parameter name="WorkRepositoryName" value="BIAPPS_WORKREP"/
parameter name="OdiUsername" value="JDW_OBIA_ETL_USER"/
parameter name="OdiPassword" value="????????" secure="true"/

biextension.properties.  :

db.connection.type = url
db.connection.repository = jdwfa_biapps_odirepository
db.connection.dbname = jdwbidatabase
db.connection.host = xxxx.oracle.com
db.connection.port = 1522
db.connection.dsn = jdwbidb
db.connection.driver = oracle.jdbc.driver.OracleDriver
db.connection.url = jdbc:oracle:thin: xxxx.oracle.com:1522:jdwbidatabase
db.connection.ssl_enabled = false

odi.connection.sdk.masterdriver= oracle.jdbc.driver.OracleDriver
odi.connection.sdk.masterurl= jdbc:oracle:thin:@xxxx.oracle.com:1522:jdwbidatabase
odi.connection.sdk.workrepositoryname= BIAPPS_WORKREP


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms