Imagine the scenario where your system was migrated from one server to another. The OS used was changed. In order to keep SAL data, you have moved SAL files from the original system to the new system. However, you have no results in your SM20 reports. What happened? How to resolve this issue?

Big versus Little?

Usually the code page from the server changed. You may also have changed from a big endian system to a little endian one, from your favorite Unix flavor to your favorite Linux flavor (or vice-versa). You can read more about what “endian” means in SAP note 552464.

You can use transaction code I18N to view the current internationalization system configuration:

I18N.jpg

Then you can find the code page of your system. In my test system, it is 4103 (Windows Server).

My source system have code page 4102 (AIX). Yes, you need to check the I18N system configuration in both systems, so you have the correct code pages.

The issue: moving one SAL file from the source system to the new system, and reading the file via report RSAU_SELECT_EVENTS shows:

RSAU_SELECT_EVENTS-1.jpg

The file size is more than 20 Megabytes and no entry found? Who would think that a simple code page change would cause such effect!

How to resolve the issue?

The short version: file conversion.


The long version: use report RSCP_CONVERT_FILE. It allows you to specify source and target code pages, specify the location of the files.


Note that you need to specify one file that contains the list of files that should be converted.

My file “list.txt” holds the list of files that I want to convert. For test purposes, I just put a single row in the list.


The input screen is this one:


RSCP_CONVERT_FILE-1.jpg

The result of the file conversion:


RSCP_CONVERT_FILE-2.jpg

Now, the result of RSAU_SELECT_EVENTS:


RSAU_SELECT_EVENTS-2.jpg

 

Additional Information

539404 – FAQ: Answers to questions about the Security Audit Log

747615 – Tool for converting files from one code page to another

752859 – sapiconv – a tool for converting the encoding of files

Do not miss the most comprehensive document on SAL that I ever found, available here: “Analysis and Recommended Settings of the Security Audit Log (SM19 / SM20)”.

If you have missed my previous blogs on SAL:

Stay tuned for my next blog series on… surprise, surprise! 😎

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply