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

Digital_Ranchu

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?

Digital_Ranchu

Any one has any suggestion?

SriniVEERAVALLI

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

Digital_Ranchu

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

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

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

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

Digital_Ranchu

Srini,
my email is the following... "[email protected]"

Digital_Ranchu

Have anyone encountered this issue?

Digital_Ranchu

bump to see if anyone encountered this.