Forum Stats

  • 3,838,955 Users
  • 2,262,429 Discussions
  • 7,900,818 Comments

Discussions

OBIEE login screen comes up in a CRM imbed report after OBIEE server restar

I have some imbedded reports in Siebel CRM side. Everytime we do a server restart like to implement a rpd, afterwards when you go the imbedded reports in CRM side the OBIEE stand alone login screen comes up. If i hit refresh the login screen disappears.

I ran the following test
a) Do a OBIEE server restart
b) Run the following URL for the stand alone and before doing a server restart it takes me directly to the reports since this URL has my ID/ PWD
http://<server>:<port>/analytics/saw.dll?Dashboard&PortalPath=/shared/All AIM/_Portal/Wholesaler&Syndicate='Siebel'&nqUser=nguyeth&nqPassword=<your_pass>&Cmd='PortalPages'
c) Run the URL after the server restart and login screen comes up, but if i do a IE refresh it takes me directly to the report.

Conclusion, this problem seems to be on the OBIEE side, not the integration of CRM and OBIEE.

Versions
OBIEE 11.1.1.6.2 , CRM 8.1.1.7

Any suggestions?

Answers

  • Any one has any suggestion?
  • SriniVEERAVALLI
    SriniVEERAVALLI Member Posts: 8,539 Gold Crown
    edited Feb 7, 2013 6:16PM
    I dont think so. You have to login back to Siebel since your BI session (thru Siebel) is ended with service restart.
    On Refresh behaviour--> Since you are embedding the report name besides credentials its taking to the report

    Mark if helps, let me know if needed

    Edited by: Srini VEERAVALLI on Feb 7, 2013 5:16 PM
  • Srini,
    thanks for replying. But even if I do the following i still get the login issue.

    a) Restart OBIEE services.
    b) Login CRM Siebel
    c) Go to the imbedded report, i get the login screen the initial time after the service restart.
    d) If hit the report tab again, and refresh even though i didn't put any credentials in it lets me it.
    e) The problem dissappears until the next service restart.

    thanks
    Thomas
  • SriniVEERAVALLI
    SriniVEERAVALLI Member Posts: 8,539 Gold Crown
    If I know how you integrated I might tell why... just in case if integrated both as per oracle docs? you wont get these issues

    a) Restart OBIEE services-->Expected
    b) Login CRM Siebel -->When you go to Answers tab in Siebel you should authorize to see answers, it should not prompt login screen
    c) Go to the imbedded report--> Assuming you are using url based as mentioned earlier, need to go for OOB integration
    i get the login screen the initial time after the service restart-->Expected
    d) If hit the report tab again, and refresh even though i didn't put any credentials in it lets me it.-->url is submitting again to get your report
    e) The problem dissappears until the next service restart.

    If helps mark and let me know updates
  • Digital_Ranchu
    Digital_Ranchu Member Posts: 11
    edited Feb 8, 2013 10:17AM
    Srini,
    As far as integration i did the OOB configuration of integration documented by Oracle. I had to update NQHOSTHOME and NQHOST under Host administration in the CRM side. When you say "i get the login screen the initial time after the service restart--> *Expected*", are you saying this is a expected behavior? Just curious because we didn't have this behavior in 10g.
    below is the doc i used for integration.

    http://docs.oracle.com/cd/E28271_01/bi.1111/e16364/siebel_crm_integration.htm


    thanks
    thomas

    Edited by: Digital_Ranchu on Feb 8, 2013 7:17 AM
  • SriniVEERAVALLI
    SriniVEERAVALLI Member Posts: 8,539 Gold Crown
    edited Feb 8, 2013 10:30AM
    Yes, that is due to Siebel is not taking care to send credentials to BI server. I doubt on your integration (correct me if I'm wrong).
    I've tested this case with 10g: Loged into Siebel-> BI Answers-> Restarted BI services refresh or any link in Answers its pops up a message to relogin.

    You'll be giving entries like below thats it to get Answers from Siebel, the rest is Siebel to pass credentials to BI server.

    <Location /analytics>
    ProxyPass http://myserver:9704/analytics
    ProxyPassReverse http://myserver:9704/analytics
    </Location>

    BTW: have done as below?
    http://docs.oracle.com/cd/E23943_01/web.1111/e16435/isapi.htm#BGBBCFID

    Can you share your email?

    Edited by: Srini VEERAVALLI on Feb 8, 2013 9:29 AM
  • Srini,
    my email is the following... "[email protected]"
  • Have anyone encountered this issue?
  • bump to see if anyone encountered this.
This discussion has been closed.