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.

3 comments:

  1. Hey buddy!

    I'm trying to do this now. I'm trying to integrate a simple analysis into a "portal" and we want to be able to a session variable. I created a simple analysis with one column whose source is the session variable. Navigating there with the Go URL stuff, like this:

    http://myserver.com:9704/analytics/saw.dll?Go&Action=navigate&path=/shared/Archive/CDJ/Session_Variable_Test&SETLOCNUM=00070

    In the authenticatedschemas.xml file I have this:



    That's under the Group for HTTP POST login comment

    When I run the report via that URL, it displays the default value, and not the one I'm trying to set (00070). Did I have to turn something on somewhere?

    ReplyDelete
    Replies
    1. Chet please send me your post and the authenticatedschemas.xml section to rockitcitytechnologies@gmail.com as it didn't come through on the post. You can also give me a call my number is the same.

      Thanks

      Mike

      Delete
    2. I'm having the same problem as Chet: I have a portal that is navigating to dashboard with GO URL. We had a variable in authenticationschemas.xml to update the WEBLANGUAGE session variable. This works OK. Now I added another one for a custom session variable, but it doesn't get updated? I always see the default value...

      Delete