Skip to Content
avatar image
Roopa Puranik

SAP BI 4.2 SP5 Fiori BILaunchpad

Jan 12, 2018 at 08:17 PM | 2.3k Views | Last edit Jan 12, 2018 at 08:38 PM 3 rev.

Our Env: BI 42 SP5, Linux Red hat OS, 2 tomcat servers, 2 CMS servers, LB URL

I upgraded from 42 SP4 to SP5

Configured the restful URL to use tomcat host and port in CMC > Application > Restful so that we can use the RWS on the tomcat via the LB url and not on the WACS server.

I left the default version of biprws.properties as is on the tomcat server.

I am able to login to BILaunchpad but when I try to access any webi reports I get "Not Found (RWS 00005)" error.

Please advise!! If there is there is any documentation around this please share that.

Thanks in advance!

SAP BusinessObjects - Platform Infrastructure | SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

10 Answers

  • Best Answer
    avatar image
    Bharath B N
    Jan 18, 2018 at 02:00 PM

    Please check this package.


    screen-shot-2018-01-18-at-141344.png (656.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Roopa Puranik
      Jan 17 at 07:56 PM

      Hello Bharath, We have a problem with our BI Launchpad fiori in prod. In test everything is fine. What we are seeing is the fonts are not aligned properly, Data in cells of a chart are defaulting to show top alignment but are set to Center, When selecting to "Open in Designer", nothing happens and when setting option for "Advanced" mode. I see the option to sort but when I click on it I get errors. (WSR 00999)

      Any idea? Thanks in advance for your help!

  • avatar image
    Bharath B N
    Jan 15, 2018 at 05:42 AM

    Hello Roopa,

    you mentioned 2 tomcat servers :

    1. CMS is there in both the machines where tomcat deployed.

    2. Please verify manually REST SDK deployment is proper in both the tomcat servers :

    by hitting below url to both the tomcat servers (use any REST Client : Postman , RESTClient.....)

    http://<machine>:<tomcat_port>/biprws/raylight/v1/about

    https://blogs.sap.com/2017/04/21/session-management-in-bi-platform-rest-sdk-rws/

    Make sure both the tomcat server giving response for the WEBI APIs.

    -

    Bharath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Bharath B N
    Jan 17, 2018 at 08:36 AM

    Hello Roopa,

    Looks like WEBI REST SDK is not deployed properly.

    http://<machine>:<tomcat_port>/biprws/raylight/v1/about (This is WEBI REST API)

    http://<machine>:<tomcat_port>/biprws/v1/about (This is Platform REST API)

    As per your comment - WEBI API is giving "Resource not found".

    So, Make sure REST APIs are working fine in both the tomcats first. Then you can configure to load balancer.

    So please check the deployment of biprws in both the Tomcats.

    Path : C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\biprws\WEB-INF\eclipse\plugins (Installation path might be different in your landscape "***********\tomcat\webapps\biprws\WEB-INF\eclipse\plugins" )

    check the below package is exist.

    -

    Bharath


    screen-shot-2018-01-17-at-140149.png (665.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Roopa Puranik
      Jan 17, 2018 at 03:37 PM

      Bharath,

      I don't see this PKG. I thought ..by default RESTful web services will be deployed in the BI 4.2 SP05 full build and patch build. I do see this pkg on our cms server.

      What do I have to do to deploy this? Can I copy the war file from CMS server to Tomcat server or do I have to use WDEPLOY? We are on Linux env. Just wondering why it did not get deployed during the upgrade? I did an upgrade from SP4 to SP5.

      Thanks!

    • Bharath B N Roopa Puranik
      Jan 17, 2018 at 05:50 PM

      Please copy this com.sap.webi.raylight.jar to tomcat webapps folder - "*******/tomcat\webapps\biprws\WEB- INF\eclipse\plugins"

      And Restart Tomcat .

      Test by hitting below URLs

      http://<machine>:<tomcat_port>/biprws/raylight/v1/about (This is WEBI REST API)

      http://<machine>:<tomcat_port>/biprws/v1/about (This is Platform REST API)

    • Roopa Puranik Bharath B N
      Jul 12, 2018 at 03:41 AM

      Hi Bharath,

      The error is back again in PROD not sure why?

      Error: Logon failed for RESTful Web Services. Contact system administrator.

      It was working!! We are on 4.2 SP5. I have both the jar files (raylight and repoaccess) you had mentioned on both the tomcat servers. Everything is working fine in DEV and QA.

      In CMC > the Restful WS is set to https://<lb url>/biprws When I test this url or raylight/v1/about or biprwsv1//about in a browser I get this error.

      HTTP Status 500 – Internal Server Error

      capture.png

      Any idea?

      Thanks so much for your help!

      capture.png (77.1 kB)
    • Bharath B N Roopa Puranik
      Jul 12, 2018 at 05:51 PM

      Hi Roopa,

      1. After upgraded to SP05 in production it stopped working ?
      2. Tomcat version and SP05 patch number ?
      3. need to check tomcat logs - looks like not deployed properly.
      4. Please take backup of folder biprws in tomcat/work/catalina/localhost -> delete it in work folder ->restart the tomcat once.

      -

      Bharath

    • Roopa Puranik
      Jan 17, 2018 at 07:29 PM

      Bharath,

      Okay I will do that and let you know. Thank You so much.

    • Roopa Puranik
      Jan 17, 2018 at 08:11 PM

      Bharath,

      I copied the war file and restarted tomcat. I don't think its working. Please see attached file.

      In CMC > Access URL > I set it to: http://<tomcat host>:8080/biprws (If I try the access in the browser I get response back.)

      http://<tcat host>:8080/BOE/BILaunchpad -- I get account not recognized. I am also not seeing the authentication drop down. I do have bing.properties file and set default auth to secLDAP.

      Thanks!

      webi-rest-api.png

      platform-rest-api.png

      webi-rest-api.png (10.6 kB)
      platform-rest-api.png (12.2 kB)
    • Roopa Puranik
      Jan 17, 2018 at 08:14 PM

      war-file.png

      access-url.png

      war-file.png (5.8 kB)
      access-url.png (16.2 kB)
    • Bharath B N Roopa Puranik
      Jan 17, 2018 at 08:21 PM

      "********\tomcat\work\Catalina\localhost\biprws\eclipse\plugins"

      Please check once here "com.sap.webi.raylight.jar" is listed. if not please stop tomcat and take backup of "biprws" war from work folder or rename it like "birws_backup" and restart tomcat.

      -

      Bharath

    • Roopa Puranik
      Jan 17, 2018 at 08:30 PM

      My bad..Yea I should have checked that! Let me try and will let you know.

    • Roopa Puranik Roopa Puranik
      Jan 17, 2018 at 08:46 PM

      I see the war file now under local host but still the same issue :(

    • Roopa Puranik
      Jan 17, 2018 at 09:54 PM

      Some findings:

      Well I read the SP5 Release guide and under restrictions section it says: https://help.sap.com/viewer/53bc7eda3cf7470199ce18aa970117cf/4.2.5/en-US/a013d51393034ad9bc416c537134cf8c.html In BI 4.2 SP5, “Bing.properties” file is renamed to “FioriBI.properties” file. When you update or upgrade to BI 4.2 SP5 from any older version, you need to manually change the name of the Fiorified BI Launch Pad properties file from “Bing.properties” to “FioriBI.properties”, to retain the existing configurations for the Fiorified BI Launch Pad.

      I renamed the properties file to “FioriBI.properties” and restarted tomcat. I can now see the auth drop down and I was able to login and also refresh a webi report with no issues when I had the access url set to http://<cms host>:8080/biprws

      ------------------------------

      I tried these options:

      -----------------------------

      Set acces url in cms: http://<tcat host>:8080/biprws

      then tried this link in the browser1: http://<tcat host>:8080/BOE/BILaunchpad able to login but get "Not Found (RWS 00005)" error running a web report

      then tried this link in the browser2: http://<tcat host>:8080/BOE/BILaunchpad hangs at the login

      ----------------------------------------------

      Set acces url in cms: https://<LB url>/biprws

      via browser: https://<LB url/BOE/BILaunchpad > I am able to login > but I get Not Found (RWS 00005) err.

      ------------------------------------------------

      Set acces url in cms: https://<tcat host>:8443/biprws (as our tcat listens on port 8443)

      then tried this link in the browser1: https://<tcat host>:8443/BOE/BILaunchpad > able to login but get "Not Found (RWS 00005)" error running a web report

      tried this link in the browser2: https://<LB Url>/BOE/BILaunchpad able to login but got Not Found (RWS 00005)

      ----------------------------------------

      Set acces url in cms:http://<cms host>:8080/biprws browser : https://<lb url>/BOE/BILaunchpad > login hangs in IE but get this error in Chrome: Logon failed for RESTful Web Services. Contact system administrator.

      then tried this link in the browser: http://<tcat host>:8080/BOE/BILaunchpad Login ok > reports refreshed ok

      but I need to be able to use LB URL to access the BILaunchpad and run reports ok.

      Thanks!!

    • Bharath B N Roopa Puranik
      Jan 18, 2018 at 03:35 PM

      For Chrome : please clear browser catch and open the new BI Launchpad.

      This looks like deployment issue of biprws on tomcat. please check these 2 jars are listed in tomcat webapp else copy manually and restart tomcat. (com.sap.webi.raylight.jar and com.businessobjects.plugins.RepoAccess.jar)

    • Roopa Puranik Bharath B N
      Jan 24, 2018 at 10:27 PM

      Hi Bharath,

      Just wanted to let you know that if you do an upgrade from 42 SP4 or SP3 to 42 SP5 on Tomcat server (web deploy only) these 2 war files do not get deployed. I tried this on another machine and same issue was noted. I had to manually copy the war files. After the upgrade I also did a modify install and chose the RWS but still the war files were not there. I guess the update files need to be fixed!!

      Thanks!

      P.S. I will try a full install on our tomcat server and see how that goes.

      As per this article RESTful web services should be deployed on tomcat.

      blog.png

      blog.png (18.2 kB)
  • avatar image
    Denis Konovalov
    Apr 18, 2018 at 08:17 PM

    SAP asknowledged the problem with SAP Note 2619641 - Restful SDK does not work after doing a web tier only install in BI 4.2 SP5

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Bharath B N
    Jan 15, 2018 at 04:52 AM

    Hello Roopa,

    1. Please watch the network trace while opening webi report - Which API is giving this error (Status 404 or 500) like http://<host>:<port>/biprws/raylight/v1/********** ?

    2. Is same things works fine with WACs serve ?

    -

    Bharath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    E. Ocula
    Jan 26, 2018 at 09:25 AM

    Hi, we had the same problem : after upgrading from BI 4.2 SP3.2 to BI 4.2 SP5, the file "com.businessobjects.plugins.RepoAccess.jar" was not available.

    We have copied it from another environment (on which BI 4.2 SP5 was installed with a full-install from scratch), restarted Tomcat and afterwards it was working

    To SAP-Folks : I believe a SAP-Note must be created on this one !

    Eddy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Yogesh Patel
    Jan 12, 2018 at 08:31 PM

    Hello Roopa,

    This what I have found on SAP Help. Hope this helps you

    Ref: https://help.sap.com/viewer/015ba64bc9ad45f28e5118852c69a10b/4.2.5/en-US/4629b50a6e041014910aba7db0e91070.html

    Not Found (RWS 00005)

    Cause
    The specific resource could not be found. Either the resource does not exist or you do not have the permissions to view it.

    Action
    Verify that the URL you used was correct. If you're trying to view an InfoObject, use the Central Management Console (CMC) to verify that you have the right to view that object.

    Thank you

    Yogesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Denis Konovalov
    Jan 12, 2018 at 08:38 PM

    If you simply trying to open webi report then this error is not related to restful service at all, because restful is not used in the workflow of opening webi reports.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Roopa Puranik
    Jan 16, 2018 at 08:37 PM

    Hi Bharath,

    I guess, what is the configuration when you have Load balance URL with SSL enabled that talks to 2 tomcat servers (where WACS is deployed and tomcat servers that talk to 2 CMS servers). Our users need to be to able to login via LB URL to access BILaunchpad and access webi reports.

    1. What Access URL you need to set in CMC Restful WS Application?
    2. Our tomcat listens on port 8443 (port 80 redirects to 8080 and 8080 are open as redirects to 443 and 443 forwards to 8443)

    Any help would be appreciated. Thanks!

    I feel like SP5 still has issuses with WACS on tomcat.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    TEAM SAP
    Sep 20, 2018 at 12:57 PM

    hollo Bharath

    i need your help can you help me how to consume sap business object to sap fiori launchpad,

    Add comment
    10|10000 characters needed characters exceeded