SAP Knowledge Base Article - Public

2474603 - "Error writing to document; document data was removed before saving" occurs when scheduling Analysis workbook

Symptom

The scheduling of Analysis workbook is failing.

In Instance Manager, the error is "An error occurred; could not precalulcate instance <XXX> : Error writing to document; document data was removed before saving" as shown below:

Error instance manager.png

The entries below can be found in the traces:

>> If option 'Remove Data Before Saving' is set, the workbook is not precalculated!
>> Finished. Return code: 45

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

Try to schedule an Analysis workbook in BI Launchpad.

Resolution

Step 1

Open the workbook in Analysis for Office client version and make sure that the option "Remove Data Before Saving" is unchecked like shown below, then save the workbook again to BI platform:

uncheck option.png

 

Step 2

Open the workbook in Analysis for Office, check if the variant that was saved before exist and check if it is accepted when pressing the OK button, when use the scheduling option.
If it is not accepted, please correct prompts and re-save the variant.

Step 3

It can also happen that the prompts are set on BO and should be checked if it is correct there before scheduling the workbook from the BO platform. Check the scheduling settings for the "Prompts" option. Check which variant is set or if the filled prompts are correct before scheduling the workbook.

 2979389 - How to enter the variable values when scheduling Analysis Workbooks in BI platform

See Also

2462012 - Scheduling failed with error "CreateProcess error=87, The parameter is incorrect."

2134836 - Checklist for Scheduling of Analysis for Office Workbooks

Keywords

code 45, scheduling, schedule, fails, failing, failed, precalculate, delivered, error , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions