Corrupt BEx workbooks - How to recover

[Former Member]

Hi experts

I read this blog:

http://scn.sap.com/docs/DOC-49135

Under item 4 the ENTIRE content of this temp-folder should be deleted.

My question: If you only have one corrupt workbook, the rest work fine, wouldn't the deletion of the whole content of this folder that all workbooks get deleted?

How does the mechanism look like?

Where are the workbooks physically stored?

Thanks

[arvind_doomra · Accepted solution]

Dear Thomas,

Thanks for referring to my document..
generally when you execute the workbook on your system, it is stored in the temp folder in your system. Physically the metadata of the workbook is stored in BW system in tables like

RSRWBINDEX	List of binary large objects (Excel workbooks)
RSRWBINDEXT	Titles of binary objects (Excel workbooks)
RSRWBSTORE	Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE	Assignment of Excel workbooks as personal templates
RSRWORKBOOK	Where-used list for reports in workbooks

Generally we recommend to delete the contents of temp folders very frequently.
It does not affect the execution of the workbook if the contents of the folder are deleted.

Regards,
Arvind

[Former Member · Accepted solution]

Dear Arvind

Thanks a lot for your reply.

We access the SAP Gui through Citrix environment.

Can you please clarify this item more in detail?

Open the workbook in a new Excel session without BEx Add-in 

Thanks

Thomas

[arvind_doomra · Accepted solution]

Dear Thomas,

Please maintain add the registry String Value "LoadAddinsOnStartup" with value "True" to key

"HKEY_CURRENT_USER\Software\SAP\BEx\Analyzer" in the registry (using

regedit) and let me know your results.

Thank you,

[Former Member · Accepted solution]

Dear Arvind

Open the workbook in a new Excel session without BEx Add-in

We have added the string value into the registry of the user with the corrupt workbook.

I still don't understand what you mean by open the workbook without BEx Add-in.

Sorry.

Thomas

[arvind_doomra · Accepted solution]

Dear Thomas,
I am sorry.. I misunderstood your question. Apologies..

Open the workbook in a new Excel session without BEx Add-in   MEANS.. when you double click the excel from the temp folder.. make sure that BEx analyzer should not be started .. we donot need BEX Analyzer here.. we need to work with only excel. In other words.. you should not see the Add-in Menu  Option in Excel.
You can achieve this by first closing BEx Analyzer session opened if anyand then start workbook from temp folder..

Please let me know if I could make my self clear..

Regards,
Arvind

[cornelia_lezoch]

Hi Thomas,

the workbooks are stored on the BW server.

So if you folloe the blog, in step 4 you only delete local copies on your PC.

All workbooks including the corrupted one will still be untouched on the BW server.

Only in the last step, where the blog requests you to save the local workbook back to the server, any workbook in BW will be overwritten.

regards

Cornelia