1580078 - Error: 'server busy' when importing an excel file in Xcelsius

SAP Knowledge Base Article - Public

1580078 - Error: 'server busy' when importing an excel file in Xcelsius

Symptom

  • Unable to import an excel file
  • Error : 'Server Busy: The action cannot be completed because the other program is busy'

Reproducing the Issue

  1. Launch Xcelsius
  2. Import an XLF file
  3. Go to Data > Import
  4. select an excel file
  5. Click on Import

==> error is displayed and does not allow to proceed

Cause

The error is caused by the Excel compatibility checker which is triggered in the background.

Because the Excel 2007 file has Excel 2003 format cells, it triggers the compatibility check when opening/saving it. When importing such Excel file in Xcelsius, the compatiblity check is triggered. This causes a new Excel process to be spawned and the server busy message to appear. Xcelsius does not take into account that the compatiblity check was deactivated in Excel and always triggers the Compatibility Check

 

Resolution

  1. Open the Task Manager
  2. Select the 'Excel compatibility checker'
  3. Click on Switch to
  4. Click OK

If you want to disable the compatibility checker in Excel:

  1. Go to Excel options
  2. On the File tab, click Info
  3. Click Check for issues
  4. Click Check Compatibility
  5. Clear the Check compatibility when you save this workbook box.

Keywords

The action cannot be completed because the other program is busy, compatibility checker , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008