Skip to Content
author's profile photo Former Member
0
Former Member

Corrupt BEx workbooks - How to recover

Posted on Dec 08, 2014 at 02:56 PM 312 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Arvind Doomra
    Arvind Doomra
    Posted on Dec 09, 2014 at 09:52 AM
    3

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Arvind Doomra Former Member
      Dec 09, 2014 at 12:21 PM

      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

    Comment on This Answer
  • author's profile photo Cornelia Lezoch
    Cornelia Lezoch
    Posted on Dec 08, 2014 at 04:34 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.