Thursday, May 16, 2013

Porting GoURL parameters from 10g to 11g


During a recent port from an existing 10g environment to an 11g environment ran into a  issue where the Go URL was being used to link to OBI from another application but there were more parameters that were defined in the Go URL for security. So the config in 10g was the following in the instanceconfig.xml file:

<Auth>
<UserIdPassword enabled="true">
<ParamList>
<Param name="NQ_SESSION.securityVariable"
source="url"
nameInSource="securityVariable"/>
</ParamList>
</UserIdPassword>
</Auth>


Alright so I look to see if 11g has the same instanceconfig.xml tags...nope. Adding these into 11g config caused the Presentation Service not to start....so after some research I found that those Parameters have to be placed in a totally different file details of my finding below:

a.) Went to authenticationschemas.xml file located in
C:<MW_HOME>\Oracle_BI1\bifoundation\web\display

b.) Made copy of authenticationschemas.xml file

c.) Look for line <!-- Group for HTTP POST login -->

d.) Found the <AuthenticationSchemaGroup> right under the above.

e.) You would be 3 xml lines as below.
<RequestVariable source="url" type="auth" nameInSource="NQUser" biVariableName="UID" options="trim" /><RequestVariable source="url" type="auth" nameInSource="NQPassword" biVariableName="PWD" options="secure"/><RequestVariable source="url" type="proxyUserAuth" nameInSource="RUNAS" biVariableName="NQ_SESSION.RUNAS" />

f.) Added the new line below with the existing configs : Saved the file
<RequestVariable source="url" type="auth" nameInSource="securityVariable" biVariableName="NQ_SESSION.securityVariable"/>

g.) Restarted all the OBI Services and the world is right again.