Can't Access Webi Through Live Office

[DellSC]

BOBJ Version: BIP 4.2 SP7 Patch 4
Live Office Version: BIP 4.2 SP7
RESTful Web Services installed in Tomcat instead of running in WAC

One of my clients is having an issue that I am able to duplicate. In Excel, she is able to log in to the CMS through Live Office. However, she is unable to get data from any Webi report. She gets a RWS 00005 Not Found error. Searching for this error code only seems to bring up things about Lumira. She is able to run the Webi in BI Launchpad with no issues.

Because of the "RWS" in the error code, I'm assuming this is an error with a call to the RESTful Web Services. Using SOAPUI to connect to the RESTful web services, I'm able to get the X-SAP-LogonToken with no issues. I then put the token from the response header into the request header after removing the quotation marks and try to get details of the document she's trying to open, but for some reason it's saying that the token is invalid. I'm not sure whether this is what is causing the error in LO or whether there is something else going on.

What should I be looking at to try to figure this out?

Thanks!

-Dell

[DellSC]

I should also probably mention that we're using WinAD authentication for this.

[denis_konovalov · Accepted solution]

Live office gets into CMS via dswsbobje and not restful, but then restful is part of webi refresh workflow.
Check if following is helpful :

https://launchpad.support.sap.com/#/notes/2619641
Also, make sure correct restful URL is set in CMC.

[DellSC · Accepted solution]

Thanks denis.konovalov, I implemented this over the weekend and I'm waiting for the user to test so that we can verify whether it will work.

-Dell

[DellSC · Accepted solution]

This did not resolve the issue. 😞

I'm going to look at a few other things to see whether the issue might be with one of the (many) Webi docs that are being pulled into the report.

-Dell

[denis_konovalov · Accepted solution]

Try creating new LO document based on sample webi report. This should show if the issue is with Reports or LO/Restful.

[DellSC · Accepted solution]

The issue is definitely with RESTful. See my new question here: https://answers.sap.com/questions/12909014/42-sp7-webi-restful-web-service-issue.html.

Thanks!

-Dell

[denis_konovalov · Accepted solution]

I'd say it warrants a proper SAP support investigation. I'd start with BI-RA-WBI component and see where it takes it.