Monday, 26 November 2012

OBIEE xmlpserver URL Login Issue

Issue with URL http://121.10.19.56:9704/xmlpserver
Unable to login to BI publisher through administrator user getting the below error:
oracle.apps.xdo.security.ValidateException



●● Change the Following file:
/obieeapp/oracle/OBIEE2/OracleBI/xmlp/XMLP/Admin/Configuration/xmlp-server-config.xml


Change No#1:
Old:
<property name="SECURITY_MODEL" value="BI_SERVER"/>
New:
<property name="SECURITY_MODEL" value="XDO"/>

Change No#2:
Old:
<property name="BI_SERVER_SECURITY_URL" value="jdbc:oraclebi://mkkobieesrv1:9703/"/>
New:
<property name="BI_SERVER_SECURITY_URL" value="jdbc:oraclebi://121.10.19.56:9703/"/>


Basically these are the relevant files to look into, in our case we changed only in xmlp-server-config.xml:
$ORACLE_HOME\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF\xmlp-server-config.xml
$ORACLE_HOME\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml
$ORACLE_HOME\xmlp\XMLP\Admin\Security\principals.xml


●● Shutdown all BI Related Services.
●● Assuming your OBI admin user is, 'Administrator' and its password is 'Administrator', Run the cryptotools utility to add 'bipublisheradmin' user alias
cd <OracleBI>/setup
. ./sa-init.sh >>> Use this instruction when you are running OBIEE 32-bit
. ./sa-init64.sh >>> Use this instruction when you are running OBIEE 64-bit
<OracleBI>/web/bin/cryptotools credstore -add -inFile <OracleBIData>/web/config/credentialstore.xml -alias bipublisheradmin -username Administrator -password Administrator -passphrase admin

/obieeapp/oracle/OBIEE2/OracleBI/web/bin/cryptotools credstore -add -inFile /obieeapp/oracle/OBIEE2/OracleBIData/web/config/credentialstore.xml -alias bipublisheradmin -username Administrator -password Administrator -passphrase admin
●● Start all BI Related Services.

No comments:

Post a Comment