Cache Monitor: BW_OLAP_CACHE Parameter Missing

[Former Member]

Dear BW Mates

I run transaction RSRT and when I click on Cache Monitor,

I have information of RAM on Local, global caches.

Along with them I have error as below.

<b>Error: Flat File Name : BW_OLAP_CACHE <SYSID> Parameter Missi</b>ng

Does this have any impact on queries....

OR should I re install the BEx on my System.

Your help is appreciated.

Thanks,#

SB.

[Former Member]

Hi,

Check the relevance of OSS note below if any.....I don't think it should be a problem.

791065

Symptom

You cannot use the OLAP cache with flat files or the system returns a result but the relevant monitor does not display any entries.

When you start the cache monitor and select the flat file view, the program may terminate (with short dump).

Other terms

OLAP cache, flat files, settings, use, cache monitor

Reason and Prerequisites

Some settings for the flat files, for example, the names of the flat files and of the relevant directories as well as the cache parameters were not adjusted to the current system. Therefore, the files cannot be used or they are stored incorrectly.

Solution

You must implement various changes:

Change the cache parameters: Choose the "Cache parameters" pushbutton to go to the settings of the general cache parameters. Here, you should see or enter the following settings:

Flat file name: BW_OLAP_CACHE

For all files: BW_OLAP_CACHE_SPAN

Choose the "Logical file name" button to go to the area where you can adjust the logical file names and directory paths. The already displayed table at the right side of the window matches the "Definition of logical file paths" folder in the tree at the left side of the window. To maintain the settings for the "BW_OLAP_CACHE" and "BW_OLAP_CACHE_SPAN" table entries, you must select each entry that is to be changed and double-click on the "Assignment of logical path and physical paths" folder (subfolder of "Definition of logical file paths") at the left side of the tree. This section often contains incorrect entries.

BW_OLAP_CACHE:

Often, it contains the following entry:

Physical path: "/usr/sap/J16/SYS/global/<FILENAME>".

However, "J16" must be replaced with the ID of the current system.

Example: The "XYZ" system must contain the following entry:

Physical path: "/usr/sap/XYZ/SYS/global/<FILENAME>".

The same applies to the settings of "BW_OLAP_CACHE_SPAN". Here, you must also replace "J16" in the path with the name of the current system.

Bear in mind that, currently, both variants of the cache with flat files write to the directory.

This directory may be a directory on a network volume.

Subsequently, you must also adjust the logical file names. By double-clicking on the "Definition of logical file names client-independent" folder in the tree at the left side, you call another table in the main window at the right side. By double-clicking on "BW_OLAP_CACHE" or "BW_OLAP_CACHE_SPAN", you can open the relevant settings.

"BW_OLAP_CACHE" must contain the following entry:

Physical file: "CACHE_<HOST>_<SYSID>_<PARAM_1>"

"BW_OLAP_CACHE_SPAN" must contain the following entry:

Physical file: "CACHE_<SYSID>_<PARAM_1>"

You should also check in transaction RSCUSTV14 whether the "FILENAME" and "FILENAME_SPAN" fields are filled as follows:

FILENAME = BW_OLAP_CACHE

FILENAME_SPAN = BW_OLAP_CACHE_SPAN

[Former Member]

Hi AVR,

Thanks for your reply. I aasigned points.

Thanks,

SB

[Vladimir_Z]

Hi All,

Points described above helped me to resolve error : Flat File Name : BW_OLAP_CACHE <SYSID> Parameter Missing.

Resolution was pretty simple, and required to add to Logical file name BW_OLAP_CACHE (via T-Code FILE) missing <SYSID> definition.

Thanks,

Vladimir Zinkevich