SAP Knowledge Base Article - Preview

3156999 - Live Office Insert chart fails with error occurred when refreshing. (LO 26315)

Symptom

In Office365 Excel with Live Office, insert Web Intelligence, 

  • Inserting a CHART from any WebIntelligence document (including charting sample) gives an error -
    An error occurred when refreshing. (LO 26315)
    Click on details, we get: Failed to get the document information. (LO 26315) ! and WIFormatNumber.noCategoryDefined! (LO 26315)
  • Inserting a TABLE from any WebIntelligence document works fine.
  • All URLs including dswsbobje and biprws are front-end Apache Webserver URLs
  • After enabling LiveOffice debugging logs according to KBA 1384988, the dswsbobje.log [ either found in default tomcat folder or tomcat/bin folder] 

     2022-01-06 16:18:10,634 [http-nio-9080-exec-10] ERROR com.businessobjects.dsws.liveoffice.rest.RequestHelper () 119357 - sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    ......
    ......
    2022-01-06 16:26:14,467 [http-nio-9080-exec-9] ERROR com.businessobjects.dsws.liveoffice.rest.RESTProcessor () 99200 - while trying to invoke the method com.businessobjects.dsws.liveoffice.rest.RequestHelper$Response.getConnection() of a null object loaded from a local variable at slot 4
    java.lang.NullPointerException: while trying to invoke the method com.businessobjects.dsws.liveoffice.rest.RequestHelper$Response.getConnection() of a null object loaded from a local variable at slot 4
     at com.businessobjects.dsws.liveoffice.rest.RESTProcessor.getObjectId(Unknown Source)
     at com.businessobjects.dsws.liveoffice.rest.RESTProcessor.<init>(Unknown Source)
    ......
    ......

    2022-01-06 16:26:14,467 [http-nio-9080-exec-9] ERROR com.businessobjects.dsws.liveoffice.rest.RESTProcessor () 99200 - Unable to get document id (LO 26300)
    com.businessobjects.liveoffice.modules.webi.WebiException: Unable to get document id (LO 26300)
     at com.businessobjects.dsws.liveoffice.rest.RESTProcessor.getObjectId(Unknown Source)
     at com.businessobjects.dsws.liveoffice.rest.RESTProcessor.<init>(Unknown Source)

     


Read more...

Environment

SAP BusinessObjects BI Platform 4.3 Support Pack 1 Patch 3 [14.3.1.3803.3]
SAP BusinessObjects Live Office 4.3 SP1 Patch 3
Server OS Version: Redhat Linux 7
CMS Database: Oracle 19c
Deployment Type : Clustered and distributed with Tomcat servers separated 
Microsoft Excel for Microsoft 365 MSO (16.0.13127.21210) 64-bit
Front End web server: Apache web server 2.x [HTTPS / SSL enabled ]
Apache WS redirects requests to Tomat 

 

 

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

KBA , BI-BIP-LO , Live Office , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.