SAP Knowledge Base Article - Public

2306483 - "Failed to upgrade this document (LO 01400) - Invalid pointer" error displayed in Dashboard designer when trying to upgrade document

Symptom

  • "Failed to upgrade this document (LO 01400) - Invalid pointer" error displayed in Dashboard designer when trying to upgrade document 
  • The dashboard has several Live Office connections 

LO 01400.png

  • The document was created in XCelsius 2008
  • How to upgrade XCelsius 2008 file into Dashboard 4.x with Live Office Connections?

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.1 SP6
  • SAP BusinessObjects Business Intelligence Live Office 4.1 SP6
  • Microsoft Office Excel

Reproducing the Issue

  1. Launch Dashboard Designer 4.x
  2. Open the document was created in XCelsius 2008 
  3. Click Refresh All on the Live Office ribbon (toolbar) and if necessary, log on to SAP BusinessObjects Business Intelligence platform.You are prompted to upgrade, press Ok
  4. The Live Office application start the conversion of the document
  5. After several minutes the error message displayed.

Cause

  • In the Live Office application a timeout is reached during the upgrade
  • The upgrade of the Live Office document must be done outside of the dashboard designer

Resolution

  1. Upgrade the dashboard file from version 3.1 to version 4.1 (Open your xlf file in dashboards 4.x and save it under a different filename)
  2. Export the embedded spreadsheet data sheet to excel file choosing the Data->Export men
  3. Close Dashboard desinger 
  4. Follow the instrunctions of SAP KBA 2265017 and extend the Live Office client timeout up to 60-120 minutes 
  5. Open exported excel sheet in Microsoft Excel
  6. Upgrade the LO content of the Excel file by pressing "Refresh All" button on the live office ribbon
  7. After the successfull upgrade of the Live office document, save the excel file
  8. Open Dashboard desinger
  9. Click on Data->Connections menu to open the Data manager window
  10. Record all Live Office connections and mappings in Data Manager 
  11. Remove all Live Office connections from the Dashboard file 
  12. Close the Data Manager window
  13. Save the file
  14. Click on Data->Import and select the upgraded live office excel workbook for imporing to the embedded spreadsheet
  15. Click on Data->Connections menu to open the Data manager window
  16. Import upgraded Live Office connections and re-do the mappings 
  17. Compile the dashboard 

Keywords

Live Office, LO, upgrade, grey ribbon, refresh all, unable to modiy object,Dashboards, live office connection, LO 01400, invalid pointer, how to upgrade , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , BI-BIP-LO , Live Office , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2