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
- 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
- Launch Dashboard Designer 4.x
- Open the document was created in XCelsius 2008
- 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
- The Live Office application start the conversion of the document
- 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
- 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)
- Export the embedded spreadsheet data sheet to excel file choosing the Data->Export men
- Close Dashboard desinger
- Follow the instrunctions of SAP KBA 2265017 and extend the Live Office client timeout up to 60-120 minutes
- Open exported excel sheet in Microsoft Excel
- Upgrade the LO content of the Excel file by pressing "Refresh All" button on the live office ribbon
- After the successfull upgrade of the Live office document, save the excel file
- Open Dashboard desinger
- Click on Data->Connections menu to open the Data manager window
- Record all Live Office connections and mappings in Data Manager
- Remove all Live Office connections from the Dashboard file
- Close the Data Manager window
- Save the file
- Click on Data->Import and select the upgraded live office excel workbook for imporing to the embedded spreadsheet
- Click on Data->Connections menu to open the Data manager window
- Import upgraded Live Office connections and re-do the mappings
- 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