BO 4.1 report errors out

[Former Member]

Please help me out with below issue

We have a .net web application accessing BO 4.1 CMS server with SP2 through BO SDK for .net to display existing reports from BO Server and we have below environment

QA Setup =>   .NET app server 1 + BO Server 1

PROD Setup => .NET app server 2 + BO Server 1

in above combination BO reports works as expected from PROD setup but getting below in consistency while accessing the reports from QA box

1. Getting "Problem with server's security certificate" from QA instance of the app but the same BO server works fine from PROD. (verified the server certificate and its valid for another 4 years)

2. after showing java applet window for a while report errors out and just display JRE runtime error without giving much debugg info

3. browser profiler shows data getting downloaded on the client browser but still errors out

we are generating the token as shown below and direct report URL ( with .jsp to call apache server) is passed to load the report to an iFrame.

        if (!ValidateToken(currentToken))

        {

            SessionMgr ses = new SessionMgr();

            EnterpriseSession es = ses.Logon(AppSettings.BusinessObjectsUser, decrypter.DecryptString(AppSettings.BusinessObjectsPass), AppSettings.BusinessObjectsUrl, "secWinAD");

            LogonTokenMgr myToken = es.LogonTokenMgr;

             return myToken.CreateLogonTokenEx("", 1440, -1);

     }

Could you please suggest how to make this work.

Regards

ANoop

[Former Member]

Hi All,

Attaching the snapshot of webi report error returned on the application and trace returned on IE 9 developer tool

1. webi report error

2. Trace returned on IE 9 developer tool

as the same BO server render the webi report on other asp.net application with same configuration, is there any way to find either from BO server or the location machine why the report error out... ?

[DellSC]

What is your code for loading the report to view it?  When do you see the "security certificate" error?  Is it during the call to view the report or is it elsewhere in your app?

-Dell

[Former Member]

Hi Dell,

To access BO report below code is used.

<iframe height='300px' width='300px' frameborder='0' src='../../opendoc/openDocument.jsp?iDocID=ok5yIDEACo62WYkAPwmDK7EimT0></iframe>

Security certificate error pops-up while pasting the OpenDoc url with idocid on browser to test the BO report accessibility.

Regards

Anoop

Message was edited by: Ludek Uher

[Former Member]

Hi Anoop,

Are you concerned about security error or something else (Sorry, it is not very clear with your original post)? You might already be aware bout this but still.... -

If it is security error, it normally comes when there is a problem with Server certificate generation and in such cases the error would be displayed by browser as part of SSL handshaking (check on which CA you used to generate the server certificate and for which host was it generated).

Regards

Sumitesh

[former_member188030]

Hi Anoop,

Once you run the code hitting QA server, do you see a session count going up by 1 for the user in CMC?

What happens when you simply copy the OpenDoc URL, paste it in browser address bar, set the idocid and hit enter? Does it prompt for launchpad logon? Does it show the report?

What version of SDk is installed on the QA App server? It hs to be the same patch level as the server.

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

[Former Member]

Hi Bhushan,

While pasting the OpenDoc url with idocid on browser, it will prompt with "Problem with server's security certificate" and on accepting this warning  launch pad prompt will be displayed and subsequently report getting displayed. This particular security issue warning happen while accessing the report URL from india but when same url accessed over VM desktop from US this certificate issue not getting popped-up.

we are using BI Platform .NET SDK for BI Platform 4.0 Support Pack 2

Regards

Anoop

[former_member188030]

Hi Anoop,

This does not look like an SDK specific issue, could be the authentication.

Is it a WInAD SSO setup with your QA BO server?

If yes, what happens when you simply open the launchpad? do you get the same warning?

Also, as Dell asked, while running the app where do you exactly see the warning, in browser window? Could you attach a snapshot of the error?

-Bhushan

[Former Member]

Hi Bhushan,

Please find the response in-line

Is it a WInAD SSO setup with your QA BO server? - Yes , using Oracle Web gate

If yes,

what happens when you simply open the launchpad? do you get the same warning? - No warning while accessed from Launch pad

while running the app where do you exactly see the warning, in browser window?  - Yes on the browser window

Could you attach a snapshot of the error? - please find below

Anoop